Semantische Suche
Debug output SQLStore
ASK Query
[[Klassifikation von Bertuch::~*Würmer*]]
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 '%Würmer%') AND t1.p_id=157912)
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
50
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 '%Würmer%') AND t1.p_id=157912)
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
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t1 | ref | s_id, p_id, s_id_2 | p_id | 4 | const | 2966 | 11.11 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | Interlinking_Pictura_wiki.t1.s_id | 1 | 50.00 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:2Query-Depth:1
Errors and Warnings
None
Ad99998 10 004a
Würmer. XXVIII.
Würmer. XXVIII.
Ad99998 10 014a
Würmer. XXIX.
Würmer. XXIX.
Ad99998 10 039a
Würmer. XXX.
Würmer. XXX.
Ad99998 10 061a
Würmer. XXXI.
Würmer. XXXI.
Ad99998 10 071a
Würmer XXXII.
Würmer XXXII.
Ad99998 10 076a
Würmer. XXXIII.
Würmer. XXXIII.
Ad99998 10 095a
Würmer. XXXIV.
Würmer. XXXIV.
Ad99998 11 014a
Würmer. XXXV.
Würmer. XXXV.
Ad99998 11 039a
Würmer. XXXVI.
Würmer. XXXVI.
Ad99998 11 040a
Würmer. XXXVII.
Würmer. XXXVII.
Ad99998 11 084a
Würmer. XXXVIII.
Würmer. XXXVIII.
Ad99998 11 085a
Würmer. XXXIX.
Würmer. XXXIX.
Ad99998 12 005a
Würmer. XL.
Würmer. XL.
Ad99998 12 024a
Würmer. XL.
Würmer. XL.
Ad99998 12 040a
Würmer. XLI.
Würmer. XLI.
Ad99998 12 045a
Würmer. XLII.
Würmer. XLII.
Ad99998 12 055a
Würmer. XLIII.
Würmer. XLIII.
Ad99999 01 085a
Würmer. II.
Würmer. II.
Ad99999 01 091a
Würmer III.
Würmer III.
Ad99999 03 096a
Würmer IV.
Würmer IV.
Ad99999 04 045a
Würmer. V.
Würmer. V.
Ad99999 04 091a
Würmer. VI.
Würmer. VI.
Ad99999 06 009a
Würmer XI.
Würmer XI.
Ad99999 06 074a
Würmer. XII.
Würmer. XII.
Ad99999 06 086a
Würmer XIII.
Würmer XIII.
Ad99999 07 005a
Würmer XIV.
Würmer XIV.
Ad99999 07 010a
Würmer XV.
Würmer XV.
Ad99999 07 014a
Würmer. XVI.
Würmer. XVI.
Ad99999 07 021a
Würmer. XVII.
Würmer. XVII.
Ad99999 07 030a
Würmer. XVIII.
Würmer. XVIII.
Ad99999 07 053a
Würmer. XIX.
Würmer. XIX.
Ad99999 08 032a
Würmer. XX.
Würmer. XX.
Ad99999 08 062a
Würmer. XXI.
Würmer. XXI.
Ad99999 09 003a
Würmer. XXII.
Würmer. XXII.
Ad99999 09 004a
Würmer. XXIII.
Würmer. XXIII.
Ad99999 09 036a
Würmer. XXV
Würmer. XXV
Ad99999 09 040a
Würmer. XXVl.
Würmer. XXVl.
Ad99999 09 079a
Würmer. XXVII.
Würmer. XXVII.
Ad99999 10 004a
Würmer. XXVIII.
Würmer. XXVIII.
Ad99999 10 014a
Würmer. XXIX.
Würmer. XXIX.
Ad99999 10 039a
Würmer. XXX.
Würmer. XXX.
Ad99999 10 061a
Würmer. XXXI.
Würmer. XXXI.
Ad99999 10 071a
Würmer XXXII.
Würmer XXXII.
Ad99999 10 076a
Würmer. XXXIII.
Würmer. XXXIII.
Ad99999 10 095a
Würmer. XXXIV.
Würmer. XXXIV.
Ad99999 11 014a
Würmer. XXXV.
Würmer. XXXV.
Ad99999 11 039a
Würmer. XXXVI.
Würmer. XXXVI.
Ad99999 11 040a
Würmer. XXXVII.
Würmer. XXXVII.
Ad99999 11 084a
Würmer. XXXVIII.
Würmer. XXXVIII.
Ad99999 11 085a
Würmer. XXXIX.
Würmer. XXXIX.