Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1453 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='2251766.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='2251766.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 | 614 | 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
-
Sommerfeld, Georg ( †1457 JL), Benediktiner Mönch Schreiber
- Spanier, Ulrich , Pfarrer
- Speckner, Johann (Eggenfelden) , Studium
- Speth, Heinrich (Immendingen) , Deutschordensritter Pfarrer Studium
- Spiess, Johann (Rottenburg) , Studium
- Sporer, Johann (St.Gallen) , Schulmeister Studium
- Stammhack, Michael , Studium
- Steber, Leonhard (Studium) , Studium
- Steger, Johann (Kaufbeuren) , Pfarrer
- Stehr, Johann (Neuenkirchen) , Studium
- Steinberg, Johann (Duderstadt) , Jurist
- Steiner, Johann (Würzburg) , Studium
- Steinle, Sixt , Studium
- Steinmetz, Emerich , Studium
- Stephan (Pfarrer, I11909) , Pfarrer
- Stettner, Sigismund , Geistlicher Pfarrer Studium
- Stogkel, Friedrich , Pfarrer
S Fortsetzung
-
Strassburg, Johann von (Strassburg, Studium, G8896) , Studium
- Strasser, Johann (Pfleger, E35115) , Pfleger
- Strauss, Sigismund (Richter) , Richter Verwalter
- Strehle, Kaspar (Nördlingen) , Studium
- Strobel, Georg (Braunau) , Studium
- Strobel, Peter (Haslach) , Studium
- Stromer, Johann (Amberg) , Studium
- Struss, Johann (Basel) , Notar
- Stöckel, Johann (Richter) , Richter
- Stützel, Vitus , Studium
- Sutoris, Ulrich (Owen) ( †1483 JL), Geistlicher Pfarrer
T
-
Tannbeck, Johann (Passau) , Studium
- Tanner, Corbinian , Studium
- Tanner, Sigismund , Studium
- Taub, Johann (Rot) , Studium
- Tenterer, Jakob , Studium
- Thomae, Johann (Bopfingen) , Studium
T Fortsetzung
-
Thomas (Studium) , Geistlicher Jurist Studium
- Thun, Konrad , Domvikar Pfarrer
- Tiegeler, Johann , Pfarrer
- Tier, Paul (Hohenwart) , Studium
- Tischer, Konrad (Eger, Studium) , Studium
- Totenreiter, Thomas , Studium
- Treuchtlinger, Johann , Pfleger
- Trieber, Konrad ( †1488 JL), Pfarrer
- Trittenpreis, Urban , Pfarrer
- Tudel, Michael , Studium
- Tummer, Balthasar , Studium
- Turnel, Johann , Studium
- Turner, Johann (Richter) , Richter
- Tutwas, Jakob , Studium
- Türk, Georg (Höchstädt) , Studium
U
-
Uner, Ulrich , Studium