Semantische Suche
Debug output SQLStore
ASK Query
[[Person::~A*]]
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 LIKE 'A%') AND t1.p_id=528)
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 LIKE 'A%') AND t1.p_id=528)
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 | range | s_id, o_hash, s_id_2, p_id | p_id | 262 | 21620 | 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
-
Ade, Johann (Guebwiller) , Studium
- Ade, Johann (Nürnberg) , Studium
- Ade, Joseph Karl Maximilian , Studium
- Ade, Michael , Studium
- Ade, Nikolaus , Studium
- Ade, Philipp (*1772), Geistlicher Kanoniker Pfarrer Priester Studium
- Adech, Johann , Kanonist Studium
- Adegoll, Franz Dominik , Studium
- Adegoll, Franz Xaver Nikolaus (*1752 †1837), Geistlicher Studium
- Adegoll, Joseph Thaddäus Alois (*1724 †1764), Geistlicher Pfarrer Studium
- Adegoll, Thaddäus Jakob (*1721 †1728), Benediktiner Mönch Pfarrer Studium
- Adegoll, Thomas Johann Joseph Ignaz (*1742), Studium
- Adel, Jakob , Studium
- Adel, Michael (Bamberg) , Studium
- Adel, Michael (Basel) , Studium
- Adelbart, Georg , Pfleger
- Adelbeer, Johann , Pfarrer
A Fortsetzung
-
Adelberg, Johann , Studium
- Adelberger, Joseph Xaver Dunstan (*1672 †1721), Kapuziner Mönch
- Adelbrand , Kanoniker
- Adelbrecht , Kanoniker
- Adelfrieder, Konrad , Studium
- Adelgasser, Franz , Studium
- Adelgasser, Gaudentius (*1795 †1877), Pfarrer
- Adelgasser, Georg Guido (*1736 †1780), Mönch Studium Zisterzienser
- Adelgasser, Johann Nikolaus , Studium
- Adelgasser, Joseph Johann Nepomuk , Studium
- Adelgeier, Philipp , Studium
- Adelgeiss, Alois (*1761 †1821), Pfarrer Studium
- Adelgeiss, Christoph (*1656), Studium
- Adelgeiss, David , Studium
- Adelgeiss, Franz , Studium
- Adelgeiss, Franz Ernst (*1684), Studium
- Adelgeiss, Franz Xaver (*1703), Jesuit
A Fortsetzung
-
Adelgeiss, Georg , Geistlicher Studium
- Adelgeiss, Johann (Geistlicher) , Geistlicher
- Adelgeiss, Johann (Inningen) ( †1584), Domvikar Kanoniker Magister Pfarrer Pönitentiar
- Adelgeiss, Johann (Lauingen) , Gymnasium Illustre Studium
- Adelgeiss, Johann Gottfried , Studium
- Adelgeiss, Johann Jakob , Schüler Studium
- Adelgeiss, Johann Konrad (*1655), Studium
- Adelgeiss, Joseph Ignaz , Studium
- Adelgeiss, Lorenz (*1613), Gymnasium illustre Studium
- Adelgeiss, Lukas (Landsberg) , Studium
- Adelgeiss, Lukas (Lauingen) , Studium
- Adelgeiss, Markus , Studium
- Adelgeiss, Martin , Rentmeister
- Adelgeiss, Matthäus (1595) (*1595), Gymnasium Illustre Schreiber Studium
- Adelgeiss, Matthäus (Schüler) , Schüler
- Adelgeiss, Matthäus (Studium) , Studium