Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1499 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='2268567.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='2268567.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 | 957 | 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
-
Liebensau, Heinrich von , Advokat Assessor Prokurator
- Lingau, Johann von , Studium
- Link, Friedrich (Schwabach, Studium) , Studium
- Link, Jakob (Münsingen) ( †1519 JL), Pfarrer Studium
- Lober, Kaspar (Höchstädt) , Geistlicher Studium
- Lorle, Johann (Neckarsulm) , Studium
- Lotzmann, Johann , Studium
- Luckinger, Johann , Mönch Pfarrer Prämonstratenser Studium
- Lunick, Wilhelm , Assessor
- Lunn, Balthasar , Pfarrer
- Lupf, Philipp , Studium
M
-
Mader, Johann (Pöttmes) , Studium
- Maler, Matthäus (Amberg) , Studium
- Mangold, Georg Johann , Studium
- Mangold, Johann (Altkirch) , Studium
- Mani, Benedikt , Studium
- Mann, Nikolaus (Mosbach) , Studium
M Fortsetzung
-
Mannheimer, Bartholomäus , Kastner
- Markstaller, Peter (Ravensburg) , Studium
- Marschall, Nikolaus , Studium
- Marstaller, Peter (Regensburg) , Studium
- Matzner, Ägidius , Konventuale
- Maurer, Christoph (Nürnberg) , Studium
- Maurer, Johann (Buchen) , Studium
- Meder, Johann (Eppingen) , Studium
- Meier, Erhard (Pressath) , Studium
- Meier, Georg (Donauwörth, Studium) , Studium
- Meier, Johann (Aichau) , Studium
- Meier, Martin (Blaubeuren) ( †1553 JL), Pfarrer Studium
- Meier, Martin (Lauda) , Studium
- Meier, Tillmann , Studium
- Melisch, Paul , Studium
- Melsinger, Johann , Studium
- Mendel von Steinfels, Wolfgang , Kanoniker Studium
M Fortsetzung
-
Mendel, Johann (München) , Studium
- Menhartinger, Sigismund , Studium
- Mertingen, Leonhard , Studium
- Meske, Georg , Studium
- Messelberger, Johann , Studium
- Messer, Konrad , Studium
- Mett, Georg , Studium
- Miesner, Georg , Studium
- Mitterhofer, Leonhard (Strasswalchen) , Studium
- Miéville, Heinrich von , Studium
- Model, Melchior (Neustadt, Studium) , Studium
- Molitoris, Johann (Studium, H21700) , Studium
- Molitoris, Sixt (Schwäbisch Hall) , Studium
- Moll, Christian ( †1540 JL), Geistlicher Studium
- Moll, Georg (Biberach) , Studium
- Mooserd, Christian , Studium