Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Rain]]
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='Rain') 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='Rain') 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 | 643 | 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
NoneS
-
Schlick, Joseph Anselm (*1738 †1772), Benediktiner Mönch Studium
- Schlosser, Johann (Rain) , Jesuitengymnasium
- Schluderer, Adam , Studium
- Schluderer, Ignaz (*1737), Studium
- Schluderer, Ulrich (*1734 †1812), Benediktiner Mönch Pfarrer Prior
- Schlupf, Johann Sebastian (*1719 †1784), Geistlicher Pfarrer Studium
- Schmid, Lazarus ( †1619), Kanoniker Studium
- Schmid, Paul (Rain) , Studium
- Schmid, Wolfgang (Rain) , Studium
- Schmidbauer, Jakob (1651) (*1651), Studium
- Schneider, Karl Ildephons (*1737 †1794), Benediktiner Mönch
- Schott, Dionysius Johann , Franziskaner Mönch
- Schotter, Stephan ( †1488 JL), Augustinerchorherr Kanoniker Studium
- Schwab, Sixt , Studium
- Schwarz, Jakob Faustinus (*1735 †1772), Kapuziner Mönch
- Schweble, Georg , Studium
- Schweble, Johann Georg (*1785 †1862), Pfarrer Priester
S Fortsetzung
-
Schweickhart, Anselm Leopold Rupert (*1727 †1789), Benediktiner Mönch Schüler Studium
- Schweickhart, Joseph Anton Nicostratus (*1724 †1775), Kapuziner Mönch Studium
- Schweiger, Andreas (Rain) , Studium
- Schweizer, Johann (Rain) , Studium
- Schwicker, Wolfgang , Studium
- Schönefelder, Andreas , Mönch Studium Zisterzienser
- Schönkind, Georg ( †1643), Jesuitengymnasium Pfarrer Studium
- Schönkind, Johann (1604) (*1604), Geistlicher Studium
- Schönkind, Johann (Rain) , Studium
- Schönkind, Kaspar ( †1664), Jesuitengymnasium Mönch Pfarrer Prämonstratenser Studium
- Schönkind, Martin (*1575 JL †1618), Benediktiner Mönch
- Schönkind, Melchior , Studium
- Schönkind, Sebastian , Studium
- Sedelmeier, Georg (1560) (*1560 JL †1591), Jesuit
- Segenschmid, Johann (Rain) , Studium
- Segenschmid, Johann (Rain, Studium) , Studium
- Seifert, Michael (1609) (*1609), Studium
S Fortsetzung
-
Seifried, Philipp Eustach , Studium
- Seig, Johann Anton , Schüler
- Seitz, Johann (Rain) , Geistlicher Schüler
- Seitz, Martin Hospitius (*1726), Guardian Kapuziner Mönch Studium
- Selzel, Johann ( †1666), Geistlicher Studium
- Sickenhausen und Hörzhausen, Georg Joseph Dominik von (*1666 †1755), Pfleger Studium
- Sonderle, Johann , Studium
- Spar, Johann (Rain) , Studium
- Stach, Joseph Wilhelm , Schüler Studium
- Staff, Sixt , Studium
- Stammhammer, Lorenz , Studium
- Stang, Anton Franz Matthias (*1705 †1777), Studium
- Stang, Johann Konrad Landolph (*1715 †1772), Kapuziner Mönch Studium
- Stegmar, GEorg , Studium
- Stegmeier, Balthasar (Rain) , Geistlicher Pfarrer Studium
- Steifel, Johann , Studium