Semantische Suche
Debug output SQLStore
ASK Query
[[Klassifikation von Bertuch::~*Vierf. Thiere*]]OR[[Klassifikation von Bertuch::~*Vierfüssige Thiere*]]
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
20
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
`t1` AS t1 ON t0.smw_id=t1.id
WHERE
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
20
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ALL | PRIMARY | 204 | 100.00 | Using temporary; Using filesort | |||
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | Interlinking_Pictura_wiki.t1.id | 1 | 50.00 | Using where |
Auxilliary Tables
- Temporary table t1
INSERT IGNORE INTO `t1` SELECT DISTINCT t2.s_id FROM `smw_di_blob` AS t2 WHERE (t2.o_hash LIKE '%Vierf. Thiere%') AND t2.p_id=157912
INSERT IGNORE INTO `t1` SELECT DISTINCT t4.s_id FROM `smw_di_blob` AS t4 WHERE (t4.o_hash LIKE '%Vierfüssige Thiere%') AND t4.p_id=157912
Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
None
Ad00341 02 012a
Vierf. Thiere. XXV.
Vierf. Thiere. XXV.
Ad00341 02 014a
Vierf. Thiere XXVI.
Vierf. Thiere XXVI.
Ad00341 02 017a
Vierf. Thiere. XXVII.
Vierf. Thiere. XXVII.
Ad00341 02 025a
Vierf. Thiere XXXI.
Vierf. Thiere XXXI.
Ad00341 02 055a
Vierf. Thiere XXXVII.
Vierf. Thiere XXXVII.
Ad00341 02 061a
Vierf. Thiere. XXXVIII.
Vierf. Thiere. XXXVIII.
Ad00341 02 066a
Vierf. Thiere. XXXIX.
Vierf. Thiere. XXXIX.
Ad00341 02 068a
Vierf. Thiere. XL.
Vierf. Thiere. XL.
Ad00341 02 070a
Vierf. Thiere. XLI.
Vierf. Thiere. XLI.
Ad00341 02 075a
Vierf. Thiere. XLII.
Vierf. Thiere. XLII.
Ad00341 02 079a
Vierf. Thiere. XLIII.
Vierf. Thiere. XLIII.
Ad00341 02 087a
Vierf. Thiere. XLV.
Vierf. Thiere. XLV.
Ad00341 02 094a
Vierf. Thiere. XLVII.
Vierf. Thiere. XLVII.
Ad00341 02 099a
Vierf. Thiere. XLVIII.
Vierf. Thiere. XLVIII.
Ad00341 03 013a
Vierf. Thiere. LI.
Vierf. Thiere. LI.
Ad00341 03 018a
Vierf. Thiere. LII.
Vierf. Thiere. LII.
Ad00341 03 034a
Vierf. Thiere. LIII.
Vierf. Thiere. LIII.
Ad00341 03 039a
Vierf. Thiere. LIV.
Vierf. Thiere. LIV.
Ad00341 03 048a
Vierf. Thiere. LVI.
Vierf. Thiere. LVI.
Ad00341 03 058a
Vierf. Thiere. LVII.
Vierf. Thiere. LVII.
Ad00341 03 060a
Vierf. Thiere LVIII.
Vierf. Thiere LVIII.
Ad00341 03 063a
Vierf. Thiere. LIX.
Vierf. Thiere. LIX.
Ad00341 03 066a
Vierf. Thiere. LX.
Vierf. Thiere. LX.
Ad00341 03 070a
Vierf. Thiere. LXI.
Vierf. Thiere. LXI.
Ad00341 03 074a
Vierf. Thiere. LXII.
Vierf. Thiere. LXII.
Ad00341 03 079a
Vierf. Thiere. LXIII.
Vierf. Thiere. LXIII.
Ad00341 03 082a
Vierf. Thiere. LXIV.
Vierf. Thiere. LXIV.
Ad00341 04 008a
Vierf. Thiere LXX.
Vierf. Thiere LXX.
Ad00341 04 013a
Vierf. Thiere. LXXI.
Vierf. Thiere. LXXI.
Ad00341 04 018a
Vierf. Thiere. LXXII.
Vierf. Thiere. LXXII.
Ad00341 04 023a
Vierfüssige Thiere LXXII.
Vierfüssige Thiere LXXII.
Ad00341 04 073a
Vierfüssige Thiere LXXIV.
Vierfüssige Thiere LXXIV.
Ad00341 05 033a
Vierfüssige Thiere. LXXV.
Vierfüssige Thiere. LXXV.
Ad00341 05 038a
Vierf. Thiere LXXVI.
Vierf. Thiere LXXVI.
Ad00341 06 025a
Vierf. Thiere. LXXVIII.
Vierf. Thiere. LXXVIII.
Ad00341 06 043a
Vierfüssige Thiere LXXIX.
Vierfüssige Thiere LXXIX.
Ad00341 06 048a
Vierfüssige Thiere LXXX.
Vierfüssige Thiere LXXX.
Ad00341 07 042a
Vierfüssige Thiere. LXXXI.
Vierfüssige Thiere. LXXXI.
Ad00341 07 060a
Vierf. Thiere. LXXXII.
Vierf. Thiere. LXXXII.
Ad00341 07 086a
Vierf. Thiere. LXXXIII.
Vierf. Thiere. LXXXIII.
Ad00341 07 088a
Vierf. Thiere. LXXXIV.
Vierf. Thiere. LXXXIV.
Ad00341 08 013a
Vierfüssige Thiere C.
Vierfüssige Thiere C.
Ad07761 02 003a
Vierf. Thiere. XXIII.
Vierf. Thiere. XXIII.
Ad07761 02 004a
Vierf. Thiere XXIV.
Vierf. Thiere XXIV.
Ad07761 02 011a
Vierf. Thiere. XXV.
Vierf. Thiere. XXV.
Ad07761 02 029a
Vierfüssige Thiere. XXXIII.
Vierfüssige Thiere. XXXIII.
Ad99998 01 003a
Vierf. Thiere. I.
Vierf. Thiere. I.
Ad99998 01 004a
Vierf. Thiere. II.
Vierf. Thiere. II.
Ad99998 01 008a
Vierf. Thiere. III.
Vierf. Thiere. III.
Ad99998 01 010a
Vierf. Thiere.
Vierf. Thiere.