Semantische Suche
Debug output SQLStore
ASK Query
[[Wirkungsort::Wittenberg]]
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='Wittenberg') 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='Wittenberg') 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 | 18422 | 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
-
Bernbeck, Albert , Studium
- Bernbeck, Bernhard , Studium
- Bernbeck, Florian Florin , Studium
- Bernbeck, Jodocus , Studium
- Bernbeck, Philipp (Nürnberg) , Stadtschreiber Studium
- Berndorf, Wolfgang (Nürnberg) , Studium
- Berndorfer, Georg (Neumarkt) , Studium
- Bernhard, Christoph (Augsburg) , Studium
- Bernhard, Daniel , Studium
- Bernhard, Johann (Forchheim) , Studium
- Bernhard, Johann (Grünsfeld) , Studium
- Bernhardi, Johann (Römhild) , Studium
- Bernhold, Balthasar , Studium
- Bernhold, Johann , Studium
- Bernhold, Johann Balthasar (1687) (*1687 †1768), Pfarrer Professor Studium Theologe
- Bernhold, Johann Balthasar (Sulz) , Studium
- Bernreiter, Balthasar , Lehrer Schulmeister Studium
B Fortsetzung
-
Bernstein, Burkhard , Studium
- Bernwald, Peter , Studium
- Berold, Nikolaus , Studium
- Berstin, Severus , Studium
- Bertele, Sebastian (Neuburg/Do.) , Gymnasium illustre Studium
- Berthold, Andreas Heinrich , Studium
- Berthold, Johann (Neumarkt) ( †1582 JL), Geistlicher Pfarrer Studium
- Bertsch, Georg Friedrich (*1625 †1692), Pfarrer Studium
- Berz, Christoph , Studium
- Berz, Georg Friedrich , Studium
- Berz, Johann , Studium
- Berz, Johann Ludwig , Studium
- Beschel, Fabian , Studium
- Beschel, Georg (Pegnitz) , Studium
- Beschel, Georg (Pegnitz, Studium) , Studium
- Beschel, Johann (Ried im Innkreis) , Geistlicher Studium
- Beschenstein, Johann (1472) (*1472 JL †1540 JL), Hebräischlehrer
B Fortsetzung
-
Besler, Georg (1490) (*1490 JL †1536 JL), Jurist Kanoniker Propst Studium
- Besler, Kaspar , Geistlicher Studium
- Besler, Michael (Nürnberg) , Pfarrer Studium
- Besler, Polykarp , Studium
- Besold von Steckhofen, Ulrich ( †1573 JL), Jurist Richter Studium
- Besold, Georg (Wunsiedel) , Studium
- Besold, Hieronymus , Studium
- Besold, Kaspar Matthias , Studium
- Besold, Stephan , Lehrer Schulmeister Studium
- Bessel, Gregor , Studium
- Besser, Michael ( †1558 JL), Pfarrer Studium
- Besserer, Christoph (Kitzingen) , Studium
- Besserer, Georg (1544) (*1544 JL †1604), Pfarrer Prediger Studium
- Besserer, Hammon Ammon , Jurist Studium
- Betuleius, Matthäus , Studium
- Betulius, Johann Ludwig (*1591 †1647), Pfarrer Studium