Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1559 JL]]
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='2290482.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='2290482.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 | 922 | 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
NoneM
-
Mauch, Andreas , Studium
- Meichsner, Heinrich , Studium
- Meier, Andreas (Pfarrer, G44758) ( †1574 JL), Pfarrer
- Meier, Daniel (Marbach) ( †1597), Pfarrer Studium
- Meier, Friedrich (Neuburg/Do.) , Pfarrer
- Meier, Hartmann (Heidelberg) , Studium
- Meier, Johann (Dillingen) , Studium
- Meier, Johann (Freiburg) ( †1573 JL), Mönch Studium Zisterzienser
- Meier, Johann (Gerichtsschreiber) ( †1573 JL), Gerichtsschreiber
- Meier, Johann (Gerichtsschreiber, H26902) ( †1773), Gerichtsschreiber
- Meier, Michael (Kösching) , Studium
- Meier, Philipp (Geistlicher) , Geistlicher
- Meier, Wolfgang (Pfarrer, B25178) ( †1559 JL), Pfarrer
- Meiger, Philipp , Studium
- Merath, Christoph , Studium
- Mercatoris, Johann (Bischofsheim) , Studium
- Mert, Johann , Pfarrer
M Fortsetzung
-
Merz, Andreas (Augsburg) , Studium
- Mest, Leonhard , Geistlicher Pfarrer Studium
- Metzler, Gallus , Pfarrer Studium
- Migis, Johann Baptist , Studium
- Miller, Georg (Fürstenberg) , Pfarrer Studium
- Mirben, Georg , Studium
- Mirodorus, Konrad , Studium
- Missenhart, Johann , Notar
- Mock, Christoph (Göggingen) ( †1598), Pfarrer Studium
- Mock, Jakob (1540) (*1540 JL †1616), Mediziner Medizinprofessor Studium
- Mock, Jakob (Freiburg) ( †1616), Mediziner Medizinprofessor Studium
- Mockel, Sebastian , Geistlicher Studium
- Moffel, Vitus , Studium
- Mohr, Johann (Dettingen) , Studium
- Molitor, Adam (Würzburg) , Kanoniker Studium
- Molitor, Jakob (Lindau) , Studium
- Molitor, Johann (1556) (*1556 JL †1622), Jesuit Studium
M Fortsetzung
-
Molitor, Johann (Altomünster) ( †1622), Jesuit Studium
- Molitor, Leonhard (Oberstenfeld) , Studium
- Monsturellus, Thomas , Studium
- Moritz, Georg (Nürnberg) , Studium
- Morlitzen, Ulrich , Mönch Zisterzienser
- Motz, Jakob (Radolfzell) , Studium
- Motzer, Friedrich , Studium
- Muckensturm, Georg , Pfarrer Studium
- Mus, Jakob , Studium
- Mörlin, Martin , Studium
- Müller, Balthasar (Franken) , Studium
- Müller, Johann (Epfenhausen) , Studium
- Müller, Johann (Villingen) , Studium
- Müller, Kilian (Züttlingen) , Studium
- Müller, Thomas (Geistlicher) , Geistlicher
- Müller, Thomas (Strassburg) , Studium