Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1743]]
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='2357677.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='2357677.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 | 669 | 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
-
Scheuring, Joseph Agapit (*1723 †1766), Geistlicher Studium
- Schick, Nikolaus , Studium
- Schildknecht, Johann Jakob , Arzt Mediziner Studium
- Schilling, Johann Lorenz , Studium
- Schimmel, Joseph (Plankstetten) , Studium
- Schindler, Philipp Joseph , Amtmann Studium
- Schlimmbach, Johann Georg , Studium
- Schmelzer, Franz Sigbert , Amtmann Bergdirektor Forstmeister Kassier Studium
- Schmelzer, Georg Benedikt (*1707 †1759), Buchhalter Gerichtsschreiber Kanzlist
- Schmelzer, Joseph Johann , Studium
- Schmid von Laneck, Franz Anton , Studium
- Schmid, Dionysius Simon , Studium
- Schmid, Franz Joseph (Sigmaringen, Priester) , Geistlicher Priester
- Schmid, Franz von Paula (1721) (*1721), Studium
- Schmid, Franz von Paula (Prutz) , Studium
- Schmid, Joseph (Freising) , Studium
- Schmid, Lukas (Pfarrer) ( †1787), Mönch Pfarrer Zisterzienser
S Fortsetzung
-
Schmidel, Joseph Gabriel , Franziskaner Mönch Studium
- Schneid, Markus Joseph Anton , Amtmann Pflegsverwalter Schüler Studium
- Schneller, Johann Sebastian , Schüler Studium
- Schnitzer, Georg Anton Matthias , Studium
- Schoss , Studium
- Schranzhofer, Jakob Leopold , Studium
- Schreiber, Johann Adam (Pfarrer) , Pfarrer
- Schuchard, Franz Xaver , Studium
- Schuffner, Johann Leonhard , Studium
- Schuller, Johann Anton (*1743), Aktuar Studium
- Schultes, Jakob (1720) (*1720 †1792), Geistlicher Studium
- Schultes, Jakob (Ried) ( †1792), Geistlicher Studium
- Schultheiss, Johann Franz (Postdirektor) , Postdirektor
- Schulz, Anton Michael , Studium
- Schuster, Johann Jakob (Studium) , Advokat Amtmann Studium
- Schuster, Johann Nikolaus , Studium
- Schwarz, Johann Georg (1724) (*1724 †1766), Geistlicher Studium
S Fortsetzung
-
Schwarz, Johann Georg (Unlingen) ( †1766), Geistlicher Studium
- Schweigel, Joseph (Haiming) , Studium
- Schweizer, Johann Kasimir , Studium
- Schweling, Georg Adolph Ferdinand , Studium
- Schwinghammer, Johann Franz , Fechtmeister Tanzmeister
- Schäfer, Karl Amelius , Studium
- Schön, Michael (Alsleben) , Studium
- Schöpf, Anton , Studium
- Schöpfer, Joseph Ignaz , Studium
- Schüreisen, Johann Thomas , Studium
- Sedal, Joseph , Studium
- Sedelbauer, Franz , Studium
- Segmüller, Franz Placidus , Studium
- Seibold, Joseph Ignaz , Schüler
- Sell, Johann Julian , Studium
- Sell, Johann Valentin , Studium