Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1608]]
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='2308369.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='2308369.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 | 1135 | 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
-
Kazianer von Katzenstein, Georg Balthasar Freiherr von , Landschaftsverordneter Studium
- Kazianer von Katzenstein, Gottfried Freiherr von , Studium
- Kazianer von Katzenstein, Johann Sigismund Freiherr von , Studium
- Kehl, Johann (Hünfeld) , Studium
- Kehrricht, Johann , Studium
- Keislin, Albert (*1591 †1657), Benediktiner Mönch Studium
- Keller, Joachim (Mönch) , Benediktiner Mönch Studium
- Keller, Johann Jakob (Überlingen) , Priester
- Kelz, Paul , Studium
- Kemmlin, Konrad (Weinsberg) , Geistlicher Studium
- Kempfer, Michael , Amtsknecht
- Kern, Michael (Mengen) , Geistlicher
- Kern, Rudolph , Studium
- Kessner, Johann , Studium
- Kibinsky, Ferdinand Adam ( †1647), Forstmeister Studium
- Kibinsky, Georg Christoph , Studium
- Kilian, Philipp , Schüler
K Fortsetzung
-
Kimpfel, Sebastian , Priester Studium
- Kind, Andreas Konrad , Studium
- Kindischer, Albert , Studium
- Kirchberger, Georg (Nürnberg) ( †1625), Advokat Jurist Studium
- Kirchner, Nikolaus (Jesuit) ( †1664), Jesuit
- Kirnacher, Johann , Studium
- Kirschbaumer, Bartholomäus , Geistlicher Priester
- Kirwang, Johann Georg , Studium
- Kirwang, Ulrich Christian , Studium
- Kitt, Johann Werner , Studium
- Kittel, Balthasar , Studium
- Klein, Lorenz (Plattenhardt) , Geistlicher Studium
- Klein, Tobias , Augustinereremit Mönch Priester
- Kleinbrot, Georg , Studium
- Klopfer, Georg (Dillingen, Studium) , Pfarrer Studium
- Knehr, Johann Michael (Ribeauvillé) , Studium
- Kniel, Christoph (Neckarsulm) , Studium
K Fortsetzung
-
Kniesel, Johann (Meierskappel) , Priester
- Knor, Lukas Jakob (*1598), Gymnasium illustre Schüler
- Knupfer, Johann (Wilzingen, Ober-, Unter-) , Studium
- Knödel, Johann Paul , Pfarrer
- Knödler, Kilian , Studium
- Koch, Christoph (Karden) , Studium
- Koch, Christoph (Lautlingen) , Priester Studium
- Koch, Jakob (Nüdlingen) , Studium
- Koch, Jakob (Studium) , Studium
- Kohler, Johann Jakob (Sekretär) ( †1621), Keller Schultheiss Sekretär
- Kolb von Raindorf, Ludwig , Gymnasium Illustre Studium
- Kolb, Jakob (Strassburg) , Buchbinder
- Kolber, Ambrosius (Delémont) , Studium
- Kollonitsch, Erasmus Ferdinand ( †1670), Deutschordensritter Jurist Komtur Studium
- Kollonitz, Georg Gabriel von , Jurist Studium
- Kompf, Jakob Christoph , Kanoniker Propst Studium