Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1622]]
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='2313483.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='2313483.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 | 777 | 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
NoneP
-
Pinelli, Nikolaus Graf von , Studium
- Pirino, Ludwig , Studium
- Piscator, Bartholomäus , Priester
- Ploching, Michael (Ehingen) ( †1652), Geistlicher Pfarrer Studium
- Posarelli, Johann Baptist , Studium
- Poteratius, Timotheus , Studium
- Prediger, Georg Konrad , Studium
- Prinzer, Peter , Geistlicher
R
-
Rall, Wolfgang , Studium
- Ramig, Georg , Studium
- Rat, Kaspar von , Buchdrucker Studium
- Rauch, Johann Konrad , Schüler
- Recher, Johann Simon , Studium
- Reger, Georg (Nabburg) , Studium
- Rehlingen, Markus , Studium
- Rehlinger, Magnus Anton Christoph , Studium
- Rehlinger, Markus Anton (Schlipsheim, Studium) , Studium
R Fortsetzung
-
Rehlinger, Meinrad Christoph , Studium
- Rehlinger, Ulrich (Schlipsheim) , Studium
- Rehm, Gregor , Priester Studium
- Reichard, Wolfgang , Domvikar Geistlicher Studium
- Reichel, Johann (Hersbruck) , Studium
- Reichelsberger, Sebastian , Pflegsverwalter
- Reifenstuhl, Johann (Tölz) , Studium
- Reinbold, Nikolaus , Studium
- Reindel, Liebhart , Pfarrer Priester Schüler Studium
- Reiner, Johann (Bregenz, Priester) , Priester Studium
- Reisberger, Maurus (Studium) , Benediktiner Mönch Studium
- Reistecker, Johann , Studium
- Reiter, Ambrosius (Weil) , Studium
- Reitnau, Wolfgang Dietrich Theoderich , Studium
- Renk, Friedrich , Studium
- Renner, Wolpert , Geistlicher Pfarrer
- Rensch, Johann (Münzmeister) , Münzmeister
R Fortsetzung
-
Retzer, Anselm Daniel (*1601), Arzt Mediziner Professor Studium
- Richard, Johann (Schrobenhausen) , Studium
- Richard, Peter (Besançon) , Studium
- Rickenbach, Kaspar Balthasar von (*1598), Studium
- Riegel, Johann (Gerichtsschreiber) ( †1638), Gerichtsschreiber
- Rieger, Johann (Gerichtsschreiber) , Gerichtsschreiber Schreiber
- Riest, Nikolaus , Mönch Zisterzienser
- Ritter, Franz (Ulm) , Studium
- Rittler, Ferdinand , Mönch Pfarrer Prämonstratenser
- Rixner, Johann Christoph ( †1638), Gymnasium Pfarrer
- Robelin, Claudius (*1607), Studium
- Rockenweg, GEorg , Pfarrer
- Rodner, Leonhard , Studium
- Rohrmeier, Johann (Pfarrer) , Pfarrer
- Rot, Peter (Laimbach) ( †1649), Geistlicher Pfarrer
- Rot, Wolfgang (Nidwalden) , Studium