Semantische Suche
Debug output SQLStore
ASK Query
[[Beruf::Zisterzienserin]]
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='Zisterzienserin') 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='Zisterzienserin') 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 | 183 | 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
NoneM
- Müller, Magdalena ( †1720)
N
- Neff, Dorothea
- Neft, Anna ( †1720)
- Neger, Maria Cäcilia ( †1789)
- Neggis, Walburga
- Nellenburg, Agnes von (*1500 JL)
- Nenningen, Margarete ( †1720)
- Neresheim, Gertraud von
- Neuffen, Elisabeth von ( †1392 JL)
- Neuhausen, Maria Elisabeth von ( †1716)
- Neuhofer, Maria Agathe ( †1720)
- Noblat, Maria Agnes ( †1720)
- Nuser, Maria ( †1740)
O
-
Oettingen, Adelheid Gräfin von (*1437 JL †1437 JL)
- Oettingen, Anna von (*1503 JL †1572 JL)
O Fortsetzung
-
Oettingen, Magdalena (*1424 JL †1502 JL)
- Oettingen, Margarete von (*1471 JL †1477 JL)
- Offenbach, Maria Caecilia ( †1704)
- Osinger, Margarete
P
-
Pappenheim, Anna von ( †1463 JL)
- Pel, Dorothea ( †1720)
- Pelchofen, Maria Hilaria ( †1726)
- Pelkoven, Maria Bernharda ( †1778)
- Peller, Maria Josepha ( †1758)
- Pembler, Maria Benedikta Josepha ( †1745)
- Pembler, Maria Konstanze Katharina ( †1722)
- Pembler, Maria Viktoria ( †1712)
- Peter, Maria Clementina ( †1771)
- Petrissa ( †1388 JL)
- Pfalzer, Maria Benedikta ( †1756)
- Pfersfelder, Ursula ( †1588)
- Pfetten, Konstanze von ( †1645)
P Fortsetzung
-
Pfleger, Maria Euphemia Seraphina ( †1754)
- Pfrost, Maria Hildegund ( †1753)
- Pilbis von Niederulrain und Siegenburg, Maria Hildegard ( †1740)
- Poissl, Anna Maria ( †1661)
- Pott, Maria Humbelina ( †1720)
- Primis, Maria Katharina ( †1797)
- Prost, Maria Hildegard
R
-
Rabe, Elisabeth ( †1720)
- Rad, Katharina ( †1719)
- Radmiller, Maria Barbara (*1720)
- Ratgeb, Maria Franziska (*1761 †1835)
- Ratgeb, Ursula ( †1765)
- Ratzer, Ida Idda Violantia ( †1801)
- Rauch, Maria Anna (Nonne) ( †1778)
- Rauch, Maria Anna (Zisterzienserin) ( †1764)
- Rauscher, Verina ( †1720)