Semantic search
SQLStore debug output
ASK Query
[[Card type::Spell Card]] [[Misc::Female]][[Medium::Anime]]OR[[Medium::Manga]]OR[[Medium::Video game]]OR[[Class 4::VG]]
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,
t0.smw_title,
t0.smw_subobject
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t12
INNER JOIN
`t2` AS t2 ON t12.s_id=t2.id
INNER JOIN
`smw_di_wikipage` AS t15 ON t12.s_id=t15.s_id) ON t0.smw_id=t12.s_id
WHERE
(t12.p_id='596' AND t12.o_id='1329'
AND (t15.p_id='557' AND t15.o_id='1050816')
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC,
t0.smw_title ASC,
t0.smw_subobject ASC
LIMIT
15
OFFSET
10
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,
t0.smw_title,
t0.smw_subobject
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_wikipage` AS t12
INNER JOIN
`t2` AS t2 ON t12.s_id=t2.id
INNER JOIN
`smw_di_wikipage` AS t15 ON t12.s_id=t15.s_id) ON t0.smw_id=t12.s_id
WHERE
(t12.p_id='596' AND t12.o_id='1329'
AND (t15.p_id='557' AND t15.o_id='1050816')
)
AND t0.smw_iw!=':smw'
AND t0.smw_iw!=':smw-delete'
AND t0.smw_iw!=':smw-redi'
ORDER BY
t0.smw_sort ASC,
t0.smw_title ASC,
t0.smw_subobject ASC
LIMIT
15
OFFSET
10
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t15 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id_3 | 9 | const,const | 795 | Using temporary; Using filesort |
1 | SIMPLE | t2 | eq_ref | PRIMARY | PRIMARY | 4 | ygowiki.t15.s_id | 1 | |
1 | SIMPLE | t12 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 13 | ygowiki.t15.s_id,const,const | 1 | Using index |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | ygowiki.t15.s_id | 1 | Using where |
Auxilliary Tables
- Temporary table t2
INSERT IGNORE INTO `t2` SELECT DISTINCT t3.s_id FROM `smw_di_blob` AS t3 WHERE (t3.o_hash='Anime') AND t3.p_id='599'
INSERT IGNORE INTO `t2` SELECT DISTINCT t5.s_id FROM `smw_di_blob` AS t5 WHERE (t5.o_hash='Manga') AND t5.p_id='599'
INSERT IGNORE INTO `t2` SELECT DISTINCT t7.s_id FROM `smw_di_blob` AS t7 WHERE (t7.o_hash='Video game') AND t7.p_id='599'
INSERT IGNORE INTO `t2` SELECT DISTINCT t9.s_id FROM `smw_di_wikipage` AS t9 WHERE t9.p_id='0' AND t9.o_id='0'
Query Metrics
Query-Size:12Query-Depth:1
Errors and Warnings
NoneEnglish name (linked) | Japanese name | [[Property]] |
---|---|---|
Angelic Choir | エンジェル・シング | Normal Spell Card |
Aria From Beyond | Normal Spell Card | |
Armor Ninjitsu Art of Revival | Normal Spell Card | |
Big Escape | Normal Spell Card | |
The Big March of Animals | Quick-Play Spell Card | |
Bond Between Teacher and Student | Normal Spell Card | |
Celestial Bell Tower | Continuous Spell Card | |
Change of Heart | Normal Spell Card | |
Climax Hour | クライマックスアワー | Normal Spell Card |
Constellar Twinkle | ティンクル・セイクリッド | Normal Spell Card |