Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Hessen]]
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='Hessen') 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
0
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='Hessen') 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
0
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 | 2773 | 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
NoneA
-
Abel, Christian , Studium
- Abendrot, Peter , Studium
- Achenbacher, Konrad , Jurist Studium
- Acker, Adam (*1649), Jesuit
- Aedituus, Johann (Hünfeld) , Studium
- Aemilius, Hektor , Kanzler Rat Studium
- Aff, Samuel , Studium
- Agricola, Balthasar (Fulda) , Studium
- Agricola, Peter Heinrich , Studium
- Agschelin, Friedrich , Studium
- Akartus, Justus , Jurist Studium
- Albert, Georg (Seligenstadt) , Studium
- Alberti, Philipp , Studium Vogt
- Albini, Franz Joseph Ritter von (*1748 †1816), Assessor Minister Studium
- Allendorf, Heinrich von , Studium
- Allgäuer, Leopold , Studium
- Alsfeld, Ewald von , Studium
A Fortsetzung
-
Alsfeld, Heinrich von (Alsfeld) , Studium
- Alsfeld, Heinrich von (Alsfeld, Studium) , Studium
- Alsfeld, Johann von , Studium
- Alsfeld, Konrad von , Studium
- Alsfeld, Philipp , Studium
- Alsheim, Johann von , Studium
- Alten, Matthäus , Studium
- Alzesberger, Wolfgang , Studium
- Amsteg, Jakob , Studium
- Amsteg, Nikolaus , Studium
- Anatan, Johann Nepomuk Reichsgraf von , Studium
- Andreae, Georg Leonhard (*1627 †1693), Pfarrer Studium
- Andreae, Johann (Kassel) , Studium
- Angelus, Johann (1542) (*1542 JL †1618), Pfarrer Studium Superintendent
- Angelus, Johann (Marburg) , Studium
- Antoni, Johann Baptist , Studium
- Antoni, Paul Theodor von (*1670 †1752), Assessor Professor Studium
A Fortsetzung
-
Antoni, Valentin , Studium
- Apotheker, Matthias , Studium
- Apotheker, Peter , Studium
- Appel, Friedrich Wilhelm (*1742), Studium
- Appel, Georg (Odenhausen) , Studium
- Appel, Johann Adam Konrad (*1739), Jesuit Studium
- Appel, Johann Nikolaus , Gymnasium
- Appel, Wigand , Studium
- Aquarius, Georg , Arzt Mediziner Studium
- Arcularius, Daniel (*1540 JL †1596), Professor Studium
- Arcularius, Kaspar , Lehrer Pfarrer Prediger Studium
- Arcularius, Philipp , Studium
- Arheiligen, Adam , Studium
- Arheiligen, Johann von , Studium
- Arheiligen, Lorenz Von , Studium
- Arnold, Albert , Studium