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
750
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
750
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
NoneK
-
Kopernikus, Nikolaus (*1473 JL), Astronom
- Koriczinski, Andreas , Studium
- Koriczinski, Christoph , Studium
- Kormanitzky, Georg Freiherr von , Studium
- Korn, Christoph , Studium
- Korniakty, Alexander Freiherr von , Studium
- Korniakty, Konstantin Freiherr von , Studium
- Korniakty, Michael Freiherr von , Studium
- Kornic Porubski, Andreas Graf von , Studium
- Kornic Porubski, Sigismund Graf von , Studium
- Korsak, Johann Karl , Studium
- Koruackeroski, Albert , Studium
- Koscziensky, Lorenz , Studium
- Koscziessa, Andreas , Studium
- Koseka Zeosky, Matthias , Studium
- Koseky, Johann , Studium
- Kosinowskhi, Florian , Studium
K Fortsetzung
-
Koss, Andreas , Studium
- Koss, Felix , Studium
- Kossla, Balthasar , Studium
- Kosten, Gregor von , Studium
- Kostenskhy, Johann , Studium
- Kotecki, Jakob Ritter von , Studium
- Kotkowski, Nikolaus , Studium
- Kotulinski von Kotulin, Franz Karl Freiherr von , Studium
- Kotulinski von Kotulin, Friedrich Alexander von , Studium
- Kotulinski, Nikolaus , Studium
- Kotz, Simon , Studium
- Kowalkowsky, Michael Johann , Studium
- Kowalsowski, Felix , Studium
- Kownacki, Gregor , Studium
- Krajewski, Lorenz (*1544 JL †1619), Jesuit
- Kramer, Isaak (Stargard) , Studium
- Krapitz, Bartholomäus , Studium
K Fortsetzung
-
Krasletzky, Martin Graf von , Studium
- Krasowski, Nikolaus , Studium
- Krassietzky von Sieczin, Georg Freiherr von , Studium
- Krassietzky, Martin , Studium
- Krassowsky, Felix , Studium
- Krassowsky, Lukas , Studium
- Krasuski, Johann , Studium
- Krasuski, Nikolaus , Studium
- Kratz, Adam , Studium
- Kraus, Kaspar Franz , Studium
- Krause, Kaspar Franz , Studium
- Krautwald, Johann von , Studium
- Kregennest, Henning
- Kreionsky, Stanislaus , Studium
- Krembs, Stanislaus (1608) (*1608 †1654), Rat Studium
- Kremer, Paul Albert , Studium