Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1696]]
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='2340511.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='2340511.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 | 838 | 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
NoneO
-
Osterhamer, Joseph , Studium
- Ostermann, Joseph (Meran) , Studium
- Ostermeier, Johann Paul , Studium
- Ostermeier, Vitus , Kanzlist Schreiber
P
-
Pahl, Johann Michael , Studium
- Pankraz, Christoph , Studium
- Panzer, Jakob
- Pappus von Trazberg, Joseph Anton , Franziskaner Mönch Studium
- Paravicini, Franz Freiherr von , Studium
- Pasollo, Johann Leonhard Anastasius , Priester
- Pauli, Johann Georg (Neustadt a.d.Saale, Studium) , Studium
- Paurnfeindt ab Eys, Johann Georg Ludwig , Studium
- Penasa, Friedrich , Priester
- Petri, Columban , Benediktiner Mönch Studium
- Pfeiffer, Johann Thomas ( †1728), Pfarrer Priester Schüler Studium
- Pfeiffer, Joseph (Sélestat) , Studium
- Pfister, Ignaz Thomas , Studium
P Fortsetzung
-
Pfitzer, Christoph Anton ( †1703), Studium
- Pilsel, Gottfried Christian , Studium
- Pivelli, Johann (Fassa) , Studium
- Placidus von Imst, Placidus , Kapuziner Mönch
- Plan, Felix , Studium
- Plebst, Andreas (Studium, G7227) , Studium
- Plönnies, Johann Friedrich , Studium
- Portschoner, Johann , Studium
- Praetor, Manfred Franz , Studium
- Pranger, Franz Anton , Studium
- Pranger, Johann Baptist , Studium
- Prati, Nikolaus , Studium
- Puttinger, Joseph , Studium
Q
-
Quicken, Johann Heinrich , Studium
R
-
Rasom, Matthias , Studium
- Rechel, Johann Joseph , Studium
- Reder, Johann Andreas , Studium
R Fortsetzung
-
Redle, Johann Anton , Studium
- Reichherzer, Joseph Bernhardin , Studium
- Reindel, Joseph Cleophas ( †1712), Franziskaner Mönch Schüler
- Reiner, Andreas (Burghausen) , Studium
- Reishart, Johann Baptist , Geistlicher
- Reisner in Lichtenstern, Franz Christoph , Studium
- Reitenecker, Johann Wilhelm , Schüler
- Reitmeier, Johann Georg , Studium
- Renner, Matthias (Weilheim) , Priester
- Ricci, Christian Heinrich , Studium
- Rieder, Johann Jakob (Bissingen) , Schüler
- Riedle, Georg (Pfarrer) ( †1710), Pfarrer
- Rieger, Franz Xaver (Schwäbisch Gmünd) , Pfarrer Studium
- Rier, Franz Ignaz ( †1698), Studium
- Rinalda, Johann , Studium
- Rintsch, Alexander , Studium