Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1770]]
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='2367539.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='2367539.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 | 598 | 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
-
Sellinger, Anton (Krozingen) , Jurist Studium Vogt
- Sellmeier, Franz von Paula , Studium
- Sellmeier, Lorenz , Studium
- Speckner, Matthias , Studium
- Spehler, Franz Anton , Studium
- Spiess, Franz Joseph , Studium
- Sprenger, Nikolaus (Latsch) , Studium
- Stadelmeier, Johann (Schüler) , Schüler
- Staudacher, Johann (Teisendorf) , Studium
- Stechele, Joseph Anton , Studium
- Steger, Joseph Alois , Rat
- Steinbach, Matthias (Walldorf) , Studium
- Steinberger, Johann Jakob , Studium
- Steiner, Simon (Gärtner) , Gärtner
- Steinhauser, Ignaz , Schüler
- Steirer, Martin Albert , Studium
- Stephan, Sebastian (Bruchsal) , Geistlicher Jesuit Studium
S Fortsetzung
-
Stiegler, Franz Anton , Studium
- Stockmeier, Joseph , Studium
- Stolz, Franz Anton , Studium
- Strecker, Franz (Bozen) , Studium
- Streng, Anton , Schüler
- Strobel, Karl Anton , Chirurg Studium
- Stumpf, Johann Baptist (Kelheim) , Studium
- Sturm, Johann (Ried) ( †1772), Studium
- Suiter, Franz Joseph , Studium
- Sutter, Joseph , Studium
T
-
Tauschmann, Andreas , Studium
- Trafoyer, Anton , Studium
- Tschanet, Balthasar , Pfarrer
U
-
Ulm auf Erbach, Ferdinand Freiherr von , Rat Studium
- Ulsess, Nikolaus , Geistlicher Priester Studium
V
-
Veit, Johann (Mals) , Studium
- Vercelli , Studium
V Fortsetzung
-
Vetter, Johann (Schüler) , Schüler
- Vetter, Simpert Xaver (*1751 †1831), Geistlicher Priester Studium
- Vigilis, Michael von , Studium
- Vimozzi, Franz Jakob , Studium
- Vogel, Johann Peter (Heidelberg) , Studium
- Vogt, Joseph (Studium, H40025) , Studium
- Voisard, Franz Xaver , Studium
- Volk, Markus , Studium
- Vollert, Anton , Jesuit
- Vonay, Joseph , Studium
- Völkel, Bernhard , Studium
- Völkel, Johann Michael , Studium
W
-
Wachter, Peter (Heidelberg) , Studium
- Wagenmann, Ludwig Franz Xaver von , Studium
- Wagner, Franz (Wiesensteig) , Priester
- Wagner, Franz Xaver (Dillingen) , Studium