Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1447 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='2249574.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='2249574.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 | 653 | 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
-
Schwegler, Johann (Notar) , Kanzler Notar
- Schwertmann, Ägidius (Laibstadt) ( †1479 JL), Dominikaner Mönch
- Schönbrunner, Martin , Mönch Studium
- Schütz, Konrad (Nürnberg) , Jurist Konsulent Studium
- Scriptoris, Johann (Auerbach) , Studium
- Seeg, Johann von , Studium
- Seifried, Konrad (Pöttmes) , Studium
- Sein, Johann (Freising) , Studium
- Selflinger, Heinrich ( †1473 JL), Geistlicher Pfarrer
- Sell, Johann (Ingwiller) , Studium
- Sellingsbach, Johann , Studium
- Sichling, Johann , Pfarrer
- Sick, Tibald Theobald , Pfarrer
- Sieber, Nikolaus (Geistlicher, F25102) ( †1481 JL), Geistlicher
- Sieber, Thomas , Studium
- Siebold, Georg (Propst) , Propst
- Sieder, Johann (Schwäbisch Hall) , Studium
S Fortsetzung
-
Siefer, Johann (Geistlicher) , Geistlicher
- Siegmarshauser, Stephan , Richter
- Siff, Georg ( †1488 JL), Pfarrer Studium
- Simmerer, Georg , Studium
- Simmlenbacher, Johann , Geistlicher
- Simonis, Nikolaus (Luxemburg) , Jurist Professor
- Sinse, Johann de , Geistlicher Notar
- Slappan, Johann , Studium
- Sonner, Johann (Landshut) , Studium
- Sorhahn, Nikolaus , Studium
- Sparer, Johann (St.Gallen) , Studium
- Sparnberger, Georg , Studium
- Sparsguet, Georg , Kanoniker
- Spengler, Konrad (Amberg) , Studium
- Spitzenbach, Johann , Stadtschreiber
- Sporer, Ambrosius ( †1480 JL), Geistlicher Studium
- Stadler, Matthäus (Obernberg) , Studium
S Fortsetzung
-
Stammhammer, Lorenz , Studium
- Steger, Andreas (Pfarrer) , Pfarrer
- Stei, Kaspar , Studium
- Steinbach, Peter (Masevaux) , Studium
- Steindel, Johann (Plattling) , Studium
- Steinicher, Ulrich , Studium
- Stenglin, Thomas (Colmar) , Studium
- Stephani, Peter ( †1464 JL), Augustinerchorherr Kanoniker Studium
- Stepperger, Georg , Geistlicher Studium
- Sterzing, Thomas von , Studium
- Stetten, Kaspar von ( †1464 JL), Pfarrer
- Stettner, Leonhard (Landshut) , Studium
- Strasser, Johann (Isen) , Studium
- Strasser, Leonhard (Hallein) , Studium
- Straubing, Michael von , Studium
- Strauss, Joachim , Studium