Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1760]]
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='2363886.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='2363886.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 | 621 | 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
-
Seifried, Michael Konrad , Notar Prokurator Studium
- Seilacher, Sebastian , Studium
- Seiler, Georg Franz , Studium
- Senn, Franz Joseph (Langenargen) , Studium
- Sepp, Andreas (Wolfratshausen) , Studium
- Settele, Joseph Anton , Studium
- Sichler, Simon , Studium
- Silbernagel, Franz Anton , Studium
- Silcher, Franz Xaver , Pfarrer
- Sildner, Willibald , Studium
- Simmen, Jakob ( †1762), Schüler Studium
- Singer, Philipp Jakob , Studium
- Span, Johann Georg Peter , Pfarrer Studium
- Spicher, Johann Joseph , Studium
- Spichs, Lorenz , Pfarrer
- Spitznagel, Bernhard Fidelis , Studium
- Stachelburg, Johann Franz Felix Graf von , Studium
S Fortsetzung
-
Stader von Adelsheim, Franz Xaver Joseph Valentin , Pfarrer Studium
- Stafflinger, Johann Simon , Studium
- Stahl, Philipp (Bruchsal) , Studium
- Starkmann, Franz Xaver , Studium
- Staub, Georg , Studium
- Stehrer, Philipp (Freiburg) , Studium
- Steimig, Johann Philipp , Studium
- Steinhammer, Dominik , Studium
- Steinhauser von Wolfsthal, Franz Adam , Studium
- Sternbach zum Stock und Luttach, Johann Nepomuk Freiherr von (*1760 †1830), Kämmerer Militär Soldat Studium
- Stiegelmeier, Franz Xaver , Studium
- Stocker, Johann Christian , Studium
- Stokar von Neunforn, Johann Kaspar (Schaffhausen, Studium) , Studium
- Stoll, Franz Joseph , Amtmann Jurist Notar Studium
- Stoll, Johann Baptist (Tiengen, Studium) , Registrant Studium
- Stotzingen, Joseph Friedrich von Freiherr von , Studium
- Strasser, Joseph Anton Ludwig , Studium
S Fortsetzung
-
Streicher, Erhard (Eglfing) , Studium
- Streng, Franz Xaver Joseph Maria , Schüler
- Streng, Johann Michael , Studium
- Strickel, Michael , Studium
- Strobel, Friedrich (Schüler) , Schüler
- Strobel, Johann Peter , Schüler
- Struckel, Markus Maria ( †1760), Mönch Servit
- Stuhlberger, Joseph , Studium
- Stumpf, Joseph , Studium
- Söltel, Ludwig Thomas , Arzt Mediziner Studium
T
-
Tannbacher, Lorenz , Studium
- Taub, Johann Thomas (*1738), Kanoniker Rat Studium
- Taxis, Ferdinand Albert von , Studium
- Techtermann, Anton von , Studium
- Tengl, Thomas , Studium
- Tini, Lorenz , Schüler