Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Oberösterreich]]
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='Oberösterreich') 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='Oberösterreich') 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 | 2989 | 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
NoneH
-
Hanaman, Johann Paul Seraphin (*1669 †1742), Kapuziner Mönch
- Handlen, Leonhard , Studium
- Hanselmann, Sigismund , Studium
- Hapfenzeder, Johann , Studium
- Harder, Franz Eligius Clemens (*1693 †1731), Kapuziner Mönch
- Harder, Friedrich , Studium
- Harder, Johann (Braunau) , Studium
- Harder, Wolfgang (Ranshofen) , Studium
- Harlander, Bernhardin (*1801 †1869), Guardian Kapuziner Mönch
- Harras, Joseph Karl , Studium
- Harren, Erhard , Studium
- Harrer, Christian Pacificus (*1632 †1713), Guardian Kapuziner Mönch Studium
- Harrer, Georg (1598) (*1598), Studium
- Harrer, Matthias , Gerichtsschreiber Registrator Studium
- Harrer, Wolfgang , Studium
- Hart, Johann (Wels) , Studium
- Hartel, Wilhelm , Studium
H Fortsetzung
-
Hartkircher, Sebastian , Studium
- Hartleitner, Wolfgang , Gymnasium
- Hartmann, Sebastian (Studium) , Studium
- Harucker, Franz Joseph von , Jurist Studium
- Haselmeier, Johann , Studium
- Hasenkropf, Johann , Studium
- Hasenloff, Theodor Dietrich ( †1679), Jurist Rat Studium
- Haslauer, Johann Joseph Adam (*1733), Studium
- Haslinger, Christoph , Studium
- Haslinger, Franz Xaver Evarist (*1721), Guardian Kapuziner Mönch
- Haslinger, Markus , Studium
- Hatz, Anton , Studium
- Hatz, Martin , Studium
- Haubenbeck, Jakob , Studium
- Hauch, Christoph Numerian (*1735 †1768), Kapuziner Mönch
- Haunreiter, Erasmus , Studium
- Hauser, Leonhard (Braunau) , Studium
H Fortsetzung
-
Hauser, Wolfgang (Kremsmünster) , Studium
- Hausgenoss, Leonhard , Studium
- Hausheim, Johann , Studium
- Hauslod, Leonhard , Studium
- Hausner, Stephan , Studium
- Hauzenberger, Johann (Schärding) , Studium
- Hauzenberger, Michael , Studium
- Hebensberger, Johann , Studium
- Hebenstreit, Franz Joseph von , Studium
- Hebenstreit, Matthias (Braunau) , Studium
- Hebenstreit, Matthias (Braunau, Studium) , Studium
- Hebenstreit, Sigismund , Studium
- Hebenstreit, Simon , Studium
- Hebenstreit, Stephan (Braunau) , Studium
- Heberle, Thomas (Braunau) , Studium
- Hechinger, Johann (Ried im Innkreis) ( †1622), Pfarrer Studium