Semantische Suche
Debug output SQLStore
ASK Query
[[Geboren::1711]]
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='2345989.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='2345989.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 | 559 | 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
- Wall, Abraham Johann Baptist, Gastwirt Studium
- Wallau, Johann (†1767), Jesuit
- Wanner, Franz Joseph (1711), Schreiber Studium
- Wasner, Georg Michael Sabbas, Franziskaner Mönch
- Weber, Franz Konrad (†1866), Geistlicher Studium
- Weber, Johann Adam (1711) (†1781), Geistlicher Pfarrer Studium
- Weber, Johann Baptist (1711), Studium
- Weber, Joseph Anton (1711), Geistlicher
- Wech, Johann Konrad (1711), Geistlicher Studium
- Wechinger, Joseph Lorenz, Pfarrer Studium
- Wechner, Joseph (†1784), Geistlicher Priester
- Wegele, Franz Ignaz, Franziskaner Mönch Studium
- Wegele, Johann Georg Bernhard Thomas Aquinas (†1758), Benediktiner Mönch Pfarrer Studium
- Weidmann, Johann Felix, Priester Studium
- Weidner, Johann Martin Athanasius (†1744), Franziskaner Mönch
- Weigentaler, Willibald Anton Wernfried, Kapuziner Mönch
- Weinberger, Anton Balthasar Bernhard von (†1793), Benediktiner Mönch Studium
W Fortsetzung
- Weinhart, Johann Gabriel (†1781), Jesuit Studium
- Weinmeier, Franz Ignaz (†1757), Augustinerchorherr Kanoniker Studium
- Weinmüller, Capistranus (†1741), Franziskaner Mönch
- Weiss, Franz Sebastian (1711), Pfarrer Priester
- Weiss, Joseph Landelin, Geistlicher
- Welden, Alexander Johann Albert Rupert Joseph Ernst Freiherr von (†1783), Kanoniker Pfarrer Studium
- Weltin, Franz Emmanuel (†1779), Franziskaner Guardian Mönch
- Weltin, Johann Franz Karl, Pfarrer
- Wequell, Anton Freiherr von Felix Maria (†1774), Kapuziner Mönch
- Werz, Georg von Viktorian (†1780), Kapuziner Mönch Studium
- Wetzler, Johann Erasmus (†1782), Pfarrer Studium
- Wickard, Karl Anton Bonaventura, Pfarrer
- Wiedemann, Franz Joseph (1711), Studium
- Wiedemann, Franz Sales (†1775), Jesuit
- Will, Simon (1711) (†1778), Augustinereremit Mönch Pfarrer Prior
- Wimmer, Franz Gabriel Beanus, Franziskaner Mönch
- Wimmer, Joseph Abraham, Franziskaner Mönch
W Fortsetzung
- Winkler, Franz Joseph Anton (†1766), Augustinerchorherr Kanoniker Studium
- Wirt, Anton (1711) (†1789), Geistlicher Pfarrer Studium
- Wirt, Franz Thomas Leontius (†1771), Pfarrer Studium
- Wohlfahrt, Simon, Jesuit
- Wolf, Franz Nikolaus Virgil (†1773), Kapuziner Mönch
- Woller, Ignaz Lorenz von (†1776), Mönch Prämonstratenser
- Wurm, Ferdinand Heinrich (†1759), Pfarrer Studium
Z
- Zeckeler, Anton (†1780), Geistlicher Priester
- Zehetmeier, Martin Bartholomäus, Pfarrer Studium
- Zehetmeier, Sebastian (1711), Studium
- Zehner, Georg Bernhardin (†1765), Augustinereremit Mönch Studium
- Zeiler, Joseph Felix Richard (†1738), Kapuziner Mönch
- Zeitschel, Magnus (†1765), Benediktiner Mönch
- Zeller, Johann Ulrich (1711) (†1770), Pfarrer Schüler Studium
- Zembrot, Ferdinand Anton, Studium
- Zemmer, Anton (†1773), Geistlicher Priester Studium