Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Mittelfranken]]
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='Mittelfranken') AND t1.p_id=963)
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='Mittelfranken') AND t1.p_id=963)
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 | 27688 | 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
NoneB
-
Bauernfeind, Leonhard (Wendelstein) , Studium
- Bauernfeind, Werner , Studium
- Bauernfeind, Ägidius , Pfarrer Studium
- Bauerschuster, Johann , Studium
- Baugartner, Joseph Karl Jakob , Studium
- Baum, Johann (Ansbach) , Studium
- Baum, Johann Heinrich ( †1738), Studium
- Baumann, Adam Georg , Studium
- Baumann, Anton Philipp , Studium
- Baumann, Bernhard Christoph , Studium
- Baumann, Georg (Rottenburg) , Studium
- Baumann, Gottfried Christoph (*1720), Rat Studium
- Baumann, Heinrich (Lauf) , Studium
- Baumann, Johann (Höchstadt) , Studium
- Baumann, Johann (Nürnberg) , Studium
- Baumann, Johann (Nürnberg, Studium) , Studium
- Baumann, Johann Gumpert (*1685 †1756), Pfarrer Studium
B Fortsetzung
-
Baumann, Kaspar (Dinkelsbühl) , Studium
- Baumann, Kaspar (Oettingen) , Pfarrer Studium
- Baumann, Lorenz (Rothenburg) , Studium
- Baumann, Peter (Arberg) , Studium
- Baumann, Peter (Windsheim) , Studium
- Baumann, Sebald , Studium
- Baumann, Stephan (Gonnersdorf) , Studium
- Baumeister, Johann (Weissenburg) , Studium
- Baumeister, Joseph Anton (1778) (*1778), Franziskaner
- Baumeister, Martin (Gunzenhausen) , Studium
- Baumgartner, Anton (Nürnberg) , Studium
- Baumgartner, Balthasar (1551) (*1551 JL †1600), Patrizier
- Baumgartner, Bernhard (Nürnberg) , Studium
- Baumgartner, Bernhard (Nürnberg, Studium) , Studium
- Baumgartner, Christian , Studium
- Baumgartner, Christoph (Nürnberg) , Studium
- Baumgartner, Christoph Konrad (*1674 †1759), Rat Studium
B Fortsetzung
-
Baumgartner, Ernst , Studium
- Baumgartner, Gabriel (1449) (*1449 JL †1457 JL), Professor Rat Ratskonsulent Studium
- Baumgartner, Gabriel (Nürnberg) ( †1638), Studium
- Baumgartner, Georg (Nürnberg) ( †1629), Studium
- Baumgartner, Georg Friedrich , Studium
- Baumgartner, Georg Karl , Schüler
- Baumgartner, Helwig , Studium
- Baumgartner, Hieronymus (1539) (*1539 JL †1601), Bürgermeister Ratsherr Studium
- Baumgartner, Hieronymus (Nürnberg) , Studium
- Baumgartner, Hieronymus (Nürnberg, Studium) ( †1601), Bürgermeister Ratsherr Studium
- Baumgartner, Johann (Nürnberg) , Studium
- Baumgartner, Johann (Uffenheim) , Studium
- Baumgartner, Johann (Windsbach) , Studium
- Baumgartner, Johann Christian , Studium
- Baumgartner, Johann Christoph (Dinkelsbühl) , Studium
- Baumgartner, Johann Matthäus (Herrieden) , Geistlicher Studium