Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1446 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='2249209.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='2249209.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 | 556 | 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
NoneT
-
Terp, Jakob , Studium
- Thum, Lorenz , Generalvikar Jurist Kanoniker Studium
- Tiefenbach, Konrad (Bruchsal) , Studium
- Tirschenreuth, Johann von , Dominikaner Mönch Studium
- Tornatoris, Martin , Studium
- Trumner, Asver Ahasver , Studium
- Trutwin, Johann (Vaihingen) , Studium
- Tudichum, Georg , Pfarrer Studium
- Tyrolf, Michael , Studium
- Türk, Georg (HöchstüEt) , Studium
U
-
Udenheim, Jakob von (Udenheim) , Studium
- Unersonnen, Johann , Studium
- Ungeheuer, Johann , Studium
- Unglaub, Johann , Studium
V
-
Vogler, Heinrich (Pfarrer) ( †1464 JL), Pfarrer
- Volckamer, Michael (Rothenburg) , Studium
- Volkart, German Hermann , Studium
W
-
Waging, Bernhard von , Augustinerchorherr Benediktiner Kanoniker Mönch
- Wagner, Konrad (Heilbronn) , Studium
- Wagner, Konrad (Neustadt) , Studium
- Walter, Johann (Berlin) , Studium
- Walter, Lorenz (Zwickau) , Studium
- Wannenmacher, Johann , Studium
- Wechinger, Johann (Pfarrer) , Pfarrer
- Wehlau, Johann , Studium
- Wehrstein, Johann , Pfarrer
- Weichsner, Michael , Studium
- Weissnickel, Johann , Studium
- Welker, Friedrich , Studium
- Wellin, Peter ( †1469 JL), Dominikaner Mönch Provinzial
- Werdenberg, Johann Graf von (Heiligenberg) ( †1486 JL), Bischof Kanoniker Propst Studium
- Wernicke, Nikolaus , Studium
- Wernle, Franz , Pfarrer
- Westoff, Tidemann , Theologe
W Fortsetzung
-
Wiedemann, Georg (Schöneck) , Studium
- Wiedmer, Johann (Gächingen) ( †1466 JL), Pfarrer
- Wieland, Jodocus , Pfarrer
- Wient, Stephan , Studium
- Wildenrotter, Stephan , Studium
- Wimpfen, Sebastian von , Studium
- Windeck, Reinhard , Studium
- Winkler, Christian (Kanoniker) , Kanoniker Studium
- Winkler, Erhard (Eger) , Studium
- Wirt, Hermann , Studium
- Wisse, Johann (Wertheim) , Studium
- Wohnhorst, Lorenz , Studium
- Wolf, Markus (Schwäbisch Gmünd) ( †1482 JL), Geistlicher Pfarrer Studium
- Wolgemut, Kaspar , Schreiber
- Würzburg, Andreas de , Studium
- Wüstenheimer, Andreas , Studium