Semantische Suche
Debug output SQLStore
ASK Query
[[Verstorben::≥1801]] [[Verstorben::≤1900]]
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 t2
INNER JOIN
`smw_di_time` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_sortkey>='2378861.5') AND t2.p_id=530
AND (
(t4.o_sortkey<='2415020.5') AND t4.p_id=530)
)
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 t2
INNER JOIN
`smw_di_time` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_sortkey>='2378861.5') AND t2.p_id=530
AND (
(t4.o_sortkey<='2415020.5') AND t4.p_id=530)
)
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 | t2 | range | s_id, o_sortkey, p_id, p_id_2, s_id_2 | p_id_2 | 13 | 17094 | Using index condition; Using temporary; Using filesort | ||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | rupp.t2.s_id | 1 | Using where | |
1 | SIMPLE | t4 | ref | s_id, o_sortkey, p_id, p_id_2, s_id_2 | s_id_2 | 8 | rupp.t2.s_id, const | 1 | Using where; Using index; Distinct |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneB
-
Beltrami, Georg ( †1824), Pfarrer Priester Studium
- Bencard, Bartholomäus ( †1801), Augustinerchorherr Dekan Kanoniker Kellermeister
- Bendel, Alois (*1774 †1839), Pfarrer
- Bendel, Anton (1783) (*1783 †1871), Geistlicher Pfarrer
- Bendele, Anselm (*1778 †1846), Pfarrer
- Bendele, Franz Joseph Junker von ( †1815), Kanzlist Richter Studium
- Bene, Johann Jakob (*1776 †1844), Pfarrer
- Bengel, Alois (*1775 †1838), Pfarrer Schüler Studium
- Benk, Franz Ignaz (*1754 †1812), Augustinerchorherr Kanoniker Studium
- Benker, Simon (*1800 †1852), Pfarrer Studium
- Benn, Joseph (*1738 †1827), Studium
- Benneberg, Sebastian (*1784 †1823), Pfarrer Priester Schüler Studium
- Benz, Michael (1754) (*1754 †1824), Pfarrer Schüler
- Benzberger, Gerhard (*1772 †1844), Benediktiner Mönch
- Benzinger, Kaspar (1758) (*1758 †1829), Pfarrer
- Beppel, Thomas Anton (*1747 †1831), Pfarrer Schüler
- Berank, Joseph (*1759 †1832), Pfarrer Priester
B Fortsetzung
-
Berberich, Johann Michael (1766) (*1766 †1826), Pfarrer Priester Studium
- Berchem in Niedertraubling, Karl Anton Alois Freiherr von ( †1801), Pfleger Rat Rentmeister Studium Vizedom
- Berchem, Franz Xaver Graf von (*1760 †1805), Studium
- Berchtold, Andreas de Hyspello Andreas (*1792 †1844), Franziskaner Mönch
- Berchtold, Eusebius (*1746 †1808), Augustinerchorherr Kanoniker Studium
- Berchtold, Ferdinand (1767) (*1767 †1826), Pfarrer Priester Schüler
- Berchtold, Franz Anton (1744) (*1744 †1821), Pfarrer Priester Studium
- Berchtold, Johann Baptist (1736) (*1736 †1806), Geistlicher Pfarrer Studium
- Berchtold, Johann Nepomuk Siard (*1751 †1826), Mönch Pfarrer Prämonstratenser Studium
- Berchtold, Joseph Anton (1776) (*1776 †1827), Priester Studium
- Bereiter, Johann Baptist (*1761 †1812), Geistlicher Pfarrer Schüler
- Berg, Franz (1753) (*1753 †1821), Kanoniker Professor Studium
- Bergamin, Lucius Anton (*1758 †1825), Domvikar Kanoniker Pfarrer
- Berger, Basilius (*1734 †1807), Benediktiner Mönch
- Berger, Benedikt (1766) (*1766 †1832), Benediktiner Mönch
- Berger, Benedikt (1784) (*1784 †1828), Pfarrer Priester
- Berger, Franz Joseph ( †1823), Pfarrer
B Fortsetzung
-
Berger, Jakob (1728) (*1728 †1810), Pfarrer Studium
- Berger, Jakob (Ahrn) ( †1810), Pfarrer Studium
- Berger, Johann Baptist Anton (*1747 †1826), Benediktiner Mönch
- Berger, Joseph Dominik (*1802 †1860), Pfarrer
- Berger, Peter Anianus (*1748 †1803), Kapuziner Mönch
- Bergerner, Zeno (*1754 †1801), Franziskaner Mönch
- Berghamer, Alanus (*1721 †1806), Mönch Zisterzienser
- Berghamer, Benedikt (*1751 †1815), Mönch Zisterzienser
- Berghamer, Johann Nepomuk (*1781 †1860), Pfarrer Priester
- Berghofer von Taufers und Moos, Anton Johann von Pirmin (*1751 †1801), Kapuziner Mönch Studium
- Bergkamer, Franz von Paula Rupert (*1773 †1834), Mönch Studium Zisterzienser
- Bergkamer, Lambert (*1755 †1823), Geistlicher Mönch Zisterzienser
- Bergmann, Ignaz (*1784 †1846), Pfarrer
- Bergmann, Joseph (1740) (*1740 †1803), Jesuit
- Bergmann, Michael (*1772 †1842), Geistlicher
- Bergmeier, Franz (*1757 †1845), Pfarrer Studium