Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Kitzingen]]
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='Kitzingen') 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='Kitzingen') 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 | 632 | 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
-
Scholaris, Nikolaus , Studium
- Schreiner, Johann (Kitzingen) , Studium
- Schrepfer, Konrad , Studium
- Schröder, Hieronymus , Studium
- Schupp, Nikolaus (Kitzingen) , Studium
- Schutzmeister, Martin , Studium
- Schwab, Johann (Kitzingen) , Studium
- Schwan, Georg Vitus , Pfarrer Studium
- Schätzle, Sebastian , Studium
- Schätzler, Sebastian , Studium
- Scipio, Georg , Studium
- Scipio, Johann Isaak , Studium
- Segnitz, Erasmus , Studium
- Segnitz, Georg Ludwig (*1605 †1672), Reichsvogt Studium
- Segnitz, Johann (Kitzingen) , Studium
- Segnitz, Johann (Kitzingen, Studium) , Jurist Studium
- Segnitz, Lorenz , Studium
S Fortsetzung
-
Segnitz, Theodor , Studium
- Seibot, Christoph , Studium
- Seifried, Friedrich (Kitzingen) , Studium
- Seifried, Georg (Kitzingen) , Studium
- Seifried, Johann (Kitzingen) , Studium
- Seifried, Johann (Kitzingen, Studium) , Studium
- Sell, Johann Georg , Studium
- Siebold, Johann Franz , Studium
- Simonis, Michael (Kitzingen) , Studium
- Sohm, Johann (Kitzingen) , Jurist Studium
- Sonach, Johann Konrad , Studium
- Speiser, Johann Joseph Lorenz , Studium
- Speng, Konrad , Studium
- Spielberger, Christoph , Studium
- Spielberger, Karl Philipp Theophil Gottlieb , Studium
- Sponsus, Pankraz , Studium
- Stang, Johann Georg (Kitzingen) , Studium
S Fortsetzung
-
Starr, Heinrich , Studium
- Starz, Johann (Kitzingen) , Studium
- Stehr, Nikolaus (Kitzingen) , Studium
- Steinbach, Anton Bartholomäus , Studium
- Steinhaus, Kohann , Studium
- Steinmetz, Johann Peter , Studium
- Stengel, Georg (Kitzingen) , Studium
- Stengel, Kaspar , Studium
- Stengel, Leonhard , Studium
- Stosser, Johann Gerson , Studium
- Stuchs, Thomas , Studium
- Stummer, Johann (Kitzingen) , Studium
- Stunzel, Johann (Kitzingen) , Studium
- Stunzel, Johann (Kitzingen, Studium) , Studium
- Sturm, Georg (Kitzingen) ( †1586), Studium
- Stössel, Johann (1524) (*1524 JL †1576 JL), Professor Studium Superintendent Theologe