Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1698]]
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='2341242.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='2341242.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 | 1064 | 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
-
Krippner, Georg Christoph (*1698), Studium
- Kugler, Johann Heinrich Ulrich , Studium
- Kuhn, Johann Jakob Dominik , Studium
- Kummer, Stephan , Studium
- Kuri, Joseph , Studium
- Kurz, Joseph Emmanuel , Studium
- Käserer, Michael , Priester Studium
- Köbel, Johann Ludwig , Jurist Studium
- Kölbel, Georg Anton , Studium
- Kühbacher, Johann , Studium
- Kühning, Franz Joachim , Studium
L
-
L'Amour, Peter , Studium
- Lachner, Franz Anton , Geistlicher Studium
- Ladurner, Joseph (Naturns) , Studium
- Ladurner, Michael (Morter) , Geistlicher Studium
- Lahner, Johann Jakob , Studium
- Lambacher, Paul , Pfarrer Studium
L Fortsetzung
-
Lamm, Johann Anton , Schüler
- Landes, Johann Evangelist , Pfarrer Priester Schüler Studium
- Landolt, Johann Capistranus ( †1728), Franziskaner Mönch
- Lang, Ignaz Heinrich Joseph , Studium
- Lang, Johann Lorenz , Studium
- Langenmantel, Bernhardin Anton Valentin , Studium
- Langenmeier, Johann Leonhard ( †1748), Geistlicher Pfarrer Studium
- Langhans, Andreas , Studium
- Larcher, Joseph (Studium) , Franziskaner Mönch Studium
- Lebzelter, Ferdinand Leopold Anton Xaver von , Schüler
- Lechner, Anton (Studium) , Studium
- Ledergerber, Joseph Anton , Studium
- Ledermeier, Hieronymus , Studium
- Leeb, Franz Joseph (München) , Studium
- Leeb, Franz Joseph (München, Studium) , Studium
- Lehmann, Joseph (Rottenburg) , Studium
- Leihmüller, Anton , Franziskaner Mönch Studium
L Fortsetzung
-
Leimbrucher, Paul , Studium
- Leinauer, Joseph , Geistlicher Priester
- Leirer, Johann Jakob , Studium
- Lengauer, Johann Jakob , Studium
- Lenz, Georg Thomas , Studium
- Lenz, Joseph Karl (Studium) , Studium
- Leo, Georg Andreas Melchior , Studium
- Leo, Johann Leonhard (Gundelfingen) , Amtmann Studium
- Leonardi, Johann Peter , Studium
- Leonhardi, Johann Hermann , Studium
- Lerch, Johann Michael , Studium
- Lercher, Andreas (Studium) , Studium
- Leupold, Johann Kaspar (Würzburg, Studium) , Studium
- Leutin, Georg Jakob (Buchhorn) , Studium
- Lieb, Franz Heinrich Ignaz (*1680), Stadtschreiber Studium
- Liebenstein, Johann Philipp Konrad Freiherr von , Kanoniker Rat Studium