Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Mittelfranken]]
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='Mittelfranken') 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='Mittelfranken') 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 | 27688 | 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
-
Abele , Pfarrer
- Abele, Georg Hieronymus , Studium
- Abele, Georg Michael , Studium
- Abele, Heinrich (*1617), Studium
- Abele, Johann (Dinkelsbühl) , Studium
- Abele, Johann (Dinkelsbühl, Geistlicher) , Geistlicher
- Abele, Johann Bernhard (Dinkelsbühl) , Stadtschreiber Studium
- Abele, Johann Dominik
- Abele, Johann Georg Bernhard (*1606), Studium
- Abele, Johann Kilian (*1768), Studium
- Abele, Rudolph (*1618), Studium
- Abenberg, Konrad von , Studium
- Absberg, Alexander von , Studium
- Absberg, Georg von (Absberg) , Kanoniker
- Absberg, Georg von (Absberg, Studium) , Studium
- Absberg, Heinrich von (Absberg) , Pfleger
- Absberg, Heinrich von (Absberg, Richter) , Pfleger Richter
A Fortsetzung
-
Absberg, Johann (*1476 JL †1482 JL), Studium
- Absberg, Johann Konrad von , Studium
- Absberg, Johann von , Pfleger
- Absberg, Karl von ( †1521 JL), Kanoniker Studium
- Absberg, Leonhard von , Studium
- Absberg, Ludwig von , Pfleger
- Absberger, Albert , Studium
- Absberger, Georg , Studium
- Absberger, Heinrich (1409) (*1409 JL †1492 JL), Bischof Kanoniker Studium
- Abt, Stephan , Studium
- Ach, Jakob , Studium
- Achert, Johann (Schwabach) , Studium
- Ackerle, Johann , Studium
- Ackermann, Johann Moritz , Studium
- Adam, Andreas (Hilpoltstein) ( †1527 JL), Benediktiner Mönch
- Adam, Anton von , Studium
- Adam, Franz Anton Konrad (*1752 †1828), Kanoniker Schüler Studium
A Fortsetzung
-
Adam, Franz Xaver Eucharius (*1748 †1830), Kanoniker Schüler Studium
- Adam, Georg , Studium
- Adam, Georg Ludwig (Herrieden) ( †1660), Kanoniker Pfarrer Studium
- Adam, Georg Ludwig (Spalt) ( †1602), Kanoniker Studium
- Adam, Georg Ludwig (Spalt, Studium) , Studium
- Adam, Georg Paul (*1746), Schüler
- Adam, Heinrich (1695) (*1695 †1764), Jesuit
- Adam, Johann (Schwabach) , Studium
- Adam, Johann (Weissenburg) , Studium
- Adam, Johann Anton (Stirn) , Studium
- Adam, Johann Baptist (*1775), Studium
- Adam, Johann Jakob (Herrieden) , Studium
- Adam, Johann Reinhard , Studium
- Adam, Joseph Alois (*1762), Kanzler Studium
- Adam, Lorenz , Schüler Studium
- Adami, Christian (Rothenburg) , Studium