Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1646]]
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='2322249.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='2322249.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 | 638 | 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
-
Schuler, Johann (Roth) , Studium
- Schweiger, David (Schwäbisch Hall, Studium) , Studium
- Schön, Franz Ignaz , Richter Studium
- Schönau, Franz Rudolph von , Kanoniker Studium
- Schönherr, Johann (Eichstätt) , Geistlicher Pfarrer Studium
- Schütz, Adam (Franken) , Studium
- Sebald, Johann (Bereiter) , Bereiter
- Seeau, Johann Rudolph von , Studium
- Seifert, Johann (Münnerstadt) , Pfarrer Studium
- Seldner, Johann Georg (Eger) , Studium
- Sellner, Bonaventura ( †1683), Augustinereremit Mönch Studium
- Senft, Johann Theobald , Jesuitengymnasium Studium
- Senner, Johann Christoph Jesaia ( †1695), Kapuziner Mönch
- Sepfhart, Kaspar , Studium
- Sigmund, David , Studium
- Silberrad, Samuel (Strassburg, Studium) , Studium
- Singrien, Johann (Messkirch) , Priester
S Fortsetzung
-
Soler, Johann Kaspar , Studium
- Soler, Johann Michael ( †1583), Kanoniker Studium
- Sorbait, Paul von ( †1691), Arzt Mediziner Professor Studium
- Spagnolli, Martin , Studium
- Sparo, Matthäus , Priester
- Speidel, Johann Leonhard (Stuttgart) , Sekretär
- Sperl, Johann Adam (Studium, F6550) , Studium
- Speth, Andreas (Meran) , Studium
- Spindler, Leonhard (Schwaben) , Studium
- Sprenger, Alois (*1622 †1681), Benediktiner Mönch
- Stadelmeier, Johann Konrad , Studium
- Stadion, Franz Kaspar von ( †1704), Bischof Kanoniker Studium
- Stahl, Philipp Ludwig , Studium
- Star, Jakob , Amtsbote
- Staudacher, Martin (Schreiber) , Pflegsverwalter Schreiber
- Steber, Valentin , Studium
- Steffel, Johann Georg , Studium
S Fortsetzung
-
Steger, Johann (Studium) , Jesuitengymnasium Studium
- Steiberer, Johann Ferdinand von ( †1695), Rat Studium
- Steiger, Daniel (1628) (*1628 †1690), Gymnasium Pfarrer Studium
- Steiger, Daniel (Ulm) ( †1690), Gymnasium Pfarrer Studium
- Steiger, Johann (Jesuitengymnasium) , Jesuitengymnasium Studium
- Steigleder, Michael , Studium
- Steil, Johann Franz , Jesuitengymnasium Studium
- Steininger, Georg (Franken) , Studium
- Stemm, Daniel , Studium
- Steppert, Nikolaus , Studium
- Stettner, Kaspar , Studium
- Stipplen, Benedikt , Geistlicher Mönch Prämonstratenser
- Stocker, Johann Thomas , Studium
- Stork, Johann Friedrich , Studium
- Stotzinger, Lorenz , Schüler Studium
- Strasser, Matthäus (Studium) , Studium