Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Passau]]
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='Passau') AND t1.p_id=503)
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
500
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='Passau') AND t1.p_id=503)
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
500
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 | 1522 | 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
NoneH
-
Heinrich (Passau) , Benediktiner Mönch Studium
- Heinrich, Johann Philipp , Studium
- Heinz, Bernhard (Passau) , Studium
- Heinz, Wolfgang Marian (*1663 †1712), Benediktiner Mönch
- Helber, Joseph , Studium
- Hellauer, Raimund , Studium
- Heller, Maria Antonia (*1742), Klarisse Nonne
- Helm, Sebastian (Passau) , Studium
- Helmreich, Johann (Passau) , Studium
- Helmreich, Karl Ferdinand , Studium
- Hemmerle, Franz Anton (Passau) , Studium
- Henisch, Johann Georg (*1589 †1636), Pfarrer Rat Studium
- Henner, Nikolaus (Passau) , Studium
- Hennhofer, Karl , Studium
- Heppler, Georg , Studium
- Herbst, Wolfgang , Studium
- Herchleber, Michael , Studium
H Fortsetzung
-
Hering, Gabriel , Studium
- Heringer, Sebastian (Passau) , Studium
- Herrenberger, Johann (Passau) , Studium
- Hertelhofer, Christoph , Studium
- Hertinger, Markus , Studium
- Herzog, Michael (Passau) , Studium
- Heschel, Johann (Passau) , Studium
- Hess, Georg (Passau) , Studium
- Hess, Konrad (Passau) , Studium
- Hess, Leopold , Studium
- Hessel, Johann (Passau) , Studium
- Hetzinger, Simon , Studium
- Heubel, Martin , Studium
- Heubel, Wolfgang , Studium
- Heubler, Johann (Passau) , Studium
- Heuss, Sebastian (Passau) , Studium
- Heuss, Wolfgang (Passau) , Studium
H Fortsetzung
-
Hieretsberger, Andreas , Studium
- Hiesler, Anton , Studium
- Hildebrand, Bonifatius (1624) (*1624 †1689), Abt Mönch Studium Zisterzienser
- Hildebrand, Christoph Nikolaus , Studium
- Hildebrand, Franz (Passau) , Studium
- Hildebrand, Hieronymus , Richter Studium
- Hildebrand, Johann Anton , Studium
- Hildebrand, Kaspar (Passau) , Mediziner Studium
- Hillinger, Ignaz , Studium
- Hillinger, Theophil Gottlieb , Studium
- Hillinger, Walfried (*1725), Beichtvater Franziskaner Mönch
- Hintersreiter, Georg , Studium
- Hirs, Ulrich , Studium
- Hirschauer, Johann Franz , Arzt Mediziner Studium
- Hirschberger, Gottfried , Studium
- Hirschberger, Johann Paul , Studium