Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Polen]]
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='Polen') 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
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='Polen') 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
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 | 1892 | 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
-
Hahn, Johann Peter (Breslau) , Studium
- Haldenhof, Wilhelm ( †1507 JL), Mediziner
- Hallenberger, Johann , Studium
- Handschuh, Johann (Ossig) , Studium
- Hanewald, Johann Christoph von , Studium
- Hanewald, Michael , Studium
- Haniel, Ignaz , Studium
- Hartung, Johann (Danzig) , Studium
- Hartung, Nikolaus (Danzig) , Studium
- Hartwig, Hartwig Eberhard
- Hasenberg, Johann , Studium
- Hatten, Matthäus , Studium
- Heider, Christoph , Priester Studium
- Heilsberg, Nikolaus von , Studium
- Hein, Georg (Danzig) , Studium
- Hein, Johann Balthasar , Studium
- Heinrich, Balthasar (Neisse) , Studium
H Fortsetzung
-
Helbig, Michael , Studium
- Held, Leonhard Ulrich , Mediziner Studium
- Heliconius, David , Studium
- Helin, Matthäus , Studium
- Hellblick, Michael , Studium
- Hellwig, Albin , Studium
- Hellwig, Kaspar , Studium
- Helmrich, Joseph (*1767), Assessor Jurist Studium
- Hempel, Matthias , Studium
- Henn, Andreas , Studium
- Henning, Adam (*1622 †1655), Arzt Mediziner Studium
- Henning, Gregor , Studium
- Henning, Johann (Wartenburg) , Studium
- Henning, Simon , Studium
- Henrici, Thomas , Studium
- Hentschel von Gilgenheimb, Johann Karl von , Studium
- Hentschel, Andreas , Studium
H Fortsetzung
-
Hentschel, Christoph , Studium
- Hentschel, Michael , Studium
- Henz, Lorenz , Studium
- Herbort, Peter (Studium) , Studium
- Herburt von Fulstin, Abraham , Studium
- Herburt von Fulstin, Erasmus Freiherr von , Studium
- Herburt von Fulstin, Johann Felix Freiherr von , Studium
- Herburt von Fulstin, Johann Freiherr von , Studium
- Herburt von Fulstin, Nikolaus Freiherr von , Studium
- Herburt von Fulstin, Stanislaus Freiherr von , Studium
- Herburt, Peter von , Studium
- Herdang, Nikolaus , Studium
- Hermann, Friedrich (Heilsberg) , Studium
- Hermann, Georg (Seeburg) , Studium
- Hermann, Matthias Heinrich ( †1614), Kapuziner Mönch Studium
- Hermanni, Andreas (Danzig) , Studium