Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Brixen]]
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') AND t1.p_id=503)
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') AND t1.p_id=503)
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 | 1502 | 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
NoneG
-
Gruber, Michael (Brixen) , Studium
- Grünbacher, Jakob (*1728), Geistlicher Studium
- Grüneisen, Sigismund (*1609), Priester
- Grünenzweig, Balthasar (*1560 JL), Studium
- Grüner, Leonhard (Brixen) , Studium
- Grünzweig, Kaspar , Studium
- Gsinn, Matthäus , Studium
- Gsinn, Thomas (*1681 †1756), Geistlicher Priester Studium
- Guckler, Andreas Augustin (*1607 †1680), Benediktiner Mönch
- Gugler, Andreas Augustin (*1607 †1680), Benediktiner Mönch
- Gugler, Ignaz Anton (*1657 †1705), Augustinerchorherr Kanoniker Studium
- Gugler, Johann Paul Hieronymus (*1613 †1650), Benediktiner Mönch
- Gugler, Johann Paulin , Studium
- Gulden, Johann (Brixen) ( †1512 JL), Augustinerchorherr Kanoniker Studium
- Gussmeier, Michael Angelus , Studium
- Gutmann, Johann (Brixen) , Studium
H
-
Habersberg, Johann Balthasar von , Studium
H Fortsetzung
-
Hahn, Georg (Brixen) , Studium
- Hahn, Zacharias (*1782 †1826), Benediktiner Mönch
- Halbsleben, Christoph , Studium
- Halbsleben, Octavian , Priester Studium
- Haller, Franz (Brixen) , Studium
- Haller, Johann Baptist (Brixen) , Studium
- Halt, Karl (*1609), Priester
- Hammer, Maternus (*1549 JL), Studium
- Hansler, Joseph Anton , Studium
- Hansler, Joseph von , Studium
- Hartel, Octavian ( †1590), Geistlicher Pfarrer
- Hartmann, Johann (Brixen) , Pfarrer Studium
- Hartmann, Octavian , Priester Studium
- Hauer, Bartholomäus , Studium
- Haupt, Gabriel Franz von Paula (*1759 †1810), Kapuziner Mönch
- Haupt, Jakob , Studium
- Hauser von Weissenstein, Markus (*1587 †1665), Augustinerchorherr Kanoniker Studium
H Fortsetzung
-
Hauser, Gregor (*1615), Priester
- Hauser, Peter (Brixen) , Studium
- Hausmann, Heinrich , Studium
- Hausmann, Sigismund , Studium
- Hehne, Nikolaus , Studium
- Heid, Andreas (Brixen) , Studium
- Heid, Franz Bonaventura (*1624 †1696), Kapuziner Mönch
- Heid, Johann Clemens (*1624 †1680), Kapuziner Mönch
- Heid, Thomas (Brixen) , Studium
- Heid, Tobias (*1611), Priester Studium
- Heidner, Matthäus , Geistlicher Studium
- Heinzig, Johann von Gott (*1759 †1796), Geistlicher Studium
- Helderich, Georg (Brixen) , Studium
- Hellang, Georg , Studium
- Hendel von Goldrain, Franz Joseph Johann Ignaz Ferdinand Graf von , Studium
- Henfel, Michael , Studium