Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1561 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='2291213.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='2291213.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 | 805 | 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
-
Mülich, Christian , Studium
- Müller, Friedrich (1541) (*1541 JL †1604), Pfarrer Studium
- Müller, Friedrich (Windsheim, Studium) ( †1604), Pfarrer Studium
- Müller, Georg (Kisslegg) , Studium
- Müller, Georg (Nürnberg) , Studium
- Müller, Heinrich (Eisleben) , Studium
- Müller, Johann Leonhard (Lindau) , Studium
- Müller, Matthäus (Egg) , Pfarrer Studium
- Müller, Peter (Zeutern) , Studium
- Müller, Theodor Dietrich (Ehingen) ( †1585), Geistlicher Studium
- Müller, Thomas (Pfarrer, G38931) , Pfarrer
- Müllner, Augustin (Geistlicher) , Geistlicher Kanoniker Pfarrer
- Münch, Jakob (Bern) , Studium
- Münsch, Leonhard , Pfarrer
N
-
Nagel, David , Studium
- Necker, Andreas ( †1578 JL), Pfleger Rat Studium Vogt
- Neidecker, Franz , Kastner
N Fortsetzung
-
Nellenwerker, Konrad , Studium
- Nerlinger, Vitus , Geistlicher Studium
- Neuchinger, Johann Kaspar , Studium
- Neufer, Albert , Studium
- Neuhausen, Hermann , Studium
- Neusesser, Sebastian , Studium
- Niedlinger, Georg , Studium
- Nigost, Jakob
- Nonnenmacher, Johann , Studium
- Nostitz, Friedrich von , Studium
- Nostitz, Kaspar von , Studium
- Nuinoan, Johann , Studium
- Nusser, Christoph (Regensburg) , Studium
- Nutz, Christoph , Studium
- Nux, Georg (Studium) , Studium
- Nägele, Stephan (Aichach) , Priester Studium
O
-
Oegel, Wolfgang , Studium
O Fortsetzung
-
Oetheus, Jodocus , Jurist Rat Studium
- Ostertag, Johann (Pfarrer, B42622) , Pfarrer
- Otmar, Johann (Schärding) , Kanzleiverwalter
- Ottentaler, Remigius , Pfarrer Priester
- Ottenwelder, Christoph , Studium
P
-
Padnieno, Albert von , Studium
- Padnieno, Johann von , Studium
- Paller, Matthias , Studium
- Pappenheim, Haupt von (Pappenheim) ( †1571 JL), Studium
- Peter, Johann (Freiburg) , Geistlicher Studium
- Petri, Erhard (Schweiz) , Studium
- Peutinger, Claudius Chrysostomus ( †1616), Kanoniker Studium
- Peutinger, Claudius Karl , Studium
- Peutinger, Konrad (Pfarrer) , Pfarrer
- Peutinger, Leonhard Christoph , Studium
- Pfalzgraf bei Rhein, Justin , Studium