Semantische Suche
Debug output SQLStore
ASK Query
[[Geboren::1712]]
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='2346354.5') AND t1.p_id=501)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
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='2346354.5') AND t1.p_id=501)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC
LIMIT
505
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 | 546 | 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
NoneV
- Vonderweid, Alexius (†1783), Jesuit
- Völkel, Martin Petronius (†1762), Kapuziner Mönch
W
- Wagner, Franz Anton (1712) (†1800), Geistlicher Studium
- Wagner, Jakob Norbert (†1755), Augustinereremit Mönch
- Wagner, Johann Michael Anton, Kanoniker Pfarrer Priester Studium
- Wagner, Joseph Andreas, Priester Studium
- Wagner, Sebastian (1712) (†1786), Franziskaner Guardian Mönch Superior
- Waldeisen, Wolfgang (†1757), Jesuit
- Walser, Joseph (1712), Pfarrer Priester Studium
- Walter, Sebastian Dionysius (†1777), Mönch Pfarrer Prämonstratenser
- Wanger, Joseph (†1778), Geistlicher
- Waschan, Nikolaus Erhard (†1786), Kapuziner Mönch
- Weber, Gabriel (1712) (†1738), Jesuit
- Weber, Johann Heinrich Marcellus (†1756), Franziskaner Mönch
- Weber, Joseph Anton (1712), Studium
- Wegscheider, Johann Georg Jakob, Geistlicher
W Fortsetzung
- Weichs, Johann (1712), Studium
- Weichsner, Albert Ignaz, Studium
- Weinbuch, Joseph, Jurist Rat Studium
- Weiner, Philipp (†1768), Jesuit
- Weinhold, Joseph, Studium
- Weiss, Anton (1712) (†1759), Jesuit
- Weiss, Franz Joseph (1712) (†1767), Posthalter Studium
- Weisslämmle, Matthäus (†1744), Studium
- Weninger, Johann Kaspar Johann von Matha (†1778), Franziskaner Mönch
- Wenser in Freienthurn, Franz Ignaz Maria, Mönch Priester Studium Theatiner
- Westermeier, Georg Maximilian Humilis (†1759), Franziskaner Mönch
- Wiedemann, Johann Ferdinand Ignaz Nilus, Franziskaner Mönch
- Wiedemann, Maria Benigna Caritas (†1790), Nonne Zisterzienserin
- Wieland, Karl Joseph, Studium
- Wieland, Michael (1712) (†1762), Franziskaner Mönch Studium
- Willisch, Martin Cosmas, Studium
W Fortsetzung
- Wind, Franz von Paula, Pfarrer Studium
- Winter, Anton Philipp Nerius (†1798), Jesuit
- Winzler, Franz, Geistlicher Studium
- Wolframsdorf, Joseph Maximilian Moritz Maria Freiherr von Franz Maria (†1743), Kapuziner Mönch Studium
- Wösch, Franz Joseph Serenus (†1765), Kapuziner Mönch
Z
- Zagelmeier, Johann Joseph Anton (†1774), Pfarrer Priester Schüler
- Zaunstecken, Dionysius Joseph (†1770), Pfarrer Studium
- Zehetmeier, Franz Anton (1712) (†1775), Pfarrer Priester Studium
- Zeiler, Felix Dionysius Fidelis Maria (†1783), Kapuziner Mönch Studium
- Zeilheim, Felix Dionysius von Fidelis Maria (†1783), Kapuziner Mönch
- Zink, Thomas, Benediktiner Mönch Pfarrer
- Zolg, Anton, Eremit
- Zoller, Johann Baptist (1712), Geistlicher Studium
Ö
- Öchsle, Johann Christoph, Pfarrer Studium