Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1674]]
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='2332476.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='2332476.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 | 604 | 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
-
Spolverini, Oliver Graf von , Studium
- Spon, Matthias (Studium) , Studium
- Spreng, Franz , Studium
- Starkmann, Raimund , Mönch Prior
- Staudacher von Wiesbach, Vitus Rupert , Studium
- Staudacher, Johann Ignaz , Studium
- Steger, Ignaz Leopold , Studium
- Steichele, Andreas (Deisenhausen) , Geistlicher
- Stein, Franz (Studium) , Studium
- Stein, Johann Adam , Studium
- Steinle, Johann Nikolaus , Schüler
- Stellwag, Johann Leopold , Studium
- Stephan, Johann (Wiedergeltingen) ( †1709), Priester Schüler Studium
- Stiefler, Hyazinth ( †1723), Franziskaner Mönch
- Stierler, Peter , Studium
- Strassmeier, Melchior Sebastian , Studium
- Strassoldo, Anton Bartholomäus Graf von , Studium
S Fortsetzung
-
Strobel, Andreas (1674) (*1674), Priester Studium
- Strobel, Andreas (Tandern) , Priester Studium
- Stumpf, Johann Heinrich , Studium
- Sturler, Emmanuel , Studium
- Sturm, Adam (Karlstadt) , Studium
- Stöckel, Johann Bernhard , Studium
- Süss, Jakob (Schwaz) , Studium
T
-
Tanner, Johann (Studium) , Pfarrer Studium
- Tastungen, Johann Konrad Philipp Ignaz von , Studium
- Teirlin, Alfons , Mönch Studium Zisterzienser
- Temsin, Theodor Dietrich , Studium
- Tiefenbeck, Michael , Studium
- Trautner-Trautenheim, Johann Heinrich , Studium
- Travaioni, Karl Anton , Priester
- Travoglia, Johann Baptist , Priester
- Trepek, Michael , Vorbesitzer
- Treutle, Friedrich , Studium
T Fortsetzung
-
Trocker, Kaspar , Geistlicher Studium
- Trüfer von Voldersberg in Gynn, Anton Franz , Studium
- Tschanteni, Christian , Studium
- Tschirf, Johann Jakob (Latsch) ( †1740), Pfarrer Studium
- Tschol, Rudolph , Studium
- Törring, Franz Guidobald Adam Graf von , Studium
- Türlauf, Johann Michael (Würzburg, Studium) , Studium
U
-
Unterberger, Matthias , Studium
- Ursulin, Martin , Studium
V
-
Vauterez, Stephan , Studium
- Vautier, Stephan , Studium
- Vera, Jakob (Alba) ( †1712), Geistlicher Priester Studium
- Vescovi, Karl Joseph , Studium
- Vierecker, Joseph , Studium
- Villos, Johann Bernhard , Studium
- Vintler, Johann Joachim von , Studium