Semantic search
SQLStore debug output
ASK Query
[[Concept:Non-monster cards]] [[Release::Yu-Gi-Oh! Ultimate Masters: World Championship Tournament 2006]] [[Genre::Destroy monster]]
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_wikipage` AS t3
INNER JOIN
`t5` AS t5 ON t3.o_id=t5.id
INNER JOIN
`smw_di_wikipage` AS t16 ON t3.s_id=t16.s_id
INNER JOIN
`smw_di_wikipage` AS t19 ON t3.s_id=t19.s_id) ON t0.smw_id=t3.s_id
WHERE
(t3.p_id='596'
AND (t16.p_id='1149' AND t16.o_id='9751')
AND (t19.p_id='507' AND t19.o_id='704743')
)
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_wikipage` AS t3
INNER JOIN
`t5` AS t5 ON t3.o_id=t5.id
INNER JOIN
`smw_di_wikipage` AS t16 ON t3.s_id=t16.s_id
INNER JOIN
`smw_di_wikipage` AS t19 ON t3.s_id=t19.s_id) ON t0.smw_id=t3.s_id
WHERE
(t3.p_id='596'
AND (t16.p_id='1149' AND t16.o_id='9751')
AND (t19.p_id='507' AND t19.o_id='704743')
)
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 | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t19 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | o_id | 5 | const | 277 | Using where; Using temporary; Using filesort |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | ygowiki.t19.s_id | 1 | Using where |
1 | SIMPLE | t16 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 13 | ygowiki.t19.s_id,const,const | 1 | Using index; Distinct |
1 | SIMPLE | t3 | ref | s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3 | s_id_3 | 8 | ygowiki.t19.s_id,const | 1 | Using where; Using index; Distinct |
1 | SIMPLE | t5 | eq_ref | PRIMARY | PRIMARY | 4 | ygowiki.t3.o_id | 1 | Distinct |
Auxilliary Tables
- Temporary table t5
INSERT IGNORE INTO `t5` (id) VALUES ('1329')
INSERT IGNORE INTO `t5` (id) VALUES ('1787')
INSERT IGNORE INTO `t5` (id) VALUES ('87260')
INSERT IGNORE INTO `t5` (id) VALUES ('70265')
INSERT IGNORE INTO `t5` (id) VALUES ('2881')
INSERT IGNORE INTO `t5` (id) VALUES ('77217')
INSERT IGNORE INTO `t5` (id) VALUES ('769993')
INSERT IGNORE INTO `t5` (id) VALUES ('72320')
INSERT IGNORE INTO `t5` (id) VALUES ('0')
INSERT IGNORE INTO `t5` (id) VALUES ('38099')
Query Metrics
Query-Size:5Query-Depth:1
Errors and Warnings
NoneEnglish name (linked) | Japanese name | [[Card type]] | [[Property]] |
---|---|---|---|
Mega Ton Magical Cannon | メガトン魔導キャノン | Spell Card | Normal Spell Card |
Michizure | 道連れ | Trap Card | Normal Trap Card |
Minefield Eruption | 岩盤爆破 | Trap Card | Normal Trap Card |
Mirror Force | 聖なるバリア -ミラーフォース- | Trap Card | Normal Trap Card |
Mystic Box | 死のマジック・ボックス | Spell Card | Normal Spell Card |
Needle Ceiling | つり天井 | Trap Card | Normal Trap Card |
Needle Wall | ニードル・ウォール | Trap Card | Continuous Trap Card |
Nobleman of Crossout | 抹殺の使徒 | Spell Card | Normal Spell Card |
Offerings to the Doomed | 死者への供物 | Spell Card | Quick-Play Spell Card |
Ojama Delta Hurricane!! | おジャマ・デルタハリケーン!! | Spell Card | Normal Spell Card |
Ojamuscle | おジャマッスル | Spell Card | Normal Spell Card |
Order to Charge | 突撃指令 | Spell Card | Quick-Play Spell Card |
Pineapple Blast | パイナップル爆弾 | Trap Card | Normal Trap Card |
Pyramid of Light | 光のピラミッド | Trap Card | Continuous Trap Card |
Raigeki | サンダー・ボルト | Spell Card | Normal Spell Card |
Raigeki Break | サンダー・ブレイク | Trap Card | Normal Trap Card |
Really Eternal Rest | 大成仏 | Trap Card | Normal Trap Card |
Ring of Destruction | 破壊輪 | Trap Card | Normal Trap Card |
Sakuretsu Armor | 炸裂装甲 | Trap Card | Normal Trap Card |
Shield Crash | シールドクラッシュ | Spell Card | Normal Spell Card |
Skull Lair | 死霊の巣 | Trap Card | Continuous Trap Card |
Smashing Ground | 地砕き | Spell Card | Normal Spell Card |
Solemn Judgment | 神の宣告 | Trap Card | Counter Trap Card |
Soul Taker | ソウルテイカー | Spell Card | Normal Spell Card |
Special Hurricane | スペシャルハリケーン | Spell Card | Normal Spell Card |
Sword of Dragon's Soul | 竜殺しの剣 | Spell Card | Equip Spell Card |
Thousand Energy | サウザンドエナジー | Spell Card | Normal Spell Card |
Thousand Knives | 千本ナイフ | Spell Card | Normal Spell Card |
Thunder Crash | サンダー・クラッシュ | Spell Card | Normal Spell Card |
Token Feastevil | トークン謝肉祭 | Trap Card | Normal Trap Card |
Token Thanksgiving | トークン収穫祭 | Spell Card | Normal Spell Card |
Torrential Tribute | 激流葬 | Trap Card | Normal Trap Card |
Tragedy | 断頭台の惨劇 | Trap Card | Normal Trap Card |
Trap Hole | 落とし穴 | Trap Card | Normal Trap Card |
Triage | 方舟の選別 | Trap Card | Counter Trap Card |
Triangle Power | トライアングルパワー | Spell Card | Normal Spell Card |
Tribute to The Doomed | 死者への手向け | Spell Card | Normal Spell Card |
Two-Pronged Attack | はさみ撃ち | Trap Card | Normal Trap Card |
Weed Out | ふるい落とし | Trap Card | Normal Trap Card |
Widespread Ruin | 万能地雷グレイモヤ | Trap Card | Normal Trap Card |
Wild Nature's Release | 野性解放 | Spell Card | Normal Spell Card |