Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1517 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='2275142.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='2275142.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 | 1073 | 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
-
Lauerbacher, Heinrich , Studium
- Laufehans, Georg , Studium
- Lautenschlager, Kaspar (Stadtvogt) , Stadtvogt
- Lauterbacher, Eberhard , Studium
- Laymann, Christoph (Inningen) , Geistlicher Studium
- Lebnauer, Martin , Studium
- Lechamer, Matthias , Studium
- Lechner, Ulrich (Regensburg) , Studium
- Lederer, Sixt , Studium
- Leibler, Thomas , Studium
- Lemsenang, Anton , Studium
- Lending, Wilhelm , Geistlicher
- Leon, Andreas von , Studium
- Leser, Matthias , Karmeliter Mönch Studium
- Leui, Apollinaris , Studium
- Leupold, Georg (Innsbruck) , Studium
- Leutold, Ulrich , Studium
L Fortsetzung
-
Leuzdorfer, Konrad , Studium
- Lichtenberger, Wolfgang , Studium
- Lichtenstein, Eobald Ewald von , Geistlicher Studium
- Lieb, Ulrich (Bischofszell) ( †1520 JL), Geistlicher Studium
- Liebenauer, Christoph , Landrichter Pfleger
- Liebs, Heinrich , Prokurator
- Liesner, Wilhelm , Studium
- Lindenfels, Christoph von , Studium
- Linder, Philipp , Studium
- Linder, Thomas (Landsberg) , Studium
- Lindner, Johann (Burghausen) , Geistlicher Studium
- Linope, Matthäus , Studium
- Lochmann, Johann , Studium
- Lochner, Johann (Nürnberg, Studium) , Studium
- Loder, Johann (Wassertrüdingen) , Studium
- Lohrmann, Philipp , Studium
- Loi, Kaspar , Geistlicher Studium
L Fortsetzung
-
Lorenz, Bartholomäus , Studium
- Ludescher, Jodocus , Studium
- Lung, Georg , Richter
- Lunz, Johann (Coburg) , Studium
- Lutz, Heinrich (Markgröningen) , Studium
- Lutz, Joachim (Bischofsheim) , Studium
- Lutzmann, Eucharius , Studium
M
-
Magenburger, Christian , Studium
- Magerer, Sebastian , Studium
- Magin, Peter , Pfarrer
- Maler, Gregor (Geistlicher) , Geistlicher
- Mamm, Balthasar , Studium
- Mangold, Christoph (Augsburg) , Studium
- Mangold, Matthäus (Isny) , Studium
- Mangold, Matthäus (Konstanz) ( †1521 JL), Kanoniker Studium
- Marius, Nikolaus (Leipheim) , Schulmeister Studium