Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1609]]
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='2308735.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='2308735.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
-
Kramer, Johann Justus , Studium
- Kraus, Elias , Studium
- Kraus, Markus Sebastian , Studium
- Kreiser, Sebastian , Jurist Studium
- Krembs, Ferdinand (Aichstetten) , Studium
- Krengel, Georg , Studium
- Kresser, Jakob (Waldsee) , Geistlicher Pfarrer Studium
- Kreuzer, Willibald , Benediktiner Mönch Studium
- Krieg, Karl , Pfarrer Studium
- Kroneck, Johann Wilhelm , Gymnasium illustre Studium
- Kuhlmann, Philipp Heinrich , Studium
- Kurz, Balthasar (Sonthofen) , Geistlicher Pfarrer Studium
- Kurz, Georg (Sonthofen) , Pfarrer Studium
- Kurz, Jakob (Toblach) , Studium
- Kurz, Johann (Taufkirchen) , Studium
- Kuttler, Leo , Studium
- Kyriss, Johann Philipp , Geistlicher Studium
K Fortsetzung
-
Käs, Martin (Pfarrer) , Pfarrer
- Käsbacher, Paul , Pfarrer Priester
- Köbel, Sigismund ( †1634), Pflegsverwalter Richter Studium
- Kölble, Georg (Murnau) , Priester
- König, Daniel (Franziskaner) , Franziskaner Mönch
- Küfer, Adam (*1591), Studium
- Kühner, Johann Georg (Memmingen) , Lehrer Schulmeister Studium
- Küster, Georg , Deutschordensritter Priester Studium
- Küster, Kaspar , Priester
L
-
Labasser, Thomas , Studium
- Labonne, Johann , Studium
- Laminit, Elias (*1591 †1634), Pfarrer Studium
- Lang, Jakob (Lichtenberg) , Studium
- Langjahr, Gottfried , Studium
- Lanzinger, Felix , Studium
- Lanzinger, Kaspar , Priester
- Lastler, Wolfgang , Studium
L Fortsetzung
-
Laubenberg, Johann Christoph von ( †1649), Studium
- Lauer, Johann (Limmersdorf) , Geistlicher Studium
- Laufer, Martin , Geistlicher
- Lauter, Christoph (Altdorf) ( †1639), Notar Studium
- Leberwurst, Simpon , Gymnasium Illustre Studium
- Lechner, Daniel (Franziskaner) ( †1641), Franziskaner Mönch
- Lechner, Leonhard (Brixen) , Geistlicher Priester
- Legeler, Thomas , Studium
- Lehen, Ulrich , Studium
- Lehmann, Georg , Studium
- Lehner, Christoph (Straubing) , Studium
- Leininger, Johann (Baden-Baden) , Studium
- Lemp, Ulrich , Studium
- Leodegar (Luzern) , Geistlicher Kapuziner Mönch
- Leuker, Jesaia ( †1627), Rat
- Leuterer, Hermann , Mönch Prämonstratenser Studium