Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Bayern]]
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='Bayern') 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='Bayern') 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 | 1702 | 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
-
Abertshofer, Johann Baptist (*1803), Studium
- Achter, Johann Bernhard , Studium
- Agricola, Johann (Brunn) , Studium
- Agricola, Sebastian (Paradies) , Studium
- Aheimer, Kaspar , Pfleger
- Albel, Leonhard (*1622 †1655), Benediktiner Mönch Studium
- Alberti, Heinrich (Oberbach) , Studium
- Albrecht, Franz (Ried) , Studium
- Albrecht, Franz (Rieden) , Studium
- Albrecht, Johann Wolfgang , Studium
- Albrecht, Joseph (1726) (*1726 †1785), Jesuit
- Albrecht, Sebastian (Ried) , Studium
- Althofer, Wolfgang (Schönhofen) , Studium
- Altmann, Johann Georg (Furth) , Studium
- Altmann, Wolfgang (Furth) , Studium
- Amering, Heinrich von , Richter
- Amersberger, Johann Karl , Studium
A Fortsetzung
-
Amler, Joseph (Mauern) , Studium
- Ammann, Bonifatius , Studium
- Ammann, Franz (1727) (*1727 †1802), Benediktiner Mönch
- Ammann, Franz Xaver (Sallach) , Studium
- Ammann, Johann Adam , Studium
- Ammann, Joseph Franz von Paula , Studium
- Ammann, Sebastian Philipp , Studium
- Amon, Andreas (Altheim) , Studium
- Amon, Markus Thaddäus
- Andersberger, Johann , Studium
- Andorfer, Alexander (*1565 JL †1611), Kanoniker Studium
- Andorfer, Simon , Studium
- Andre, Bernhard , Studium
- Andre, Kaspar (*1655), Studium
- Angelsbruck, Johann Peter , Studium
- Angerer, Georg (Berg) , Studium
- Angerer, Konrad (Eizing) , Studium
A Fortsetzung
-
Angermeier, Benedikt , Studium
- Angermeier, Franz Karl Joseph , Studium
- Angermeier, Johann (Studium) , Studium
- App, Johann (Thonhausen) , Studium
- Arbinger, Georg , Studium
- Arcuficis, Paul , Studium
- Armesberger, Thomas , Studium
- Aschenbrenner, Georg (1771) (*1771), Arzt Mediziner Studium
- Asperle, Wolfgang Odo Otto ( †1679), Benediktiner Mönch Studium
- Assum, Joseph Abundus (*1713 †1760), Mönch Studium Zisterzienser
- Attenhauser, Georg , Studium
- Attenkofer, Johann (*1707 †1774), Pfarrer Studium
- Attmeier, Leonhard , Studium
- Atzenberger, Joseph , Studium
- Atzenberger, Peter (Feldkirchen) , Studium
- Auer, Balthasar (Stein) , Studium