Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1640]]
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='2320057.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='2320057.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 | 596 | 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
NoneS
-
Stecher, Walter , Studium
- Stegmann, Johann (Ulm, Studium) , Studium
- Steidle, Tobias , Geistlicher Pfarrer
- Steiger, Johann (Pfarrer) , Pfarrer
- Steiger, Nikolaus (Pfarrer) , Karmeliter Mönch Pfarrer
- Steinauer, Johann Franz , Studium
- Steinmeier, Johann (Pähl) ( †1684), Pfarrer Priester
- Stendler, Wolfgang Adam , Studium
- Stettner, Albert ( †1677), Kanzlist Pflegsverwalter Studium
- Stiebel, Michael , Jesuitengymnasium Studium
- Stoll, Johann (Balzhausen) , Pfarrer Studium
- Stotz, Johann (Hechingen) , Studium
- Straub, Ulrich , Studium
- Strobel, Hieronymus (Burghausen) , Studium
- Strohmeier, Benno , Studium
- Sulzer, Hieronymus (Augsburg) , Studium
T
-
Tard, Johann German Hermann , Studium
T Fortsetzung
-
Tatt, Johann Baptist (*1640 †1698), Schreiber Studium
- Tattenbach, Johann Christoph Freiherr von , Studium
- Tattenbach, Johann Franz Freiherr von , Studium
- Taufkirchen, Maximilian von , Jesuitengymnasium
- Tenzi, Johann Iveus Ivo , Studium
- Terian, Sebastian , Studium
- Thaddäus, Paul , Pfarrer
- Thurn zu Neubeuern, Franz Freiherr von , Studium
- Thurn zu Neubeuern, Hieronymus Freiherr von , Studium
- Tinitor, Peter , Studium
- Tono, Dominik von , Studium
- Trapp, Johann Georg Karl (*1619 †1693), Kanoniker Studium
- Trapp, Johann Kaspar von , Studium
- Tregillius, Christian , Studium
- Tregt, Georg , Studium
- Trogelli, Christian , Priester Studium
- Trüfer von Voldersberg in Gynn, Christoph , Studium
U
-
Udalrici, Paul (Remda) , Studium
- Ulrich, Johann (Konstanz) , Studium
- Ulrici, Daniel , Studium
- Ulrici, Philipp , Studium
- Unverzagt zu Rötz, Wolf Georg , Jägermeister Pfleger
V
-
Vautier, Peter (Porrentruy) ( †1683), Kanoniker Studium Theologe
- Venosta, Joseph , Studium
- Vetter, Johann (Weismain) , Studium
- Viscardi, Johann Anton , Jesuitengymnasium
- Vogel, Johann (Immenstadt) , Studium
- Vogel, Valentin (Richter) , Richter
- Vogel, Vitus (Richter) , Richter
- Volano, Nikolaus Gotthard von , Studium
W
-
Wadel, Johann , Studium
- Wagner von Rottenbuech, Ludwig , Studium
- Wagner, David (Bozen) , Studium