Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1576 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='2296691.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='2296691.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 | 1047 | 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
-
Lengst, Jakob , Studium
- Lengst, Johann (Feldkirch) , Studium
- Lenker, Rasso , Geistlicher Pfarrer
- Lerch, Christoph , Studium
- Leuchtenberg, August Georg Ludwig Landgraf von , Studium
- Lichtenfels, Johann Jakob von , Studium
- Liebler, Christoph (Tübingen) , Studium
- Liebler, Georg (1560) (*1560 JL †1632), Studium
- Liebler, Georg (Tübingen) ( †1632), Studium
- Liebler, Joseph , Studium
- Lierheimer, Georg , Studium
- Lilienfein, Arnold ( †1610), Lehrer Pfarrer Studium
- Lindenmeier, Heinrich Otto , Studium
- Linder, Jakob (Geistlicher) , Geistlicher
- Lindle, Christoph (Stuttgart) , Geistlicher Studium
- Link, Christoph (Studium) , Studium
- Link, Johann (Kirchen) , Geistlicher Studium
L Fortsetzung
-
Link, Johann (Mainbernheim) , Studium
- Locher, Johann (Prämonstratenser) ( †1574 JL), Mönch Pfarrer Prämonstratenser
- Lock, Paul , Studium
- Lohaeus, Stephan ( †1587), Pfarrer Studium
- Lohr, Wilhelm (Priester) , Pfarrer Priester
- Luber, Anton , Studium
- Luber, Johann (Wallis) , Studium
- Ludwig, Johann (Schongau) , Geistlicher
- Ludwig, Johann (Weiler) , Studium
- Ludwig, Peter (Mömpelgard) , Geistlicher Lehrer Studium
- Luitbrand, Johann , Pfarrer Studium
- Lupius, Johann Vitalis , Studium
- Lurkäs, Burkhard , Studium
- Lutzenberger, Johann (Günzburg) ( †1631), Jurist Studium
- Löffler, Paul (Innsbruck) , Studium
- Löhr, Georg , Lehrer Schulmeister
M
-
Mader, Heinrich , Studium
M Fortsetzung
-
Mader, Johann (München) , Studium
- Madruzzo, Franz , Studium
- Mager, Johann (Vaihingen) ( †1626), Pfarrer Studium
- Maler, Christoph (Pfarrer) ( †1587), Pfarrer
- Manz, Jakob (Steinhilben) , Studium
- Marius, Matthias (Studium) , Studium
- Marold, Narziss ( †1578 JL), Pfarrer
- Marschall von Ebneth, Vitus Ulrich , Kanoniker Studium
- Matthias, Tobias , Studium
- Matz, Johann (Roveredo) , Studium
- Mauer, Leonhard , Studium
- Maurer, Michael (Mühlhausen) ( †1587), Geistlicher Studium
- Maurer, Peter (Hof) , Studium
- Mechel, Christian , Studium
- Megele, Christoph , Lehrer Studium
- Meier, Gallus (Ellerbach) , Studium