Semantische Suche
Debug output SQLStore
ASK Query
[[Nachweisjahr::1588]]
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='2301064.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='2301064.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 | 979 | 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
-
Mannsharter, Joachim , Studium
- Manz, Abraham , Studium
- Manz, Georg (Geistlicher, G10121) , Geistlicher
- Markus (Pfarrer) , Pfarrer
- Marolding, Johann Christoph , Studium
- Martin, Albert , Studium
- Martini, Kaspar (Ingolstadt) , Studium
- Mattheiss, Leonhard , Franziskaner Jesuitengymnasium Studium
- Maucher, Jakob (Wurzach) , Studium
- Maus, Johann Christoph , Jurist Kanoniker Studium
- Maus, Johann Georg , Studium
- Mechel, Jakob (Pfarrer) , Pfarrer
- Meier, Andreas (Wurzach) , Studium
- Meier, Georg (Rastatt) , Studium
- Meier, Jakob (Stetten) , Studium
- Meier, Jodocus (Mainburg) , Studium
- Meier, Johann (Altdorf) , Geistlicher Studium
M Fortsetzung
-
Meier, Johann (Brunnhofen) , Studium
- Meier, Johann (Dillingen, Jesuitengymnasium) , Jesuitengymnasium Studium
- Meier, Johann (Geistlicher, F19134) , Geistlicher
- Meier, Johann (Nürnberg, Studium, H3086) , Studium
- Meier, Johann (Pedell) ( †1601), Pedell
- Meier, Johann (Pfarrer, B42088) , Pfarrer
- Meier, Johann (Rettenbach) , Studium
- Meier, Johann (Zisterzienser, C20121) ( †1588), Mönch Zisterzienser
- Meier, Johann Georg (Pfleger) , Pfleger
- Meier, Johann Jakob (Ried) , Studium
- Meier, Meinrad , Pfarrer Studium
- Melchior, Johann (Sachsen) , Studium
- Memminger, Johann (Zusmarshausen) , Studium
- Merk, Johann (Geistlicher, G41459) , Geistlicher
- Mertel, Leonhard (Osterzhausen) , Geistlicher Pfarrer
- Metzenhauser, Philipp (Strassburg) , Studium
- Michael, Joachim , Pfarrer
M Fortsetzung
-
Michael, Magnus (Memmingen, Studium) , Studium
- Micillus, Jakob , Studium
- Milli, Johann Heinrich , Geistlicher
- Milonius, Michael , Lehrer Pfarrer Studium
- Mitschelin, Balthasar (*1571 JL), Studium Verwalter
- Mitschelin, Gebhard , Studium
- Moie, Wilhelm , Studium
- Molendino, Peter von , Studium
- Molitor, Hieronymus , Studium
- Molitor, Johann (Saulgau) , Kaplan Studium
- Moll, Israel , Studium
- Moosmüller, Andreas (Prien) , Augustinerchorherr Kanoniker Lehrer Studium
- Morhard, Johann Kaspar , Notar Prokurator
- Morner, Johann (Studium) , Studium
- Moser von Filseck, Balthasar (1579) (*1579 JL †1597), Amtmann Rat Studium Vogt
- Moser von Filseck, Balthasar (Tübingen) ( †1597), Amtmann Rat Studium Vogt