Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1570 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='2294500.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='2294500.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 | 1114 | 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
NoneK
-
Kremsierer, Gabriel , Studium
- Krenk, Kaspar , Studium
- Kreuzer, Johann Christoph , Studium
- Krummenstoll, Franz , Studium
- Kuffer, Lorenz , Geistlicher
- Kugler, Heinrich (Hohentengen) , Studium
- Kuhn, Andreas (Gochsheim) , Studium
- Kunder, Johann ( †1587), Benediktiner Geistlicher Mönch
- Kurz, Wilhelm , Pfarrer
- Kurzenwort, Leonhard , Lehrer Schulmeister
- Köberer, Johann ( †1620), Pfarrer Studium
- Köhlwell, Johann , Arzt Mediziner Studium
- Kühner, Eitel Albrecht , Studium
- Kühninger, Christoph , Richter
L
-
Lacher, Ulrich (Bregenz) , Geistlicher
- Lagus, Wolfgang , Priester
- Lambert, Johann (Freising) , Vorbesitzer
L Fortsetzung
-
Laminger, Kaspar , Studium
- Lampart, Johann (Freising)
- Landus, Julius , Studium
- Laneus, Ludwig , Studium
- Lang, Burkhard (Rheinfelden) , Benediktiner Mönch Studium
- Lang, Christoph (Weikersheim) , Studium
- Lang, Hektor , Studium
- Lang, Johann (Donauwörth) , Studium
- Lang, Johann (Pfarrer, E48197) , Pfarrer
- Lang, Johann (Stadtschreiber) , Aufschläger Gerichtsschreiber Stadtschreiber
- Lang, Thomas (Rain) , Studium
- Langius, Erich , Studium
- Langwald, Lorenz , Studium
- Latomus, Friedrich , Studium
- Laubenter, Wolfgang , Studium
- Lauinger, Johann (Vaihingen) , Studium
- Lechner, Johann (München) , Studium
L Fortsetzung
-
Lehr, Thomas (Sindelfingen) , Geistlicher Studium
- Lei, Johann Ulrich (Tuttlingen) , Studium
- Leibing, Hermann , Studium
- Leininger, Thomas , Geistlicher
- Leisen, Samuel (*1538 JL †1616), Pfarrer Studium
- Leo, Karl ( †1588), Kanoniker Priester Studium
- Lepus, Johann (Überlingen) , Geistlicher Pfarrer Studium
- Lepus, Kaspar , Studium
- Leser, Christoph (Pfarrer) , Pfarrer
- Leuz, Sebastian , Mönch Pfarrer Prämonstratenser
- Lichtenstein zu Castelkorn, Adam Christoph Graf von , Studium
- Lichtenstein, Jakob Graf von , Jurist Studium
- Lindeck zu Lizzana, Christoph von ( †1602), Kanoniker Rat Studium
- Lindenmeier, Georg (Studium) , Studium
- Link, Michael (Pfarrer) ( †1576 JL), Pfarrer
- Lockheimer, Johann Philipp , Studium