Semantische Suche
Debug output SQLStore
ASK Query
[[Wirkungsort::Neustift]]
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='Neustift') 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='Neustift') 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 | 537 | 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
NoneW
-
Weiz, Prosper (*1620 †1651), Augustinerchorherr Kanoniker
- Wenser, Joseph Anton Gabriel (*1691 †1735), Augustinerchorherr Kanoniker
- Wenser, Michael Gabriel (*1645 †1695), Augustinerchorherr Kanoniker
- Wenzel, Franz Xaver Michael Konstantin Balthasar (*1698 †1747), Augustinerchorherr Kanoniker Studium
- Werndle, Johann Georg (1697) (*1697 †1735), Augustinerchorherr Kanoniker Studium
- Werndle, Johann Georg (Hall/Tir.) ( †1735), Augustinerchorherr Kanoniker Studium
- Wesch, Franz (*1639 †1694), Augustinerchorherr Kanoniker
- Wettin, Franz (*1600 †1657), Kanoniker Pfarrer Studium
- Wiedemann, Franz Matthias (1657) (*1657 †1721), Abt Propst Prämonstratenser Studium
- Wiedemann, Sebastian (Kanoniker) ( †1644), Kanoniker
- Wiedemann, Sebastian (Prämonstratenser) ( †1644), Mönch Prämonstratenser
- Wiesbeck, Norbert (*1638 †1682), Mönch PrüEonstratenser
- Wieser von Wiesenfeld, Karl Stanislaus (*1719 †1763), Augustinerchorherr Kanoniker Studium
W Fortsetzung
-
Wieser, Anton Rochus (*1735 †1774), Augustinerchorherr Kanoniker Studium
- Wild, Felix (1615) (*1615 †1681), Augustinerchorherr Kanoniker
- Windsheim, Gregor de ( †1475 JL), Augustinerchorherr Kanoniker
- Winkelhofen, Franz Joachim von , Augustinerchorherr Kanoniker Studium
- Winkelhofen, Hieronymus von (*1638 †1713), Augustinerchorherr Kanoniker
- Winkler, Erasmus (Neustift) ( †1620), Augustinerchorherr Kanoniker
- Winkler, Peter (1637) (*1637 †1694), Augustinerchorherr Kanoniker
- Witting, Johann (1688) (*1688 †1716), Augustinerchorherr Kanoniker Studium
- Wohlmut, Peter Castulus (*1748 †1802), Abt Mönch Prämonstratenser Studium
- Wopfner, Joseph Anton Norbert (*1719 †1753), Augustinerchorherr Kanoniker Studium
- Wopfner, Karl Peter (*1758 †1819), Augustinerchorherr Studium
- Wurm, Adrian (*1744 †1767), Mönch Prämonstratenser
- Wurm, Johann Marinus ( †1651), Mönch Prämonstratenser
W Fortsetzung
-
Würzer, Georg ( †1619), Kanoniker
- Wüstner, Franz Ignaz Cassian (*1732 †1773), Augustinerchorherr Kanoniker Studium
Z
-
Zanna, Johann Leopold von (*1721 †1787), Abt Augustinerchorherr Kanoniker
- Zehrer, Joseph Gottfried (*1655 †1689), Mönch Prämonstratenser Studium
- Zeiler, Cletus Georg (*1692 †1751), Augustinerchorherr Kanoniker
- Zettel, Sebastian (1605) (*1605 †1605), Kanoniker
- Ziegler, Jeremias (PrüEonstratenser) ( †1615), Mönch PrüEonstratenser Studium
- Zill, Vitus ( †1672), Augustinerchorherr Kanoniker
- Zoller, Joseph Florian (*1702 †1763), Augustinerchorherr Kanoniker
- Zoller, Matthäus Zacharias (*1717 †1770), Augustinerchorherr Kanoniker
- Zwerger, Kaspar Florus (*1716 †1773), Guardian Kapuziner Mönch Studium