Semantic search
Debug output SQLStore
ASK Query
[[:+]] [[IsGameMenu::false]] [[IsinGameMenu::Capes & Cloaks]]
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
`salem_wikismw_object_ids` AS t0
INNER JOIN
(`salem_wikismw_object_ids` AS t2
INNER JOIN
`salem_wikismw_di_bool` AS t3 ON t2.smw_id=t3.s_id
INNER JOIN
`salem_wikismw_di_blob` AS t5 ON t2.smw_id=t5.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (
(t3.o_value=0) AND t3.p_id=2477)
AND (
(t5.o_hash='Capes & Cloaks') AND t5.p_id=2479)
)
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
0
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
`salem_wikismw_object_ids` AS t0
INNER JOIN
(`salem_wikismw_object_ids` AS t2
INNER JOIN
`salem_wikismw_di_bool` AS t3 ON t2.smw_id=t3.s_id
INNER JOIN
`salem_wikismw_di_blob` AS t5 ON t2.smw_id=t5.s_id) ON t0.smw_id=t2.smw_id
WHERE
(t2.smw_namespace=0
AND (
(t3.o_value=0) AND t3.p_id=2477)
AND (
(t5.o_hash='Capes & Cloaks') AND t5.p_id=2479)
)
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
0
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t5 | ref | s_id, p_id, s_id_2, o_hash | p_id | 262 | const, const | 34 | 100.00 | Using index condition; Using temporary; Using filesort |
1 | SIMPLE | t3 | ref | s_id, o_value | s_id | 8 | k56270_salemwiki.t5.s_id, const | 1 | 91.94 | Using where |
1 | SIMPLE | t2 | eq_ref | PRIMARY, smw_id, smw_namespace | PRIMARY | 4 | k56270_salemwiki.t5.s_id | 1 | 50.00 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY, smw_id, smw_iw, smw_iw_2 | PRIMARY | 4 | k56270_salemwiki.t5.s_id | 1 | 50.03 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneNon-menu entries you can find in the Capes & Cloaks-menu?'"`UNIQ--nowiki-00000000-QINU`"'?are:
Any Glowworm.
Argopelter Cape.
Bearskin Cape.
Beaverskin Cape.
Blue Glowworm Cape.
Cougarskin Cape.
Cow Hide Cape.
Crow Feather Cape.
Darkenbear Cape.
Deerskin Cape.
Fine Hide Cape.
Frozen Cape.
Furfur Cape.
Goatskin Cape.
Gold Cape.
Green Glowworm Cape.
Hide Cape.
Mammoth Cape.
March Hare Cape.
Nobleman's Cape.
Pigskin Cape.
Pilgrim's Cape.
Priestly Stole.
Purple Glowworm Cape.
Rabbitskin Cape.
Red Glowworm Cape.
Serpent Cape.
Sheepskin Cape.
Snakeskin Cape.
Spirit Cape of the Bear.
Spirit Cape of the Beaver.
Spirit Cape of the Deer.
Wishpoosh Cape.
Yellow Glowworm Cape.