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
520
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
520
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
-
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
- Hentschel, Christoph , Studium
- Hentschel, Michael , Studium
- Henz, Lorenz , Studium
H Fortsetzung
-
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
- Hermanovski, Johann , Studium
- Herwart, Albert , Studium
- Herzog, Johann (Obernissa) , Studium
- Hess, Maximilian von , Studium
H Fortsetzung
-
Hessler, Daniel (*1592), Studium
- Heuemann, Heinrich (Danzig) , Mediziner Studium
- Heuemann, Heinrich (Danzig, Mediziner) , Mediziner Studium
- Heugel, Andreas (Breslau) , Studium
- Heugnow, Johann , Studium
- Hieronymus, Felix , Studium
- Hiers, Kaspar , Studium
- Hilcemer, Balthasar ( †1634), Pfarrer Professor Studium
- Hildebrand, Balthasar (Grodków) , Studium
- Hildebrand, Georg (Grottkau) , Studium
- Hildebrand, Johann (Grottkau) , Mediziner Studium
- Hildebrand, Johann (Studium) , Studium
- Hildebrand, Kaspar (Grodków) , Studium
- Hildebrand, Michael (Grottkau) , Jurist Studium
- Hildesheim, Franz von , Studium
- Hildesheim, Konstantin von , Studium