Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Schlesien]]
SQL Query
SELECT DISTINCT
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Schlesien') AND t1.p_id=963)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
0
t0.smw_id AS id,
t0.smw_title AS t,
t0.smw_namespace AS ns,
t0.smw_iw AS iw,
t0.smw_subobject AS so,
t0.smw_sortkey AS sortkey, t0.smw_sort
FROM
`smw_object_ids` AS t0
INNER JOIN
`smw_di_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Schlesien') AND t1.p_id=963)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
55
OFFSET
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 583 | Using index condition; Using temporary; Using filesort | |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rupp.t1.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
NoneA
-
Adam, Adam , Theologe
- Adam, Johann Georg (*1685 †1752), Jesuit Studium
- Ade, Johann (Costau) , Studium
- Ade, Nikolaus , Studium
- Adloff, Sebald (*1528 JL)
- Alberti, Melchior , Lehrer Pfarrer Schulmeister
- Alberti, Valentin (*1635 †1697), Professor Studium Theologe
- Albin, Dominik , Jurist Studium
- Albin, Johann (Johnsdorf) , Arzt Mediziner Studium
- Albin, Johann Christoph , Studium
- Albini, Lorenz Raphael , Studium
- Amerimnus, Martin , Geistlicher Pfarrer Studium
- Amoricus, Johann , Studium
- Arlenus, Jakob , Studium
- Ashelm, Kaspar Ignaz , Studium
- Augustin (Breslau) ( †1487 JL), Benediktiner Mönch Prior
- Augustin, Joseph (Breslau) , Schüler
A Fortsetzung
-
Aurifaber, Andreas (Breslau) , Mediziner
B
-
Bansch, Fabian , Priester
- Bartolus, Thomas , Studium
- Barwitz von Fernelmont, Johann Wenceslaus (*1659 †1722), Studium
- Baudis, Lorenz , Studium
- Baumgart, Christoph , Studium
- Beckenschlager, Johann (*1435 JL †1489 JL), Bischof
- Behaim, Johann (Glogau) , Studium
- Bellinger, Johann , Studium
- Belrupt, Johann Nepomuk Friedrich Adalbert von , Studium
- Benisch, Sebastian , Studium
- Berger, Balthasar (Liegnitz) , Buchbinder
- Berger, Urban , Studium
- Bernhard, Hieronymus , Studium
- Bernhard, Peter (Lauban) , Studium
- Bernhardi, Kaspar Velius (*1493 JL †1539 JL), Kanoniker Schriftsteller Studium
- Betzelkus, Jakob , Studium
B Fortsetzung
-
Blaschke, Martin , Studium
- Bless, Johann Jakob , Studium
- Bock, Georg (Gläsendorf) , Studium
- Bodman, Johann Sigismund Rupert (*1646 †1728), Abt Benediktiner Kapitular Studium
- Bolan von Bolansdorf, Georg , Studium
- Born, Andreas (*1588 †1644), Jesuit
- Brand, Maurus (*1671 †1733), Benediktiner Mönch Studium
- Brazak, Daniel von , Studium
- Breithor, Johann , Mediziner Studium
- Breuer, Johann (Frankenstein) , Studium
- Breuer, Joseph , Studium
- Brosin, Peter (*1774), Studium
- Brunetis, Johann Jakob Freiherr von , Studium
- Burkhart, Jakob (Jauer) , Studium
- Burmann, Johann (Neisse) , Studium
- Busch, Georg vom , Studium