Semantische Suche
Debug output SQLStore
ASK Query
[[Person::~I*]]
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 'I%') 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
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 LIKE 'I%') 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
500
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 | 1726 | 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
NoneI
-
Imhof, Franz Sebastian (*1694 †1749), Jesuit Studium
- Imhof, Franz Xaver (Augsburg) ( †1721), Studium
- Imhof, Franz Xaver (Mindelheim) , Studium
- Imhof, Franz Xaver Anton von Padua von , Studium
- Imhof, Franz Xaver Octavian , Studium
- Imhof, Freiherr von , Studium
- Imhof, Fridolin (Chorherr) , Chorherr Kanoniker Pfarrer
- Imhof, Fridolin (Pfarrer) ( †1550 JL), Kanoniker Pfarrer
- Imhof, Friedrich Wilhelm , Studium
- Imhof, Gabriel (1556) (*1556 JL †1581 JL), Studium
- Imhof, Gabriel (1591) (*1591 †1631), Gymnasium Illustre Militär Soldat Studium
- Imhof, Gabriel (Nürnberg) ( †1581 JL), Studium
- Imhof, Georg (1601) (*1601 †1659), Jurist Studium
- Imhof, Georg (Jesuit) ( †1622), Jesuit
- Imhof, Georg Andreas , Studium
- Imhof, Gerhard (*1439 JL †1485 JL), Jurist Professor Studium
- Imhof, Gotthard , Geistlicher
I Fortsetzung
-
Imhof, Guido Freiherr von , Studium
- Imhof, Guido von (*1778), Studium
- Imhof, Heinrich (1690) (*1690 †1699), Mönch Zisterzienser
- Imhof, Heinrich (Frammersbach) , Studium
- Imhof, Heinrich (Johanniter) , Johanniter Pfarrer
- Imhof, Heinrich (Kanoniker) ( †1369 JL), Kanoniker
- Imhof, Heinrich (Konstanz) , Studium
- Imhof, Heinrich (Laufen) , Studium
- Imhof, Heinrich (Lohr) , Studium
- Imhof, Hieronymus (1614) (*1614 †1659), Jesuitengymnasium Studium
- Imhof, Hieronymus (1624) (*1624), Studium
- Imhof, Hieronymus (Augsburg) , Studium
- Imhof, Hieronymus (Kastner) ( †1659), Kastner
- Imhof, Hieronymus (Nürnberg) , Studium
- Imhof, Hieronymus Anton , Studium
- Imhof, Hieronymus Dominik ( †1676), Pfleger Studium
- Imhof, Hieronymus Franz , Studium
I Fortsetzung
-
Imhof, Jakob (Nürnberg) , Studium
- Imhof, Jakob (Studium) , Studium
- Imhof, Jakob Christoph Alban (*1580 JL †1656), Kapuziner Mönch Studium
- Imhof, Jakob Freiherr von , Schüler
- Imhof, Jakob Joseph Alois Freiherr , Schüler Studium
- Imhof, Jeremias (*1621), Notar Studium
- Imhof, Johann (1460) (*1460 JL), Studium
- Imhof, Johann (Bremgarten) , Priester Studium
- Imhof, Johann (Frammersbach) , Studium
- Imhof, Johann (Frammersbach, Studium) ( †1772), Studium
- Imhof, Johann (Frammersbach, Studium, H34794) , Pfarrer Studium
- Imhof, Johann (Geistlicher) , Geistlicher
- Imhof, Johann (Gerolzhofen) , Studium
- Imhof, Johann (Herzogenaurach) , Studium
- Imhof, Johann (Kulmbach) , Studium
- Imhof, Johann (Nürnberg) , Studium