Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1675]]
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='2332841.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='2332841.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 | 705 | 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
NoneR
-
Roth, Johann Konrad (Überlingen) , Studium
- Rotmeier, Johann Rupert , Pfleger
- Rottenburger, Gregor Georg (Überlingen) ( †1725), Geistlicher Pfarrer Studium
- Ruhier, Nikolaus ( †1698), Geistlicher Pfarrer Priester Studium
- Russ, Anton , Studium
- Russer, Andreas , Studium
- Röls, Johann (Schwandorf) , Schüler Studium
- Römer, Johann Wilhelm , Studium
- Römer, Philipp Daniel , Studium
- Rössler, Friedrich Anton ( †1726), Rat Sekretär Studium
S
-
Sahm, Johann Jakob , Geistlicher
- Salis, Johann , Studium
- Saller, Johann Philipp Jakob ( †1744), Augustinerchorherr Kanoniker Pfarrer Studium
- Schacher, Johann Georg , Studium
- Schaller, Joseph (Laufenburg) , Studium
- Schallhuber, Balthasar Bernhard ( †1684), Benediktiner Mönch Studium
- Scharl, Anton , Studium
S Fortsetzung
-
Scheffler, Georg Friedrich , Schüler
- Scherer, Johann Adam (Pfarrer) , Pfarrer Studium
- Scheuch, Andreas , Priester
- Schild, Franz Joachim (Würzburg) , Studium
- Schlechten, Karl Maurus von , Studium
- Schlump, Johann , Pfarrer
- Schmalzhofer, Johann , Studium
- Schmid, Andreas (Steinekirch) , Priester
- Schmid, Gallus (1657) (*1657 †1732), Augustinerchorherr Kanoniker Studium
- Schmid, Gallus (Gries) ( †1732), Augustinerchorherr Kanoniker Studium
- Schmid, Johann Michael (Studium) , Studium
- Schmid, Lorenz (Studium, C5474) , Benediktiner Mönch Studium
- Schmid, Michael (Studium) , Studium
- Schmid, Michael (Studium, B23042) , Studium
- Schmid, Sebastian Anton (Studium) , Studium
- Schmidbauer, Leonhard (Studium) , Studium
- Schmidlin, Johann Joseph , Studium
S Fortsetzung
-
Schmidlin, Lukas , Studium
- Schmidmann, Eberhard , Studium
- Schneid, C.
- Schneid, Nikolaus (Trarbach) , Studium
- Schnewly von Bernlapp zu Bollschweil, Leopold Wilhelm Freiherr von , Studium
- Scholter, Johann Andreas , Pfarrer Studium
- Schorer, Georg (Studium) ( †1706), Pfalzpropst Studium
- Schreffel, Jonas , Studium
- Schreiber, Johann Adam (Studium) , Studium
- Schrenk von Notzing, Willibald Heinrich , Studium
- Schröder, Johann Wilhelm (Regensburg) , Studium
- Schubert, Johann Ernst , Studium
- Schultheiss, Johann Jakob , Studium
- Schutzbar genannt Milchling, Georg Wilhelm Kasimir , Kanoniker Studium
- Schwab, Franz (Studium, H5251) , Studium
- Schwager, Adam (Studium) , Studium