Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1665]]
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='2329189.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='2329189.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 | 707 | 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
-
Scherer, Bartholomäus (Engen) , Geistlicher Pfarrer Studium
- Scherer, Ferdinand Joseph , Schüler Studium
- Scherer, Otto ( †1692), Priester
- Scheufele, Leonhard , Schüler Studium
- Scheuri, Friedrich (Rheinfelden) , Studium
- Schick, Johann (Landsberg) , Geistlicher Schüler Studium
- Schimmri, Johann Georg , Studium
- Schirmf, Franz
- Schlecht, Johann Georg , Studium
- Schlechtsleben, Hugolin , Franziskaner Mönch
- Schlee, Franz , Studium
- Schlichtherr, Johann ( †1682), Pfarrer Priester Studium
- Schliderer von Lachen, Marquard Ferdinand , Kanoniker Studium
- Schlinger, Johann Jakob , Studium
- Schlosser, Johann Adam , Studium
- Schlupp, Nikolaus , Studium
- Schlössinger, Franz (Saverne) , Studium
S Fortsetzung
-
Schmid, Andreas (Trübenbach) , Studium
- Schmid, Georg (Mühldorf) , Studium
- Schmid, Johann Georg (Überlingen) , Studium
- Schmoller, Johann Bernhard ( †1676), Advokat Jurist Studium
- Schnebele, Johann Martin , Studium
- Schneeburg, Franz Freiherr von , Geistlicher
- Schneider, Peter Patiens (*1646 †1675), Kapuziner Mönch
- Schnode, Johann , Studium
- Schnur, Johann (Miltenberg) , Studium
- Schragmüller, Georg Berthold , Studium
- Schramm, Johann (Bamberg) , Studium
- Schreiber, Matthias (Innsbruck) , Studium
- Schrottenbach, Otto Wilhelm , Studium
- Schuchard, Heinrich , Studium
- Schulig, Johann , Studium
- Schulthaus, Johann Franz , Priester
- Schunz, Johann Michael , Studium
S Fortsetzung
-
Schuster, Franz (Konstanz) , Studium
- Schuster, Johann Jodocus (*1642), Priester Studium
- Schwabel, Kaspar
- Schwarz, Johann Friedrich , Studium
- Schwegler, Heinrich Christoph , Schüler Studium
- Schweiger, Andreas (Straubing) , Studium
- Schwerter, Ferdinand Philipp , Studium
- Schwingenkessel, Jakob , Pfarrer Schüler
- Schön, Michael (Masevaux) , Studium
- Schönborn von Reichelsberg, Lothar Franz Freiherr von , Kanoniker Studium
- Schönhuber, Franz (Schüler) , Schüler Studium
- Schönhuber, Johann Joseph (Schüler) , Schüler
- Sedelmeier, Balthasar (Kanzlist) ( †1691), Gerichtsschreiber Kanzlist
- Sedelmeier, Jakob (Schüler) , Schüler Studium
- Seel, Andreas , Priester
- Seepointer, Georg Ferdinand , Studium