Semantische Suche
Debug output SQLStore
ASK Query
[[Geboren::1720]]
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='2349276.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='2349276.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 | 571 | 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
NoneU
- Unhold, Lorenz (†1765), Mönch Zisterzienser
- Unsinn, Johann Anton David, Studium
- Urbin, Johann Baptist, Studium
V
- Vanossi, Maria Franziska Josepha (†1771), Nonne Zisterzienserin
- Veit, Ignaz (†1757), Jesuit
- Vetter, Michael Accursius (†1767), Kapuziner Mönch Studium
- Villgrater, Michael Christian (†1788), Jesuit Priester Studium
- Vogel, Anicetus (†1804), Franziskaner Mönch
- Vogel, Franz Joseph (1720), Geistlicher Pfarrer Studium
- Volk, Johann Georg (1720), Pfarrer Studium
- Volkert
- Vonderlew, Viktor (†1786), Benediktiner Mönch Studium
- Völk, Leonhard, Studium
W
- Wagner, Johann Joseph Perfectus (†1772), Guardian Kapuziner Mönch
- Wagner, Joseph Felix Ildephons (†1769), Benediktiner Pfarrer
- Waldreich, Johann Cajetan, Priester
- Walter, Georg Basilius (†1758), Augustinereremit Mönch
W Fortsetzung
- Wanner, Joseph Franz Ignaz, Geistlicher Pfarrer Schüler Studium
- Weber, Georg Gabriel (†1796), Augustinerchorherr Kanoniker Studium
- Weber, Michael (1720) (†1770), Jesuit
- Weber, Paul (1720), Studium
- Weber, Ulrich (†1758), Benediktiner Mönch
- Weidacker, Nikolaus, Geistlicher
- Weigel, Johann Georg Colomann (†1756), Franziskaner Mönch
- Weihenmeier, Joseph Melchior Martin, Geistlicher Studium
- Weinmann, Anton Joseph (†1769), Jesuit Studium
- Weiss, Franz Albin, Geistlicher Pfarrer
- Weiss, Johann Jakob (1720) (†1772), Geistlicher Priester Studium
- Weiss, Joseph (1720), Geistlicher
- Weiss, Maria Regina Anna (†1778), Nonne Zisterzienserin
- Weitacker, Nikolaus, Pfarrer
- Weizenbeck, Anton (†1787), Kanzler Pflegskommissär Rat Studium
- Weizenecker, Johann Michael, Studium
- Werder, Franz Anton (†1759), Augustinerchorherr Kanoniker Studium
W Fortsetzung
- Westermeier, Anton (1720), Priester Studium
- Westermeier, August (†1744), Studium
- Wetzel, Jakob (1720), Jesuit
- Wetzel, Johann Baptist (1720), Pfarrer Studium
- Wetzstein, Ignaz Gottlieb Amadeus Cajetan (†1786), Jurist Rat Studium
- Wiedemann, Jakob Anton, Pfarrer Studium
- Wiedemann, Margarete (1720), Nonne Zisterzienserin
- Wiedemann, Matthias Georg, Pfarrer Studium
- Wierer, Joseph Ferdinand Stephan (†1773), Kapuziner Mönch Studium
- Wiesenpeintner, Georg Ignaz, Studium
- Wieser, Edmund (†1795), Franziskaner Mönch
- Wilhelmseder, Johann Franz Xaver Kaspar, Pfleger Studium
- Winatzer, Engelbert Corbinian (†1802), Kapuziner Mönch
- Winkelmeier, Franz Joseph, Priester Studium
- Winkelmeier, Franz Xaver Raimund (†1753), Augustinerchorherr Kanoniker Studium
- Winkler, Maria Apollonia, Nonne Zisterzienserin