Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1595]]
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='2303621.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='2303621.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 | 1202 | 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
-
Kaufmann, Michael (Guebwiller) , Studium
- Kauz, Michael , Studium
- Keck, Leonhard (Dinkelsbühl) , Jesuitengymnasium
- Kegel, Balthasar , Studium
- Kegel, Kaspar (Dillingen) , Studium
- Kein, Jakob (Dornbirn) , Studium
- Keller, Jakob (Pfarrer, G42172) , Pfarrer
- Kempf, Valentin (Ehrenberg) , Studium
- Kepler, Markus , Jesuitengymnasium
- Kern, Adam (Miltenberg) ( †1619), Pfarrer Studium
- Kernbeck, Christoph , Studium
- Kerscher, Georg , Studium
- Khuen von Belasi, Johann Georg Freiherr von , Studium
- Kieser, Jakob (Dillingen) , Studium
- Kilian, Christoph (Altshausen, Studium) , Studium
- Kind, Simon , Studium
- Kirchner, Philipp (1580) (*1580 JL †1661), Pfarrer Studium
K Fortsetzung
-
Kirchner, Philipp (Heidelberg) ( †1661), Pfarrer Studium
- Klauber, Jakob (Rottweil) , Jesuitengymnasium
- Kleilin, Hieronymus , Studium
- Kleinstrettel, Jonas , Studium
- Klemm, Urban , Geistlicher
- Kles, Johann , Jesuitengymnasium
- Kloss, Maximilian , Studium
- Kneier, Johann , Franziskaner Mönch Studium
- Kneisslin, Bartholomäus , Mönch Pfarrer Zisterzienser
- Knoch, Bartholomäus , Studium
- Knorr, Heinrich Valentin , Studium
- Knorr, Paul , Studium
- Knupfer, Konrad (Fronstetten) , Studium
- Knöringen, Konrad von , Studium
- Kobold, Georg (Pfarrer) , Pfarrer
- Koch, Christoph (Augsburg) , Geistlicher Pfarrer
- Kochner, Johann (Pfarrer) , Pfarrer
K Fortsetzung
-
Kohl, Andreas (Amberg) , Studium
- Kohler, Christoph (Kitzingen) ( †1604), Professor Studium
- Kohler, Michael (Eichstätt) , Studium
- Kolb, Hieronymus (Pflegsverwalter) , Pflegsverwalter
- Kolb, Jakob (Straubing) , Studium
- Kopp, Nikolaus (Mengen) , Studium
- Korber, Melchior ( †1627), Benediktiner Mönch Studium
- Kornbeck, Johann Martin , Studium
- Kramer, Isaak (Stargard) , Studium
- Kramer, Johann Konrad
- Kraus, Johann Jakob (Pfarrer) , Geistlicher Pfarrer
- Krebs, Johann Jakob , Einnehmer
- Krebs, Markus , Studium
- Krehlinger, Adam , Studium
- Kreiter, Johann (Lechhausen, Jesuitengymnasium) , Jesuitengymnasium Priester
- Krembs, Georg (Bamberg) , Studium