Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Thüringen]]
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='Thüringen') 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='Thüringen') 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 | 1331 | 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
-
Ackermann, Fabian , Studium
- Adam, Salomon , Studium
- Adami, Bernhard Christoph (*1686 †1760), Augustinereremit
- Agricola, Heinrich Siegfried , Studium
- Agricola, Ignaz (*1724 †1761), Jesuit
- Agricola, Johann Theodor Dietrich , Studium
- Agricola, Johann Wilhelm , Arzt Jurist Mediziner Rat Studium
- Agricola, Joseph (1729) (*1729), Jesuit
- Agricola, Nikolaus (1525) (*1525 JL †1561 JL), Lehrer Schulmeister Studium
- Agricola, Wilhelm , Studium
- Albinus, Andreas , Lehrer Studium
- Albus, Johann , Studium
- Alemann, Leonhard , Studium
- Algesheim, Johann , Studium
- Altenburg, Albert von , Studium
- Altenburg, Heinrich von , Studium
- Altenburg, Nikolaus von , Studium
A Fortsetzung
-
Altenburg, Theodor von , Studium
- Altenhofen, Georg , Studium
- Amon, Georg (Erfurt) , Studium
- Andreae, Peter (Mühlhausen) , Studium
- Anger, Jakob (Ohrdruf) , Studium
- Appel, Andreas (Eisfeld) , Studium
- Appel, Bartholomäus (1747) (*1747), Jesuit
- Appel, Johann (Ohrdruf) , Studium
- Aquarius, Georg , Arzt Mediziner Studium
- Aquila, David , Studium
- Arand, Karl Melchior , Geistlicher Studium
- Arand, Nikolaus (*1586 †1664), Jesuit
- Arents, Gottfried , Studium
- Arnoldi, Cyriakus , Studium
- Asmus, Lambert (*1698 †1747), Jesuit
- Augustin, Anton (Erfurt) , Studium
- Aulicus, Heinrich , Studium
A Fortsetzung
-
Aurochs in Oepfenhausen, Dietrich Justus , Gymnasium illustre Studium
B
-
Bach, Johann (1602) (*1602), Studium
- Bachmann, Johann Georg (Arnstadt) , Setzer
- Backhaus, Konrad (Waltershausen) , Studium
- Baier, Johann Jakob (1677) (*1677 †1735), Arzt Mediziner Professor Studium
- Baier, Nikolaus (1402) (*1402 JL †1539 JL), Generalvikar Kanoniker Studium
- Baldmann, Nikolaus , Studium
- Balus, Melchior , Studium
- Bank, Christoph (1645) (*1645 †1713), Augustinereremit
- Bartelstein, Peter , Geistlicher Studium
- Bartholomäus, Georg (1476) (*1476 JL), Kanoniker
- Bauer, Kaspar Philipp , Studium
- Bauerschubert, Balthasar , Studium
- Baumann, Bernhard (Walbach) , Studium
- Baumgartner, Christoph (Altenburg) , Studium
- Baumgartner, Hieronymus (Altenburg) , Studium