Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Frankreich]]
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='Frankreich') 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
1000
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='Frankreich') 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
1000
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 | 19100 | 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
-
Breitler, Johann Jakob , Studium
- Brell, Julian , Studium
- Brell, Michael (Wissembourg) ( †1580 JL), Jesuit
- Brell, Rüdiger , Studium
- Bremer, Martin (Masevaux) , Studium
- Brenden, Erhard , Studium
- Brenneisen, Matthäus , Studium
- Brenneisen, Sebastian , Studium
- Brenner, Johann (Elsass) , Studium
- Brenni, Ludwig Dominik (*1705 †1791), Geistlicher Jesuit Pfarrer
- Brenninger, Stephan , Geistlicher
- Brentano, Dominik (*1707 †1758), Jesuit
- Brenz, Anselm , Studium
- Brenz, Georg (Wissembourg) , Studium
- Brenz, Jakob (Masevaux) , Studium
- Brenz, Johann (Cronenbourg) , Studium
- Brenzing, Morand , Studium
B Fortsetzung
-
Brenzinger, Erhard , Assessor Studium
- Brettenacker, Balthasar , Studium
- Bretter, Berthold , Studium
- Breuer, Ludwig Friedrich (*1674 †1746), Arzt Mediziner Studium
- Breuer, Philipp Bernhard , Studium
- Breuer, Philipp Jakob (*1686 †1745), Pfarrer Studium
- Breuning, Franz , Studium
- Breuning, Valentin , Studium
- Breuninger, Stephan , Studium
- Brexius, Gregor , Studium
- Brick, Johann Georg , Studium
- Brickler, Adam , Studium
- Brickler, Johann Roman , Studium
- Bridier, Nikolaus , Studium
- Brief, Philipp Heinrich , Studium
- Briel, Johann Christoph , Studium
- Brindeus, Ambrosius , Studium
B Fortsetzung
-
Brindeus, Peter , Mediziner Professor
- Brininghofen, Peter Jakob von , Benediktiner Mönch Studium
- Brinon, René von , Studium
- Briot, Dominik (*1573 JL †1642), Jesuit
- Briot, Franz , Studium
- Briquet, Sebastian , Studium
- Brisechous, Guyon , Studium
- Brisechous, Samuel , Studium
- Brisonius, Johann , Studium
- Brix, Hieronymus , Studium
- Brobeque, Joseph Georg , Studium
- Brocher, Johann , Studium
- Brocker, Heinrich , Studium
- Brocker, Jakob , Studium
- Brocker, Johann , Studium
- Brodel, Sigismund , Studium