Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1600]]
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='2305447.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='2305447.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 | 1017 | 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
NoneL
-
Lamberg, Wolfgang Dietrich Theodor Graf von ( †1597), Studium
- Lamm, Hieronymus , Advokat Syndikus
- Lanckoronski von Brzezie, Christoph Freiherr von (Polen) , Studium
- Landau von Hauss und Rappottenstein, Ehrenreich Freiherr von , Studium
- Landau von Hauss und Rappottenstein, Gottfried Freiherr von , Studium
- Landau von Hauss und Rappottenstein, Joachim Freiherr von , Studium
- Landenberger, Johann , Geistlicher
- Landwehr, Vitus , Studium
- Lang, Lorenz (Saverne) , Studium
- Lang, Marcellus , Studium
- Lautenschlager, Georg (Engen) , Priester Studium
- LeChangeur, Johann , Studium
- Lechelmeier, Jakob , Studium
- Lechner, Anton (Pfarrer) , Mönch Pfarrer Zisterzienser
- Lechner, Johann (Forchheim, Studium) , Studium
- Lechner, Paul (Forchheim) , Studium
- Lederer, Johann (Buch) , Jesuitengymnasium
L Fortsetzung
-
Lederer, Johann (München) ( †1649), Gerichtsschreiber Schreiber
- Lederer, Paul (Zisterzienser) ( †1618), Mönch Zisterzienser
- Lehner, Simon (Geltendorf) , Priester
- Leininger, Wilhelm , Studium
- Leis, Johann Eberhard , Studium
- Leis, Johann Philipp , Studium
- Leis, Kaspar (Bozen) , Studium
- Lemp, Berthold , Studium
- Lennep, Adolph ( †1624), Jesuit
- Lennep, Hermann ( †1618), Jesuit
- Lenz, Andreas (Ebenried) , Jesuitengymnasium
- Leo, Thomas (Altenerding) , Studium
- Leonberger, Abraham , Pflegsverwalter Schreiber Verwalter
- Lichtensteiger, Bartholomäus , Studium
- Liebenstein, Ludwig von , Studium
- Liener, Johann , Studium
- Lilienfein, Johann (Sersheim) , Geistlicher Studium
L Fortsetzung
-
Lilius, Viktorin Viktor , Pfleger Sekretär Studium
- Lindin, Bartholomäus (Engen) , Priester Studium
- Lindin, Kaspar , Priester Studium
- Lindner, Johann Christoph , Studium
- Lipp, Peter , Priester Studium
- Locherer, Kaspar , Studium
- Lorenz, Johann (Neustadt) , Studium
- Lukas, Johann (Frankenthal) , Studium
- Lunradi, Johann , Jesuitengymnasium
- Lustnauer, Johann Georg (Tübingen, Studium) , Studium
- Lutz, Hieronymus (Windsheim) , Pfarrer Studium
- Löffler, Georg (Ottmaring) , Jesuitengymnasium
- Löffler, Kaspar , Studium
M
-
Mack, Christoph (Weilheim an der Teck) , Geistlicher Studium
- Malterrock, Balthasar ( †1609), Geistlicher Pfarrer
- Manincor, Anton (1586) (*1586), Studium