Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1554 JL]]
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_time` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_sortkey='2288656.5') AND t1.p_id=3171)
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_time` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_sortkey='2288656.5') AND t1.p_id=3171)
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_sortkey, p_id, p_id_2, s_id_2 | p_id_2 | 13 | const, const | 879 | 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
-
Meierhofer, Melchior , Studium
- Meilinger, Wolfgang , Hofmeister Schreiber
- Melber, Paul , Studium
- Mercator, Jakob , Studium
- Meres, Aegidius , Pfarrer Studium
- Merk, Kaspar (Hagnau, Pfarrer) , Geistlicher Pfarrer Studium
- Metzler, Georg (Rhaetien) , Studium
- Mexhofer, Georg ( †1577 JL), Augustinerchorherr Geistlicher Mönch Pfarrer Propst
- Michael, Johann (Kaufbeuren) , Pfarrer Studium
- Michel, Christoph (Geistlicher) , Geistlicher
- Michel, Georg (Pfarrer) , Pfarrer
- Mietenheuser, Georg , Pfarrer Studium
- Misenus, Peter , Studium
- Mittner, Johann (Hirschberg) , Studium
- Mocker, Johann Gaudentius , Studium
- Moder, Georg (*1536 JL †1599), Astronom Lehrer Studium poeta laureatus
- Mohn, Jonas , Studium
M Fortsetzung
-
Molendinus, Anton , Studium
- Molitor, Johann (Münsingen) , Studium
- Molsheim, Christoph von , Studium
- Montfort, Claudius , Studium
- Montfort, Johann von (Burgund) , Studium
- Montfort, Wilhelm von (Burgund) , Studium
- Moos, Daniel von , Stadtschreiber Studium
- Morgenstern, Jonas , Geistlicher Studium
- Morhold, Alexius (Kastner) , Kastner
- Morntaler, Stephan , Vorbesitzer
- Muckensturm, Johann Walter , Studium
- Munderle, Abraham , Studium
- Mutschele, Sebastian (Tübingen) , Studium
- Mörlin, Jonas , Studium
- Mühleck, Thomas , Jurist Professor Studium
- Müller, Johann (Aislingen) , Pfarrer Studium
- Müller, Johann (Propst) , Propst Verwalter
M Fortsetzung
-
Müller, Leonhard (Kastner) , Kastner Vogt
N
-
Natalis, Peter (Bruville) , Studium
- Nauer, Martin , Studium
- Nebelin, Kaspar , Studium
- Nenning, Leonhard , Studium
- Neser, Michael , Studium
- Nessel, Georg , Studium
- Neumann, Nikolaus , Studium
- Neustetter, genannt Stürmer, Sebastian (Schönfeld) , Kanoniker Studium
- Nicolai, Adam , Studium
- Nothaft von Hohenberg, Johann Werner ( †1566 JL), Kanoniker Studium
- Nothaft von Wernberg, Johann Heinrich ( †1595), Pfleger Rat Vizedom
- Nuding, Johann (Studium) , Studium
- Nägele, Philipp , Studium
O
-
Obermeier, Rupert (Passau) , Studium
- Obernberger, Anton , Studium