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
520
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
520
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
-
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
- Capitel, Franz Michael , Studium
- Capitel, Franz Xaver , Studium
- Capitel, Hieronymus , Studium
C Fortsetzung
-
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
- Castelmur, Pius ( †1729), Kapuziner Mönch
- Castronovo, Jakob ( †1273 JL), Archidiakon Kanoniker Pfarrer
- Castus von Feldkirch, Castus , Guardian Kapuziner Mönch
- Catan, Alexander ( †1658), Benediktiner Mönch
C Fortsetzung
-
Catan, Ambrosius (*1678 †1750), Geistlicher Studium
- Catan, Bonifatius (*1634 †1707), Benediktiner Geistlicher Mönch
- Catan, Franz (1646) (*1646 †1730), Geistlicher Pfarrer Studium
- Catan, Franz (Feldkirch) , Geistlicher Studium
- Catan, Johann Chrysostomus , Studium
- Catan, Johann Ignaz ( †1733), Pfarrer Studium
- Catan, Johann Joseph Gerold ( †1736), Franziskaner Mönch Studium
- Catan, Kaspar ( †1521 JL), Geistlicher
- Catan, Lambert (*1648 †1719), Benediktiner Geistlicher Mönch Pfarrer Prior Studium
- Catan, Zacharias ( †1650), Pfarrer Studium
- Cherubin von Schruns, Cherubin ( †1714), Kapuziner Mönch
- Christa, Georg (Feldkirch) ( †1669), Pfarrer Studium
- Christa, Johann Franz ( †1700), Kanoniker Pfarrer Priester
- Christan, Leonhard (*1594 †1643), Jesuit
- Christian, Georg , Studium
- Christmeier, Johann Martin , Studium