Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Augustinereremit]]
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Augustinereremit') AND t1.p_id=509)
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_blob` AS t1 ON t0.smw_id=t1.s_id
WHERE
(
(t1.o_hash='Augustinereremit') AND t1.p_id=509)
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 | index_merge | s_id, o_hash, s_id_2, p_id | o_hash,p_id | 258,262 | 301 | Using intersect(o_hash,p_id); Using where; 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
NoneH
- Hirster, Johann Martin Dominik Anton (*1698 †1750)
- Hitzelberger, Joseph Leopold (*1749 †1819)
- Hoch, Johann Peter Leopold (*1680 †1719)
- Hoffmann, Ambrosius (Zell)
- Hoffmann, Andreas Fortunat (*1764 †1820)
- Hoffmann, Christoph (1678) (*1678 †1736)
- Hoffmann, Matthias Matthäus ( †1695)
- Hofmeister, Johann (1509) (*1509 JL †1547 JL)
- Hofrichter, Andreas
- Holl, Kaspar (Augustinereremit)
- Holler, Alois ( †1683)
- Holtzing, Jakob (*1500 JL)
- Holz, Benignus (*1680 †1724)
- Holzapfel, Franz (Pfarrer)
- Hopp, Melchior (*1653 †1710)
- Hosenmann, Augustin ( †1801)
H Fortsetzung
- Huber, Hieronymus (1653) (*1653)
- Huber, Johann Nepomuk Felix Adrian (*1720)
- Hufera, Remigius ( †1701)
- Hug, Johann (Esslingen)
- Hugenold, Wilhelm ( †1750)
- Humpel, Andreas Columban (*1650 †1708)
- Hurst, Stephan ( †1667)
- Huter, Kaspar Cajetan Franz Xaver (*1686)
- Höchstetter, Nikolaus Anton Joseph (*1752 †1825)
- Höhn, Antonin (*1700 †1758)
- Hölz, Alois Simon (*1772 †1818)
- Hügel, Angelus Johann Georg Angelus (*1747)
- Hüllmantel, Johann Adam Fulgentius (*1657 †1717)
- Hüllmantel, Kilian (*1676)
- Hüllmantel, Nikolaus Alexius (*1674)
- Hürlimann, Christoph (*1661 †1709)
H Fortsetzung
-
Hürlimann, Nikolaus (*1669 †1740)
I
-
Illein, Johann Andreas Edmund (*1687 †1728)
- Imhof, Johann Evangelist Maximus (*1758 †1817)
- Inninger, Johann Baptist (*1656 †1730)
- Isi, Georg Patritius (*1719 †1786)
J
-
Jais, Michael (*1675)
- Jakob, Anselm Johann (*1702 †1762)
- Jakobitz, Wandalus Eutropius ( †1667)
- Jatter, Alexius
- Jerg, Alexius ( †1673)
- Jerg, Christoph Pelagius (*1732 †1768)
- Jerg, Johann Georg Wenceslaus (*1740 †1810)
- Jerg, Matthias Sigismund (*1752)
- Joachim, Christian ( †1682)
- Jobst, Dominik Stephan (*1765 †1823)
- Johann (München, Augustinereremit)