Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Vorarlberg]]
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='Vorarlberg') AND t1.p_id=963)
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='Vorarlberg') AND t1.p_id=963)
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 | 4304 | 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
-
Butscher, Kaspar , Studium
- Butzenreiner, Leonhard (*1576 JL), Domkustos Kanoniker Pfarrer Studium
- Buzereiner, Johann , Studium
- Buzereiner, Ulrich , Pfarrer Studium
- Buzerin, Christian , Studium
- Buzerin, Johann Ulrich ( †1694), Studium
- Böchle, Meinrad , Schüler
- Böck, Georg Andreas (Bregenz) , Studium
- Böck, Kaspar (Bludenz) , Studium
- Böcklin, Markus , Geistlicher Pfarrer Studium
- Böcklin, Meinrad , Studium
- Böll, Johann (St.Gallenkirch) ( †1695), Pfarrer Studium
- Bösmeier, Johann , Studium
- Büchelberg, Johann , Studium
- Büchele, Johann (1647) (*1647), Pfarrer Studium
- Büchelmann, Georg , Studium
- Büchelmann, Matthäus , Studium
B Fortsetzung
-
Büchelmann, Melchior (*1581 JL †1637), Jesuit Studium
- Bühler, Johann (Bregenz) , Geistlicher Studium
- Bühler, Johann Joseph , Studium
- Bürlig, Nikolaus (*1391 JL †1429 JL), Pfarrer
- Büschler, Vitus (*1574 JL), Studium
C
-
Cabalzar, Franz Anton Dominik (*1673 †1736), Benediktiner Mönch Pfarrer Studium
- Cabalzar, Johann Georg (*1672 †1741), Pfarrer Studium
- Cabalzar, Johann Jakob von (1676) (*1676), Kanoniker Studium
- Cabalzar, Johann Jakob von (Feldkirch) , Kanoniker Studium
- Cabalzar, Thomas Franz Ignaz von (*1726), Geistlicher Priester Studium
- Caespes, Johann Friedrich , Studium
- Campanatoris, Johann (Beilstein) , Studium
- Cantaben, Konrad , Studium
- Capitel, Adam , Studium
- Capitel, Christian ( †1623), Kanoniker Pfarrer Studium
- Capitel, Christoph Ignaz ( †1719), Studium
- Capitel, Ernst Anton , Studium
C Fortsetzung
-
Capitel, Franz Michael , Studium
- Capitel, Franz Xaver , Studium
- Capitel, Hieronymus , Studium
- Capitel, Jakob Christoph (*1592 †1632), Jesuit Studium
- Capitel, Johann (Feldkirch) , Studium
- Capitel, Johann (Sulz) , Jesuitengymnasium Studium
- Capitel, Johann Andreas (*1590 †1637), Jesuit Studium
- Capitel, Johann Jakob , Studium
- Capitel, Michael (1636) (*1636), Arzt Mediziner Studium
- Capitel, Michael (Feldkirch) ( †1483 JL), Mönch Zisterzienser
- Capitel, Sebastian ( †1563 JL), Pfarrer Studium
- Carbonarius, Georg , Pfarrer Studium
- Carbonarius, Jodocus ( †1637), Geistlicher Pfarrer Studium
- Carnutsch, Johann (Feldkirch) , Geistlicher Studium
- Carpentarii, Heinrich (Feldkirch) , Studium
- Casanova, Jakob ( †1762), Schüler