Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1750]]
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='2360234.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='2360234.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 | 801 | 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
-
Rab, Georg Nikolaus , Studium
- Rabenau, Lothar Freiherr von , Studium
- Rammes, Franz Anton , Studium
- Ranz, Johann Jakob , Studium
- Rastbaumwieser, Franz Anton (Pfleger) ( †1770), Pfleger
- Rauch, Johann (München) , Studium
- Rebeschini, Christian , Studium
- Redel, Bruno Valentin , Studium
- Reder, Georg (Haselbach) , Studium
- Rederer, Johann Georg , Arzt Mediziner Studium
- Reichard, Johann Valentin Joseph , Studium
- Reichert, Ursus Joseph (*1730), Studium
- Reichold, Johann Georg , Studium
- Reinbott, Gottlieb Wilhelm , Studium
- Reinhard, Adam , Studium
- Reinhard, Franz Jakob , Studium
- Reinhard, Jakob Christoph , Mönch Servit Studium
R Fortsetzung
-
Reinhard, Johann Kaspar , Studium
- Reis, Andreas Joseph , Studium
- Reisin, Rudolph Jeremias , Studium
- Reisinger, Franz von Paula , Studium
- Remchingen, Franz Christoph Sebastian Freiherr von , Komtur Malteser
- Retzer, Peter Valentin , Domvikar Studium Theologe
- Richard a Corde Maria, Richard , Karmeliter Mönch Prior
- Richter, Jakob (Tittmoning) , Studium
- Rickauer, Joseph (Kemnath) , Studium
- Rickenbach, Joseph Meinrad Franz , Studium
- Riedel, Andreas (Pleinfeld) , Franziskaner Mönch Schüler
- Riederer, Konrad (Franziskaner) , Franziskaner Guardian Mönch
- Riedwieser, Johann Wolfgang , Studium
- Riesler, Jakob , Studium
- Riesner, Johann Gallus , Studium
- Riest, Johann Michael , Schüler
- Rosenzweig, Johann Baptist von , Studium
R Fortsetzung
-
Rosoli, Johann Daniel , Pfarrer Studium
- Rosshirt, Christoph Anton , Studium
- Rossi, Karl Anton , Franziskaner Mönch Studium
- Roter, Franz , Studium
- Rotmund, Fidelis , Studium
- Rubatscher, Karl Anton , Studium
- Ruhl, Johann Georg , Studium
- Rung, Johann Evangelist ( †1790), Pfarrer Studium
- Röll, Valentin Matthias , Studium
- Römelt, Johann Franz , Studium
- Rüd von Collenberg, Johann Georg Freiherr von , Studium
S
-
Saar, Georg , Studium
- Salzgeber, Johann Martin , Pfarrer Studium
- Samhuber, Johann Gregor , Studium
- Sander, Johann Baptist Konrad , Studium
- Sardagna von Meanberg, Karl , Studium