Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Nordrhein-Westfalen]]
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='Nordrhein-Westfalen') 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='Nordrhein-Westfalen') 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 | 2350 | 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
NoneE
-
Erste, Heinrich , Studium
- Ertel, Johann (Münster) , Pfarrer Priester Studium
- Erung, Gerhard , Studium
- Erwitte, Georg , Studium
- Esch, Rudolph , Studium
- Esch, Wilhelm (1572) (*1572 JL †1630), Jesuit
- Eschenbruck, Arnold (*1650), Studium
- Eser, Hermann (*1678), Jesuit
- Eser, Leonhard , Studium
- Eser, Peter , Studium
- Etter, Martin , Studium
- Euskirchen, Christian von , Studium
- Everding, Theodor , Studium
- Ewig, Engelbert (*1599 †1637), Jesuit
F
-
Faber, Gregor (Köln) , Jurist Studium
- Faber, Hermann (1542) (*1542 JL), Jesuit
- Faber, Hubert , Mediziner
F Fortsetzung
-
Faber, Johann (Münster) , Augustinereremit Mönch Priester
- Fabri, Franz Michael , Studium
- Fabri, Johann (Ratingen) , Studium
- Fabricius, Franz (Düsseldorf) , Studium
- Fabricius, Heinrich (Westfalen) , Studium
- Fabricius, Johann (Driburg) , Studium
- Fabricius, Johann (Jülich) , Studium
- Fabricius, Johann (Westfalen) , Studium
- Fabricius, Konrad (1595) (*1595 †1638), Jesuit
- Fabricius, Liborius , Studium
- Fabricius, Pankraz Cornelius , Studium
- Fabricius, Peter (Liedberg) , Studium
- Fabricius, Simon (Düsseldorf) , Studium
- Fabricius, Walter , Studium
- Falk, Johann (Köln) , Studium
- Falk, Johann Evangelist ( †1760), Augustinerchorherr Kanoniker Propst Studium
- Falk, Theodor (*1733 †1755), Jesuit
F Fortsetzung
-
Falkenberg, Heinrich , Assessor Priester Studium
- Falkenberg, Jodocus Christoph von , Kanoniker Studium
- Fannemann, Balthasar (*1500 JL †1561 JL), Professor Vizekanzler
- Farrenhagen, Anton , Studium
- Farwick, Georg Heinrich , Studium
- Faurnau, Johann Anton , Studium
- Faust, Johann (Herford) , Studium
- Faustmann, Jodocus , Studium
- Faustmann, Peter , Studium
- Fecker, Peter , Studium
- Federend, Johann , Studium
- Fehling, Johann , Pfarrer
- Fehring, Georg , Studium
- Fehring, Johann , Studium
- Feinguisius, Georg , Studium
- Feinsamer, Theodor , Studium