Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Augustinerchorherr]]
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='Augustinerchorherr') 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
0
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='Augustinerchorherr') 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
0
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 | 2084 | 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
NoneA
- Abele, Bonaventura (Kanoniker) ( †1654)
- Abertshauser, Gilbert (*1667 †1725)
- Abertshauser, Gregor Georg ( †1632)
- Abertshauser, Kaspar
- Abertshauser, Peter (*1672 †1741)
- Abt, Bernhard Raimund (*1744 †1785)
- Achatius (Augustinerchorherr)
- Acher, Johann Evangelist Anton (*1744 †1825)
- Achmüller, Christoph (*1636 †1685)
- Adam, Johann (Guebwiller)
- Adam, Michael Sigismund (*1776 †1849)
- Adelmann, Johann (Kanoniker)
- Adler, Franz Ignaz Gabriel (*1663 †1744)
- Adler, Martin (*1776 †1850)
- Aedituus, Stephan
- Agricola, Augustin (Studium)
A Fortsetzung
-
Agricola, Georg Kaspar (*1589 †1642)
- Agricola, Gregor (Augustinerchorherr) ( †1642)
- Agricola, Leonhard (Studium)
- Agricola, Rudhart ( †1693)
- Alban, Christoph (*1685 †1736)
- Alban, Matthias (*1672 †1717)
- Alber, Johann (Augustinerchorherr)
- Albert (Augustinerchorherr)
- Albert (Augustinerchorherr, H19868)
- Albert (Kanoniker) ( †1495 JL)
- Albertis, Anton von (*1668 †1714)
- Albertshauser, Peter (*1672 †1740)
- Albrecht, Heinrich (Pfarrer)
- Albrecht, Melchior Franz Bernhard (*1653 †1695)
- Albrecht, Simon Sebastian (*1755 †1821)
- Alchenmeier, Vitus ( †1515 JL)
- Alramar, Heinrich ( †1495 JL)
A Fortsetzung
-
Altlehner, Alipius (*1665 †1741)
- Altmann, Wolfgang Ubald (*1625)
- Altmannshausen, Johann Ernst
- Alzinger, Johann (Kanoniker) ( †1514 JL)
- Amberg, Johann Gebhard de Amberg ( †1489 JL)
- Ambling, Augustin
- Ambrosius (Augustinerchorherr) ( †1186 JL)
- Ammann, Heinrich (Kanoniker)
- Ammann, Johann (Kanoniker)
- Ammann, Martin (1570) (*1570 JL †1593)
- Ammann, Simpert ( †1578 JL)
- Amoltern, Johann von
- Amon, Martin (Augustinerchorherr) ( †1593)
- Amort, Thomas Eusebius (*1692 †1775)
- Ampas, Joseph Konrad (*1661 †1749)
- Amtmann, Johann (*1672 †1740)