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
600
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
600
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
-
Humann, Simon (*1635 †1700), Jesuit
- Huminsky, Cornelius , Studium
- Humniczky, Martin , Studium
- Humniczky, Stanislaus , Studium
- Hund, Gregor , Studium
- Hutt, Johann , Studium
- Hutzing, Enoch ( †1623), Pfarrer Studium
- Huzonsky, Johann , Studium
- Hörmann, Franz (Tarnow) , Studium
- Hübner, Benjamin , Studium
- Hübner, Christoph (*1564 JL †1620), Jesuit
I
-
Ianoucki, Nikolaus , Studium
- Iering, Andreas von , Studium
- Ioannicius, Georg , Studium
- Irsedworsky, Stephan , Studium
J
-
Jachtigin, Johann , Studium
- Jacobelli, Jakob , Studium
J Fortsetzung
-
Jacobinus, Johann , Studium
- Jacobowsky de Jacubowitz, Peter von , Studium
- Jahrmarkt, Anton , Studium
- Jamkowsky, Matthias , Studium
- Janofsky von Johnsdorf, Karl , Studium
- Jarmolski, Stephan Ritter von , Studium
- Jaroschin, Julius Ferdinand Freiherr von , Studium
- Jascius, Ambrosius , Studium
- Jascoleski, Peter , Studium
- Jasinsly, Ladislaus , Studium
- Jasmanius, Johann , Studium
- Jasrenszky, Sebastian Rowselmus , Studium
- Jauer, Jakob von , Studium
- Jausch, Kaspar , Studium
- Jeckel, Johann Anton , Arzt Mediziner Studium
- Jedlewsky, Bartholomäus Stanislaus , Studium
- Jerin, Ludwig von , Studium
J Fortsetzung
-
Jeskius, Kaspar , Studium
- Jesowsky, Anton von , Studium
- Jodlowski, Stanislaus , Studium
- Jodoci, Johann (Thorn) , Studium
- Johann (Danzig) , Studium
- Johann Baptist (Prausnitz) , Studium
- Johann, Wenceslaus (Glatz) , Studium
- Jonick, Lorenz , Studium
- Jonischer, Lorenz , Studium
- Joppiner, Johann , Studium
- Jordan, Bartholomäus , Studium
- Joriscus, Andreas , Studium
- Judicis, Nikolaus (Tannenberg) , Studium
- Judychi, Nikolaus Ladislaus von , Studium
- Jugelt, Balthasar , Studium
- Jung, David , Studium