Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Günzburg]]
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='Günzburg') AND t1.p_id=503)
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='Günzburg') AND t1.p_id=503)
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 | 908 | 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
-
Molitor, Johann Friedrich (*1628), Schüler Studium
- Molitor, Johann Georg (1641) (*1641), Geistlicher Studium
- Molitor, Johann Ulrich (*1629), Studium
- Molitoris, Johann (Günzburg) , Studium
- Molitoris, Johann (Günzburg, Studium) , Studium
- Molitoris, Sebastian (Günzburg) , Studium
- Mund, Anton , Geistlicher
- Mundbrot, Heinrich , Studium
- Mundbrot, Johann Anton (*1702), Studium
- Muschnang, Ulrich ( †1609), Benediktiner Mönch
- Mändl von Deutenhofen, Johann (*1588 †1660), Pfleger Rat Studium
- Mändl, Anton (1629) (*1629 †1688), Mönch Paulaner Studium
- Mändl, Georg (1613) (*1613 †1693), Jesuit Studium
- Mülich, Benedikt (Günzburg) , Studium
- Mülich, Johann (Günzburg) , Studium
- Mülich, Johann Wolfgang , Priester Studium
- Müller, Andreas (Günzburg) , Geistlicher
M Fortsetzung
-
Müller, Franz (Günzburg) , Studium
- Müller, Georg (Günzburg) , Studium
- Müller, Johann (Günzburg) , Geistlicher
- Müller, Johann (Günzburg, Studium) , Studium
- Müller, Konrad (Günzburg) , Studium
- Müller, Matthäus (Günzburg) , Schüler
- Müller, Stephan (Günzburg) , Studium
- Müller, Ulrich (Günzburg) , Studium
N
-
Nass, Jodocus , Studium
- Neckinger, Ignaz , Studium
- Neiding, Johann (Günzburg) , Studium
- Neidlinger, Johann (Günzburg) , Studium
- Neidlinger, Ulrich (Haunsheim) , Studium
- Nell, Jakob (1543) (*1543 JL †1613), Benediktiner Mönch
- Neophytus, Johann , Studium
- Ness, Alexander , Studium
- Ness, Georg , Studium
N Fortsetzung
-
Nickel, Paul , Studium
- Niederhofer, Christoph Bartholomäus ( †1804), Advokat Prokurator Studium
- Niederhofer, Franz Joseph , Studium
- Niess, Konrad (Günzburg) , Studium
- Nissel, Jakob (Günzburg) , Priester
- Nonnenbeck, Johann , Studium
- Nonnenbeck, Johann Martin (*1692), Pfarrer Priester Studium
- Nusser von Nusseck, Stephan Bernhard von , Studium
- Nusser, Christian , Studium
- Nusser, Franz (1608) (*1608 †1650), Benediktiner Mönch Priester Studium
- Nusser, Ignaz (*1638), Studium
- Nusser, Johann Franz (*1624), Studium
- Nusser, Johann Georg (1734) (*1734), Pfarrer Studium
- Nusser, Johann Maximilian (*1719), Studium
- Nusser, Karl Anton (*1744), Advokat Studium
- Nusser, Markus (*1720), Studium