Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Heilbronn]]
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='Heilbronn') 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='Heilbronn') 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 | 628 | 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
-
Spitzer, Johann Georg (*1595 †1682), Bürgermeister Jurist Studium
- Spitzer, Kaspar (1569) (*1569 JL †1655), Notar Studium Verwalter
- Spitzer, Kaspar (Heilbronn) , Studium
- Spongler, Kaspar , Studium
- Spülin, Burkhard , Studium
- Spülin, Jodocus , Studium
- Stahel, Joachim ( †1556 JL), Pfarrer Studium
- Steiner, Johann Ludwig (*1609 †1626), Studium
- Steinmetz, Johann (Heilbronn) ( †1544 JL), Pfarrer Studium
- Steinmetz, Wolfgang (Heilbronn) , Studium
- Stier, Sigismund (Heilbronn) ( †1494 JL)
- Stier, Sigismund (Heilbronn, Studium) , Jurist Studium
- Stor, Johann Christian (*1712 †1773), Pfarrer Studium
- Straub, Raimund (*1564 JL), Keller Pfarrer Studium
- Strubinus, Johann (Heilbronn) ( †1603), Pfarrer Studium
- Strubinus, Kaspar , Studium
- Stuit, Johann , Studium
S Fortsetzung
-
Stumpf, Johann Balthasar (1648) (*1648 †1683), Pfarrer Studium
- Stuttmann, Johann Burkhard , Studium
- Suser, Peter von , Studium
- Söhner, Friedrich , Studium
T
-
Taler, Johann Melchior , Studium
- Taler, Melchior , Studium
- Tanner, Johann Friedrich (*1666 †1697), Jurist Musiker
- Teufel, Johann Georg (Heilbronn) , Studium
- Textor, Johann (Heilbronn) , Studium
- Theodoricus, Johann Christoph , Studium
- Tiefenbach, Theodor , Studium
- Tiegel, Wendelin , Studium
- Tinctoris, Johann (Heilbronn) , Studium
- Trabolt, Lukas , Geistlicher Studium
- Trapp von Trappensee, Johann Ludwig (*1646 †1674), Jurist Richter Studium
- Trapp, Ludwig (Heilbronn) , Studium
- Treibler, Johann (Heilbronn) , Studium
T Fortsetzung
-
Treisping, Ferdinand , Studium
- Trippel, Kaspar , Studium
- Troll, Melchior (Heilbronn) , Studium
- Trutzenbach, Johann , Studium
U
-
Uckelin, Philipp (*1609 †1679), Pfarrer Studium
- Unverworen, Andreas , Studium
V
-
Varnbühler, Heinrich Ludwig Theodor Dietrich (*1762), Pfarrer Studium
- Vogel, Wendelin (1581) (*1581 JL), Pfarrer Studium
- Vogel, Wendelin (Heilbronn) , Studium
- Vogler, Konrad (Heilbronn) , Studium
- Vogler, Melchior (Heilbronn) , Studium
- Vogler, Raimund (*1544 JL), Jurist Studium
- Volk, Johann (Heilbronn) ( †1623), Studium
- Volland, Ludwig (Heilbronn) , Studium
- Vollock, Jakob Philipp , Pfarrer Studium
- Volz, Johann (Heilbronn) , Studium