Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsregion::Oberbayern]]
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='Oberbayern') 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='Oberbayern') 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 | 92418 | 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
-
Ampfinger, Christoph , Kastner
- Ampfinger, Ulrich , Studium
- Ampherle, Franz (*1576 JL †1646), Franziskaner Mönch
- Amringer, Konrad , Studium
- Amtmann, Johann (*1672 †1740), Augustinerchorherr Studium
- Ananias von Neuburg, Ananias ( †1681), Kapuziner Mönch
- Anbeck, Erhard , Studium
- Anbeck, Willibald (Eichstätt) , Studium
- Anbeck, Willibald (Eichstätt, Studium) , Studium
- Anbeck, Wolfgang , Studium
- Anceaux, Johann Anton (*1676), Studium
- Andechs, Arbo Aribo Graf von ( †1031 JL), Erzbischof Kanoniker
- Andechser, Johann , Studium
- Andelshauser, Anton (*1772), Studium
- Andelshauser, Georg , Studium
- Andensteiner, Johann Balthasar , Jurist Pfarrer Studium
- Andere, Michael , Studium
A Fortsetzung
-
Anderl, Jakob (*1720), Studium
- Anderl, Johann (*1684), Priester Studium
- Anders, Johann Nepomuk (*1768), Studium
- Anders, Matthias (*1768), Studium
- Andershofer, Jakob , Studium
- Andlichstatter, Sebastian , Studium
- Andlinger, Franz Xaver (*1745), Buchhalter Rat Studium
- Andlinger, Joseph Ignaz (*1749), Studium
- Andlinger, Martin Nikolaus (*1744), Studium
- Andlinger, Michael (*1754), Priester Studium
- Andorfer, Andreas , Studium
- Andorfer, Georg (München) , Studium
- Andorfer, Johann Georg , Studium
- Andorfer, Peter Michael Silvester (*1696 †1733), Kapuziner Mönch
- Andorfer, Sebastian (*1612 †1646), Benediktiner Mönch
- Andorfer, Wilhelm , Studium
- Andracius, Johann , Studium
A Fortsetzung
-
Andre, Clemens Michael (*1680), Pfarrer Priester Studium
- Andre, Erhard Eckhard , Studium
- Andre, Franz Ignaz (*1689), Priester Studium
- Andre, Gabriel , Studium
- Andre, Georg , Priester Studium
- Andre, Martin (*1672 †1729), Pfarrer Studium
- Andre, Maximilian (*1745), Studium
- Andre, Michael , Studium
- Andre, Sebastian Daniel (*1683), Pfarrer Studium
- Andre, Wolfgang (1664) (*1664), Priester Studium
- Andre, Wolfgang (Berg) , Studium
- Andreae, Eberhard (München) , Studium
- Andreae, Johann (Eching) , Domvikar Geistlicher Pfarrer Studium
- Andreae, Johann (Schongau) , Domvikar Pfarrer
- Andreae, Kaspar (1490) (*1490 JL), Geistlicher Studium
- Andreae, Otto , Studium