Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1658]]
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='2326632.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='2326632.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 | 791 | 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
-
Pahl, Christian , Studium
- Panzoldi, Johann Martin , Priester
- Perle, Johann Jakob , Studium
- Peter, Franz (Studium) , Jesuitengymnasium Studium
- Pfrang, Andreas Norbert ( †1674), Franziskaner Mönch Studium
- Pfriem, Johann Georg , Studium
- Pfuler, Johann Christoph , Studium
- Philippson, Johann Theodor Dietrich , Studium
- Pichler, Donulus ( †1688), Franziskaner Mönch
- Pierling, Johann Alexander ( †1695), Richter Studium
- Pircher, Jodocus , Studium
- Pittetus, Isaak , Studium
- Pottgiesser, Johann Anton , Studium
- Praelilber, Michael , Studium
- Prassler, Johann , Studium
- Prata, Dominik , Priester
- Prohenberger, Wolfgang Ludwig , Studium
P Fortsetzung
-
Provinz, Johann , Studium
- Publi, Andreas , Schüler
Q
-
Quatfasel, Johann Adam , Studium
R
-
Racker, Georg , Studium
- Raffe, Otto Ortwin , Studium
- Randel, Peter , Studium
- Ransberg, Wolfgang Jakob ( †1694), Geistlicher
- Ranz, Johann (Bezau) , Pfarrer
- Rauschhard, Philipp Konrad , Studium
- Rebholz, Johann Georg , Pfarrer Studium
- Reckel, Jakob (Seebruck) , Studium
- Redel, Johann (Tauberbischofsheim) , Studium
- Reichel, Johann Thomas , Studium
- Reinhard, Wilhelm , Studium
- Reinisch, Ludwig , Studium
- Reis, Andreas (Freiburg) , Studium
- Reiter, Johann Sigismund , Schüler
R Fortsetzung
-
Remich, Adam , Studium
- Remich, Kaspar (Tirol) , Studium
- Renger, Johann Andreas , #Studium Jurist
- Renk, Johann Adam , Studium
- Renner, Johann Andreas (Erfurt) , Studium
- Retle, Markus , Studium
- Rettenbacher, Simon , Studium
- Richard, Johann Baptist (Studium) , Studium
- Rieg, Martin (Studium) , Studium
- Risse, Franz , Studium
- Rizart, Johann Heinrich
- Rosenbusch, Philipp Albert , Studium
- Rost, Adam Jakob , Studium
- Rost, Maurus , Benediktiner Mönch Studium
- Rot, Johann Philipp , Schüler
- Rotacker, Johann (Engen) , Priester Studium