Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1620]]
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='2312752.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='2312752.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 | 989 | 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
NoneL
-
Lochmüller, Johann Michael , Studium
- Lochner, Christoph (Nürnberg) , Studium
- Lohr, Johann (Schrobenhausen) , Studium
- Lohrer, Jakob , Priester Studium
- Loi, Rudolph , Priester Studium
- Lois, Johann Georg , Studium
- Lonius, Johann Jakob , Studium
- Lorenz, Georg (Aichach) , Pfarrer Studium
- Lucius, Georg (Pfarrer) , Pfarrer
- Lutzenberger, Rupert ( †1661), Benediktiner Mönch
- Löcker, Johann , Studium
M
-
Mack, Franz (Mesocco) , Geistlicher Kanoniker Pfarrer Studium
- Mack, Martin (Mesocco) , Studium
- Mader, Jakob (Dürrlauingen) , Studium
- Maler, Johann (Kissing) ( †1636), Franziskaner Mönch
- Mandel, Christoph (Verwalter) , Verwalter
- Mang, Sebastian (Lauenburg) , Studium
M Fortsetzung
-
Mannhart, Johann Adam , Studium
- Marca, Johann , Schüler Studium
- Marius, Absalon , Studium
- Marquard, Jakob (Istein) , Studium
- Martin (Studium) , Studium
- Martini, Sebastian (Uri) , Studium
- Marx, Erhard ( †1638), Abt Benediktiner Mönch Studium
- Masuret, Jakob , Studium
- Maucher, Jakob (Hauerz) , Studium
- Maurer, Andreas (Augsburg, Geistlicher) , Geistlicher Studium
- Meienberg, Johann Jakob , Studium
- Meier, Bartholomäus (Landshut) , Studium
- Meier, Christoph (Tirol) , Jurist Studium
- Meier, Daniel (Zisterzienser) , Mönch Studium Zisterzienser
- Meier, Georg (Heidelberg, Studium) , Studium
- Meier, Jakob (Freiburg/üE) , Studium
- Meier, Johann (Baumkirchen) , Franziskaner Mönch
M Fortsetzung
-
Meier, Johann Georg (Freiburg, Studium) , Studium
- Meier, Johann Jakob (Baden-Baden) , Studium
- Meier, Johann Wilhelm (Freiburg) , Priester Studium
- Meier, Martin (Studium, D24490) , Studium
- Meier, Melchior (Ehingen) , Arzt Mediziner Studium
- Meier, Michael (Allgäu) , Studium
- Meier, Michael Friedrich , Studium
- Meierhofer, Johann (Wemding) , Studium
- Meierhofer, Michael (Wemding) , Studium
- Menger, Oswald , Studium
- Menzel, Johann Albert , Studium
- Mercator, Jodocus , Studium
- Mereißen, Georg , Deutschordensritter Pfarrer
- Merk, Georg (Mattsies) , Schüler
- Merk, Johann (Munderkingen) , Pfarrer Priester Studium
- Merkle, Valerius ( †1633), Augustinerchorherr Kanoniker Studium