Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1575 JL]]
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='2296326.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='2296326.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 | 1130 | 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
-
Klopfer, Georg (Geistlicher) , Geistlicher Pfarrer
- Klump, Georg , Studium
- Knauer, Johann (Altdorf) , Studium
- Knehr, Johann (Pfarrer) , Pfarrer
- Knehr, Matthias , Studium
- Knell, Daniel , Studium
- Knesch, Werner (Weiterdingen) , Pfarrer
- Koch, Georg (Gaimersheim) , Pfleger Studium
- Koch, Ludwig (Wertheim) , Studium
- Koch, Vitus (Pfarrer) , Pfarrer
- Kohler, Christoph (Nürnberg, Studium, G11825) , Studium
- Kohler, Leonhard (Amberg) , Lehrer Schulmeister Studium
- Kohler, Wolfgang (Gaimersheim) , Studium
- Kolen, Johann von , Studium
- Kopp, Eberhard , Studium
- Koppitz, Gregor , Studium
- Korner, Jodocus (Coburg) , Studium
K Fortsetzung
-
Kossenpusch, Albert , Studium
- Kotz, Paul (Sulzbach) , Studium
- Krabat, Daniel , Schreiber Zoller
- Kramer, Jakob (Pfarrer) ( †1611), Pfarrer
- Krapf, Georg (Mönch) , Geistlicher Mönch Prämonstratenser
- Kraus, Johann (Bamberg) ( †1609), Kanoniker Studium
- Krausenbuch, Kaspar ( †1575 JL), Pfarrer
- Krehl, Urban , Studium
- Kreislin, Michael (Prämonstratenser) ( †1592), Mönch Pfarrer Prämonstratenser
- Kreit, Lorenz , Studium
- Kreiter, Leonhard (Wasserburg) , Gerichtsschreiber Schreiber
- Kremer, Kaspar (Sesslach) , Studium
- Kretzinger, Peter , Pfarrer
- Krieg, Georg (Pfarrer) , Pfarrer
- Kugeleisen, Johann , Studium
- Kumpfmüller, Vitus , Schreiber
- Kundscher, Michael , Pfarrer
K Fortsetzung
-
Kupfer, Melchior , Studium
- Kuppenheimer, Nikolaus , Lehrer Studium
- Kölble, Georg (Weilheim) , Geistlicher
- König, Christoph (1559) (*1559 JL †1577 JL), Studium
- König, Christoph (Stuttgart) ( †1577 JL), Studium
- König, Simon (Pfarrer, E11434) , Pfarrer
- König, Wolfgang (Schwäbisch Gmünd) , Geistlicher Pfarrer Studium
- Königsfeld, Ludwig Heinrich von , Studium
- Köstlin, Christoph , Jesuit Studium
- Küff, Wolfgang , Studium
- Kühne, Johann (Binsdorf) , Studium
- Kühne, Konrad (Stuttgart) , Studium
- Kühner, Jakob (Vaihingen) , Geistlicher Studium
- Kümmel, Andreas , Pfarrer Studium
L
-
Lachheimer, Ludwig , Richter
- Laelius, Georg , Studium