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
1000
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
1000
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
NoneM
-
Martini, Nikolaus (Braunsberg) , Studium
- Martini, Simon (Braunsberg) , Studium
- Matern, Nikolaus , Studium
- Materni, Kaspar , Studium
- Matthias Ritter vn , Studium
- Matyszyn Raczynski, Christoph von , Studium
- Maxen, Johann von , Studium
- Maximilian (Studium) , Studium
- Mazzowecki, Michael (*1619 †1684), Jesuit
- Meiböhm, Peter , Studium
- Meikowaky, Stephan von , Studium
- Meikowaky, Thomas von , Studium
- Meil, Ägidius von , Studium
- Meiwald, Malachias (*1734 †1814), Mönch Studium Zisterzienser
- Melzer, Stephan , Studium
- Memborsky, Lorenz , Studium
- Menik, Johann , Studium
M Fortsetzung
-
Mensatoris, Georg , Studium
- Mergenwerder, Johann
- Merica, Michael von , Studium
- Merkel, Adam , Studium
- Mettrich, Werner , Studium
- Metzinski, Albert , Studium
- Mewe, Bernhard von , Studium
- Mewe, Lorenz , Studium
- Mewe, Matthias von , Studium
- Michalowsky, Johann Proculus von , Studium
- Michalowsky, Konstantin Hyazinth von , Studium
- Micke, Matthäus , Studium
- Mielczynski von Mielczyn, Andreas , Studium
- Mielec Mielecki, Christoph von , Studium
- Mielucki, Nikolaus , Studium
- Mierke, Martin , Studium
- Mierzck, Prendota , Studium
M Fortsetzung
-
Mieskowsky, Albert , Studium
- Mieszherosky, Peter , Studium
- Mild, David , Pfarrer
- Milianchkynsky, Martin , Studium
- Milievius de Loszie, Jakob , Studium
- Milosowsky, Andreas , Studium
- Milosowsky, Georg , Studium
- Minocki, Peter von , Studium
- Mirosz, Johann (*1627 †1657), Jesuit
- Mirowski, Andreas , Studium
- Mloctziewsky, Albert Georg Freiherr von , Studium
- Mloctziewsky, Alexander Freiherr von , Studium
- Mloctziewsky, Christoph Freiherr von , Studium
- Mlodzieiowsky, Hyazinth von , Studium
- Mloszowski, Johann , Studium
- Mniszek, Georg , Studium