Semantische Suche
Debug output SQLStore
ASK Query
[[Herkunftsort::Eichstätt]]
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='Eichstätt') AND t1.p_id=503)
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='Eichstätt') AND t1.p_id=503)
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 | 1841 | 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
NoneF
-
Fürsich-Tempelhofen, Willibald (*1704), Studium
G
-
Gabler, Ferdinand , Studium Theologe
- Gabler, Johann (Eichstätt) , Jurist Studium
- Gabler, Johann (Eichstätt, Studium) , Studium
- Gabler, Michael (Eichstätt) , Studium
- Gabler, Paul Gabriel (*1594 †1632), Jesuit Studium
- Gabler, Sigismund Raphael , Studium
- Gabriel, Johann Nikolaus ( †1784), Geistlicher
- Gangloff, Joseph Anton , Studium
- Gantner, Willibald , Studium
- Gastel, Johann (Eichstätt) , Priester
- Gastel, Valentin (Eichstätt) , Studium
- Gaulrap, Franz , Studium
- Gebel, Georg (Eichstätt) , Studium
- Gebhard, Johann (1615) (*1615 †1688), Jesuit
- Geck, Johann Baptist Joseph ( †1785), Kanoniker Pfarrer Studium
- Geck, Johann Baptist Kaspar , Kanoniker Offizial Priester Studium
G Fortsetzung
-
Geck, Johann Michael , Studium
- Geck, Johann Sebastian (*1697), Studium
- Geger, Magnus , Studium
- Geiger, Johann (1603) (*1603), Jesuit
- Geilhofer, Peter Forer (*1765), Studium
- Geilhofer, Willibald , Studium
- Geisser, Georg (Eichstätt) , Studium
- Geisser, Johann (Eichstätt) , Studium
- Genger, Johann Jakob (Eichstätt) , Studium
- Geningen, Johann Michael , Studium
- Georg, Philipp , Studium
- Gerl, Johann Georg , Studium
- Gerner, Joseph Gabriel , Studium
- Gersdorfer, Leonhard , Studium
- Gerstner, Cölestin (*1735 †1802), Franziskaner Mönch
- Gerstner, Franz Joseph , Studium
- Gerstner, Joseph (1781) (*1781), Richter Studium
G Fortsetzung
-
Gerstner, Joseph Maria Lukas , Studium
- Gerstner, Prothasius (*1725 †1772), Franziskaner Mönch
- Gerstner, Venerandus (*1727 †1781), Franziskaner Mönch
- Gertner, Wolfgang (Eichstätt) , Studium
- Glatz, Leonhard , Studium
- Glatz, Michael (Eichstätt) , Studium
- Gloni, Georg Franz Xaver , Arzt Mediziner Studium
- Gloni, Willibald Jakob , Studium
- Glöckel, Leonhard (*1572 JL †1617), Jesuit
- Glückelsberger, Lorenz , Studium
- Gockel, Maria Barbara (*1745 †1779), Nonne
- Goldschalck, Walburga (*1465 JL †1525 JL), Nonne
- Goldschmid, Lorenz (Eichstätt)
- Gottsberger, Heinrich , Dominikaner Mönch
- Gottschalk, Barbara (*1435 JL), Birgittinerin Nonne Äbtissin
- Gottschalk, Johann (Eichstätt) , Studium