Semantische Suche
Debug output SQLStore
ASK Query
[[Wirkungsort::Brixen (Diözese)]]
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='Brixen (Diözese)') AND t1.p_id=507)
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='Brixen (Diözese)') AND t1.p_id=507)
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 | ref | s_id, o_hash, s_id_2, p_id | p_id | 262 | const, const | 4078 | Using index condition; 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
NoneB
-
Brucker, Paul , Geistlicher
- Bruckmüller, Andreas , Geistlicher
- Brunello, Johann Baptist , Priester
- Brunello, Michael (*1631), Priester Studium
- Bruni, Johann Franz (*1720 †1776), Pfarrer Priester
- Brunner, Andreas (1589) (*1589 †1650), Geistlicher Jesuit
- Brunner, Balthasar (Deutschnofen) , Geistlicher Studium
- Brunner, Franz (1626) (*1626), Geistlicher Priester Studium
- Brunner, Georg (1595) (*1595), Priester
- Brunner, Paul (1703) (*1703), Geistlicher
- Brunner, Paul (Schwaz) , Priester
- Brunner, Valentin (Brixen) , Priester
- Brunner, Vitus (1656) (*1656), Geistlicher Priester Studium
- Brunner, Wolfgang (1611) (*1611 †1664), Jesuit Priester Studium
- Brunner, Wolfgang (Hall/Tir.) , Priester
- Buchauer, Christoph (Innsbruck) , Priester
- Buchberger, Corbinian Matthias (*1708 †1766), Geistlicher Priester Studium
B Fortsetzung
-
Buchenberger (*1612), Geistlicher Priester Studium
- Buchenberger, Christoph (*1589 †1624), Kapuziner Mönch Pfarrer Priester
- Buchenberger, Johann Anton (*1665 †1721), Kanoniker Pfarrer Priester Studium
- Buchenberger, Michael (*1608), Priester
- Bucher, Hieronymus (1595) (*1595), Priester
- Bucher, Leopold ( †1732), Geistlicher Priester Studium
- Buchler, Matthäus , Geistlicher
- Buchmann, Konrad , Geistlicher Mönch
- Buchner, Johann Baptist , Geistlicher Studium
- Buckel, Sigismund (1500) (*1500 JL), Priester
- Bucker, Johann (Freising) , Geistlicher
- Buffi, Anton , Priester
- Buhl, Franz (Pinè) , Geistlicher
- Buhl, Georg (Bruneck) , Geistlicher
- Buhl, Johann (Bruneck) , Priester
- Buhl, Johann Andreas (*1695), Geistlicher Studium
- Bunleichler, Gallus , Geistlicher Studium
B Fortsetzung
-
Burgeier, Thomas (*1608), Franziskaner Mönch Priester
- Burger, Coelestin (*1615 †1685), Franziskaner Geistlicher Mönch
- Burger, Konrad (Hüfingen) ( †1574 JL), Geistlicher Pfarrer Priester Studium
- Burgoweranus, Thomas , Priester
- Burgstaller, Michael (1602) (*1602), Priester
- Burgwalder, Georg Joseph (*1696), Geistlicher
- Burgwalder, Johann Georg , Priester
- Burgwalder, Johann Karl (*1719 †1760), Geistlicher Priester
- Burnell, Georg , Priester
- Burtscher, Andreas Ignaz (*1721 †1798), Geistlicher Priester Studium
- Burtscher, Johann Anton (*1718 †1790), Geistlicher Priester Studium
- Busenhart, Georg , Geistlicher
- Busettis, Anton , Geistlicher
- Busettis, Bartholomäus , Priester
- Busettis, Franz Anton Xaver , Geistlicher
- Busettis, Johann Jakob , Geistlicher Pfarrer