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
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
`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
20
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
Ad00341 08 039a
Würmer. XXX.
Würmer. XXX.
Ad00341 08 061a
Würmer. XXXI.
Würmer. XXXI.
Ad00341 08 071a
Würmer XXXII.
Würmer XXXII.
Ad00341 08 076a
Würmer. XXXIII.
Würmer. XXXIII.
Ad00341 08 096a
Würmer. XXXIV.
Würmer. XXXIV.
Ad99998 01 085a
Würmer. II.
Würmer. II.
Ad99998 01 091a
Würmer. III.
Würmer. III.
Ad99998 03 096a
Würmer IV.
Würmer IV.
Ad99998 04 045a
Würmer. V.
Würmer. V.
Ad99998 04 091a
Würmer. VI.
Würmer. VI.
Ad99998 05 024a
Würmer VII.
Würmer VII.
Ad99998 05 059a
Würmer VIII.
Würmer VIII.
Ad99998 05 071a
Würmer IX.
Würmer IX.
Ad99998 05 101a
Würmer X.
Würmer X.
Ad99998 06 009a
Würmer XI.
Würmer XI.
Ad99998 06 074a
Würmer. XII.
Würmer. XII.
Ad99998 06 086a
Würmer XIII.
Würmer XIII.
Ad99998 07 005a
Würmer XIV.
Würmer XIV.
Ad99998 07 010a
Würmer XV.
Würmer XV.
Ad99998 07 014a
Würmer. XVI.
Würmer. XVI.
Ad99998 07 021a
Würmer. XVII.
Würmer. XVII.
Ad99998 07 030a
Würmer. XVIII.
Würmer. XVIII.
Ad99998 07 053a
Würmer. XIX.
Würmer. XIX.
Ad99998 08 032a
Würmer. XX.
Würmer. XX.
Ad99998 08 062a
Würmer. XXI.
Würmer. XXI.
Ad99998 09 003a
Würmer. XXII.
Würmer. XXII.
Ad99998 09 004a
Würmer. XXIII.
Würmer. XXIII.
Ad99998 09 036a
Würmer. XXV
Würmer. XXV
Ad99998 09 040a
Würmer. XXVl.
Würmer. XXVl.
Ad99998 09 079a
Würmer. XXVII.
Würmer. XXVII.
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.