Semantische Suche
Debug output SQLStore
ASK Query
[[Geboren::1701]]
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='2342337.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
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='2342337.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
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 | 529 | 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
NoneW
- Wenser, Bernhardin August von Franz (†1766), Kapuziner Mönch
- Wenser, Ignaz Anton Ferdinand Marian von (†1761), Mönch Studium Zisterzienser
- Werner, Jakob Ossian, Franziskaner Mönch
- Westernach, Johann Karl von (1701) (†1760), Kanoniker Studium
- Wiedemann, Joseph (1701), Studium
- Wiegand, Sebastian, Jesuit
- Willi, Franz Anton Rigobert (†1762), Franziskaner Mönch Studium
- Winkelmann, Ludwig, Jesuit
- Winkler, Ferdinand Gundram, Franziskaner Mönch
- Winkler, Guntram (†1760), Franziskaner Mönch
W Fortsetzung
- Winterholer, Anton Johann (†1756), Augustinerchorherr Kanoniker Studium
- Wirle, Johann Baptist, Jesuit
- Wirmeier, Karl (†1740), Benediktiner Mönch Studium
- Wirz, Johann Ignaz (1701) (†1752), Kanoniker Pfarrer
- Wittmann, Dominik Nikolaus (†1735), Augustinereremit Mönch Studium
- Wocherslander, Ignaz (†1731), Augustinerchorherr Kanoniker
- Wolframsdorf, Joseph Franz Maria Moritz Freiherr von (†1767), Rat Studium
Z
- Zecherle, Johann Baptist, Studium
- Zehetmeier, Sebastian (1701), Studium
- Zeidler, Georg Anton, Priester Studium
Z Fortsetzung
- Zeller, Christoph (1701), Pfarrer Studium
- Zeller, Magnus Konrad (†1767), Pfarrer Studium
- Zeltner, Franz Xaver (†1743), Jesuit
- Ziegler, Beda (†1756), Benediktiner Mönch
- Zimmermann, Georg (1701), Studium
- Zimmermann, Johann Martin, Pfarrer Studium
- Zinnenberg, Joseph Ignaz Eligius von (†1776), Kanoniker Pfarrer Studium
- Zwerger, Johann Matthias Asterius (†1758), Franziskaner Mönch Studium
- Zwickle, Matthäus, Priester Studium