Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1604]]
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='2306908.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='2306908.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 | 1177 | 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
NoneJ
-
Jäger, Philipp Jakob , Studium
K
-
Kaiser, Balthasar , Studium
- Kalb, Jodocus , Geistlicher
- Kalb, Rupert (Aulendorf) , Mönch Prämonstratenser Studium
- Kalcheder, Martin , Studium
- Kaler, Johann , Studium
- Kalt, Jodocus , Priester
- Karbach, Johann (Würzburg) , Studium
- Karg, David , Maler
- Karroyczky, Christian , Studium
- Karroyczky, Johann , Studium
- Keckschwert, Johann , Priester
- Kegel, Bartholomäus , Jurist Studium
- Keller, Ferdinand , Studium
- Keller, Johann (Dillingen) , Studium
- Keller, Konrad (Meersburg) , Studium
- Keller, Oswald (Altkirch) , Studium
K Fortsetzung
- Kenzelmann, Christoph , Studium
- Kerl, Johann (Ingolstadt) , Studium
- Kerst, Konrad , Studium
- Kessler, Lukas , Studium
- Kettler, Kaspar , Priester Studium
- Kippenheim, Johann Jakob , Studium
- Kirchberg, Otto Joseph von , Hofrat Rat Statthalter Studium
- Kircher, Martin (Munderkingen, Studium) , Studium
- Kirchmeier, Johann Jakob (A36411) ( †1623)
- Kirmann, Johann Georg , Studium
- Kissling, Adam , Geistlicher Jesuitengymnasium Pfarrer Schongau Studium
- Kleesattel, Johann Georg Christoph , Arzt Mediziner Studium
- Kleik, Peter , Studium
- Klenau und Jannowitz, Wilhelm von , Studium
- Klingel, Lambert , Zoller
- Klopfer, Johann (Dillingen) , Geistlicher Pfarrer Studium
K Fortsetzung
-
Klostermeier, Georg (Ingolstadt) , Studium
- Klöpfer, Johann Georg (Hall/Tir.) , Studium
- Knecht, Johann (Watterdingen) , Studium
- Kneiz, Kaspar , Studium
- Knittel, Gregor , Priester
- Knod, Heinrich (Wambach) , Studium
- Knoll, Georg (Ries) ( †1615), Pfarrer Studium
- Knoll, Johann Jakob (Haigerloch) , Kanoniker Pfarrer Studium
- Knöringen, Johann Christoph (Studium) ( †1654), Amtmann Rat Studium
- Kobold, Bartholomäus (Speyer) , Assessor Studium
- Kobold, Sebastian , Studium
- Koch, Benedikt (Basel, Studium) , Studium
- Koch, Georg Eberhard , Gymnasium Illustre Studium
- Kockanowski, Martin , Studium
- Kohleisen, Matthias , Studium
- Kohler, Johann (Sigmaringen) , Geistlicher