Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1721]]
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='2349642.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='2349642.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 | 759 | 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
-
Pfitscher, Vitus , Studium
- Pfitzer, Johann Joseph , Studium
- Pflaum, Johann Georg ( †1741), Pfarrer
- Piamartha, Bartholomäus Leonhard von , Studium
- Pimpel, Johann (Altenstadt) , Pfarrer
- Pirnay, Wilhelm Franz , Studium
- Pizzini, Peter Paul , Studium
- Polheim in Wartenburg, Franz Georg Adam Graf von , Geistlicher Studium
- Popp, Anton Joseph , Studium
- Popp, Johann Wolfgang (*1684 †1756), Schreiber Verwalter
- Praetor, Johann Georg , Studium
- Prerolgia, Matthias , Studium
- Primus, Joseph Leopold , Studium
- Prontono, Peter , Studium
- Propst, Matthias (Burghausen) , Studium
- Pudewels, Johann Kasimir Freiherr von ( †1757), Richter Studium
- Puglasch, Johann Baptist Georg , Studium
Q
-
Quardis, Joseph Ignaz von , Studium
- Quepp, Johann Baptist Maria , Studium
- Quinzer, Franz Xaver ( †1768), Goldschmied Ratsherr
R
-
Rab, Anton (Ingolstadt) , Studium
- Radmantel, Johann Peter , Studium
- Rameta, Franz Xaver von , Studium
- Rapp, Christoph Friedrich , Studium
- Rauber, Christian ( †1757), Heiliggeistorden Kreuzherr Pfarrer
- Redelmeier, Franz Nikolaus , Studium
- Rehm, Johann Bernhard , Studium
- Reia, Lorenz , Studium
- Reibeld, Anton Joseph , Studium
- Reichard, Joseph Anton , Studium
- Reichel, Wolfgang Sigismund , Studium
- Reichis-Vötterburg-Tausfeld, Thomas , Studium
- Reimer, Johann (Studium) , Studium
- Reinhard, Johann Jakob (Pfarrer) ( †1738), Pfarrer
R Fortsetzung
-
Reister, Franz Sebastian Florentin ( †1731), Franziskaner Mönch Studium
- Reuter, Johann Baptist David , Kanoniker Studium
- Ricci, Joseph Anton (Cembra) , Studium
- Riedler, Andreas , Studium
- Rieger, Ignaz Christoph Cajetan , Studium
- Rieser, Balthasar Christoph , Studium
- Riezler, Johann (Studium) , Studium
- Rimmele, Johann Alban , Pfarrer Studium
- Rimmele, Johann Baptist (Studium) , Studium
- Riss, Anton (Innsbruck) , Mönch Studium
- Rohner, Johann Nikolaus , Studium
- Rohrer, Johann Evangelist , Studium
- Romponi, Simon , Studium
- Ronberger, Franz Ignaz Anton , Studium
- Rosmini, Franz Joseph von , Studium
- Rosner, Johann Wolfgang , Studium