Semantic search
SQLStore debug output
ASK Query
[[Medium::Anime]] [[Card type::Spell Card]]
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_blob` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='Anime') AND t2.p_id='599'
AND (t4.p_id='596' AND t4.o_id='1329')
)
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
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,
t0.smw_title,
t0.smw_subobject
FROM
`smw_object_ids` AS t0
INNER JOIN
(`smw_di_blob` AS t2
INNER JOIN
`smw_di_wikipage` AS t4 ON t2.s_id=t4.s_id) ON t0.smw_id=t2.s_id
WHERE
(
(t2.o_hash='Anime') AND t2.p_id='599'
AND (t4.p_id='596' AND t4.o_id='1329')
)
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
55
OFFSET
50
SQL Explain
ID | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | t4 | 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 | 23534 | Using temporary; Using filesort |
1 | SIMPLE | t2 | ref | s_id,o_hash,s_id_2,p_id | s_id | 8 | ygowiki.t4.s_id,const | 1 | Using where |
1 | SIMPLE | t0 | eq_ref | PRIMARY,smw_id,smw_iw,smw_iw_2 | PRIMARY | 4 | ygowiki.t4.s_id | 1 | Using where |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:4Query-Depth:1
Errors and Warnings
NoneEnglish name (linked) | Japanese name | [[Property]] |
---|---|---|
Against the Wind | アゲインスト・ウィンド | Normal Spell Card |
Aid to the Doomed | Quick-Play Spell Card | |
Air Cracking Storm | エアークラック・ストーム | Equip Spell Card |
Akashic Record | アカシックレコード | Normal Spell Card |
Alert Lancer | アラート・ランサー | Normal Spell Card |
All For One | チーム・プレー | Normal Spell Card |
Allegro Toile | アレグロ・トゥール | Quick-Play Spell Card |
Allure Dance | Continuous Spell Card | |
Allure Palace | Field Spell Card | |
Altar of Mist | 霧の祭壇 | Normal Spell Card |
Altar of Restoration | Normal Spell Card | |
Amazing Pendulum | アメイジング・ペンデュラム | Normal Spell Card |
Amazon Magician | アマゾネスの | Normal Spell Card |
Amazoness Arena | アマゾネスの | Field Spell Card |
Amazoness Call | アマゾネスの | Normal Spell Card |
Amazoness Charm | Normal Spell Card | |
Amazoness Magic Mirror | アマゾネスの | Continuous Spell Card |
Amazoness Spellcaster | アマゾネスの | Normal Spell Card |
Amazoness Trainer | アマゾネスの | Quick-Play Spell Card |
Amazoness Village | アマゾネスの | Field Spell Card |
Amplifier | Equip Spell Card | |
Amplifier | Equip Spell Card | |
Amusi Cheer | アミュージー・チア | Normal Spell Card |
Anchor Bind | アンカー・バインド | Normal Spell Card |
Ancient Armageddon Gear | Continuous Spell Card | |
Ancient City | Field Spell Card | |
Ancient City - Rainbow Ruins | Field Spell Card | |
Ancient Forest | Field Spell Card | |
Ancient Gate | Normal Spell Card | |
Ancient Gear Castle | Continuous Spell Card | |
Ancient Gear Catapult | Normal Spell Card | |
Ancient Gear Double Imitation | Normal Spell Card | |
Ancient Gear Drill | Normal Spell Card | |
Ancient Gear Explosive | Normal Spell Card | |
Ancient Gear Factory | Normal Spell Card | |
Ancient Gear Fist | Normal Spell Card | |
Ancient Gear Fortress | Continuous Spell Card | |
Ancient Gear Inspection | Normal Spell Card | |
Ancient Gear Magic Shield | Equip Spell Card | |
Ancient Gear Mask | Equip Spell Card | |
Ancient Gear Scrap Fusion | Normal Spell Card | |
Ancient Gear Tank | Equip Spell Card | |
Ancient Gear Workshop | Normal Spell Card | |
Ancient Key | Continuous Spell Card | |
Ancient Rules | Normal Spell Card | |
Ancient Telescope | Normal Spell Card | |
Ancient Tome | Continuous Spell Card | |
Angel Wing | エンジェル・ウィング | Equip Spell Card |
Anti-Magic Arrows | Normal Spell Card | |
Apocalypse - Beast Gear World | Field Spell Card |