Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Benediktinerin]]
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='Benediktinerin') 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='Benediktinerin') 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 | 154 | 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
-
Ackermann, Agathe ( †1680)
- Adelmann, Maria Anna Xaveria (*1683 †1709)
- Adelmann, Maria Theresia
- Adler, Juliana ( †1554 JL)
- Affer, Katharina (*1591 †1666)
- Agathe (Nonne)
- Ahaimb, Elisabeth
- Ahaimb, Maria Sebastiana von ( †1747)
- Altkirch, Maria Rosa Crucifixa (*1689 †1766)
- Amon, Agathe
- Amort, Maria Salome
- Angerbeck, Dorothea
- Asch, Aloisia Amanda von ( †1745)
- Asch, Maria Aloisia (1699) (*1699 †1760)
- Asch, Maria Anna Aloisia Amanda von
- Attenfelder, Petrissa
- Auer, Maria Anna Carolina (*1678 †1742)
A Fortsetzung
- Auer, Regina
- Auerberger, Margarete ( †1600)
- Axter, Maria Magdalena (*1658 †1729)
B
-
Bader, Elisabeth ( †1594)
- Baier, Kunigunde ( †1638)
- Baier, Margarete Monika (*1629 †1703)
- Baier, Maria Anna Benedikta (*1707 †1786)
- Baier, Maria Regina Benedikta
- Baier, Maria Seraphina (*1622 †1702)
- Baier, Regina
- Baldeck, Anna von ( †1603)
- Ballmer, Maria Elisabeth (*1625 †1705)
- Balthasar, Johanna ( †1663)
- Bassi, Maria Claudia (*1738 †1800)
- Baumann, Afra
- Baumann, Anna
B Fortsetzung
-
Baumann, Maria Anna Ludovica (*1758 †1799)
- Baumgarten, Magdalena Tugendlieb (*1601 †1647)
- Baumgartner, Eva
- Benedikta
- Benzenau, Maria Johanna Ludgard ( †1705)
- Berchtold, Maria Kunigunde
- Berfall, Maria Rufina Osita Benedikta (*1683 †1733)
- Berg, Magdalena von
- Berger, Franziska ( †1751)
- Beser, Barbara
- Best, Lucia
- Biechelmeier, Martha ( †1676)
- Biller, Maria Felicitas ( †1758)
- Biller, Potentiana Potenciaria
- Birkenstein, Maria Hildegard von ( †1767)
- Birkmeier, Maria Barbara ( †1724)