Semantic search

Jump to: navigation, search
Condition
Printout selection
Options
Parameters [] 
limit:

The maximum number of results to return
offset:

The offset of the first result
link:

Show values as links
headers:

Display the headers/property names
mainlabel:

The label to give to the main page name
intro:

The text to display before the query results, if there are any
outro:

The text to display after the query results, if there are any
searchlabel:

Text for continuing the search
default:

The text to display if there are no query results
class:

An additional CSS class to set for the table
transpose:

Display table headers vertically and results horizontally
sep:

The separator between results
Sort options
Delete
Add sorting condition
SQLStore debug output
ASK Query
[[Medium::OCG||TCG]] [[Concept:Non-monster cards]] [[MonsterSpellTrap::Destroys Monster Cards||Destroys your Monster Cards||Destroys your opponent's Monster Cards]]
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 t2
INNER JOIN
  (`smw_di_wikipage` AS t5
INNER JOIN
  `t7` AS t7 ON t5.o_id=t7.id) ON t2.s_id=t5.s_id
INNER JOIN
  (`smw_di_wikipage` AS t18
INNER JOIN
  `t20` AS t20 ON t18.o_id=t20.id) ON t2.s_id=t18.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   ((t2.o_hash='OCG') OR (t2.o_hash='TCG')
  ) AND t2.p_id='599'
   AND (t5.p_id='596')
   AND (t18.p_id='556')
  )
  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
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt20ALLPRIMARY3Using temporary; Using filesort
1SIMPLEt18refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t20.id,const12
1SIMPLEt2refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t18.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t18.s_id1Using where
1SIMPLEt5refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_38ygowiki.t18.s_id,const1Using where; Using index; Distinct
1SIMPLEt7eq_refPRIMARYPRIMARY4ygowiki.t5.o_id1Distinct
Auxilliary Tables
  • Temporary table t7
      INSERT IGNORE INTO `t7` (id) VALUES ('1329')
      INSERT IGNORE INTO `t7` (id) VALUES ('1787')
      INSERT IGNORE INTO `t7` (id) VALUES ('87260')
      INSERT IGNORE INTO `t7` (id) VALUES ('70265')
      INSERT IGNORE INTO `t7` (id) VALUES ('2881')
      INSERT IGNORE INTO `t7` (id) VALUES ('77217')
      INSERT IGNORE INTO `t7` (id) VALUES ('769993')
      INSERT IGNORE INTO `t7` (id) VALUES ('72320')
      INSERT IGNORE INTO `t7` (id) VALUES ('0')
      INSERT IGNORE INTO `t7` (id) VALUES ('38099')
  • Temporary table t20
      INSERT IGNORE INTO `t20` (id) VALUES ('1400')
      INSERT IGNORE INTO `t20` (id) VALUES ('1789')
      INSERT IGNORE INTO `t20` (id) VALUES ('1487')
Query Metrics
Query-Size:8
Query-Depth:1
Errors and Warnings
None
English name (linked)Japanese name[[Card type]][[Property]]
Cattle Call烏（う）合（ごう）無（む）象（ぞう）Spell CardQuick-Play Spell Card
Celestia異（い）層（そう）空（くう）間（かん）Spell CardField Spell Card
Celestial Transformation光（こう）神（しん）化（か）Spell CardQuick-Play Spell Card
Centur-Ion True Awakening騎士皇爆誕（トゥルース・センチュリオン）Trap CardCounter Trap Card
Chain Destruction連鎖破壊（チェーン・デストラクション）Trap CardNormal Trap Card
Chain Dispel連鎖解呪（チェーン・ディスペル）Trap CardNormal Trap Card
Chain Ignition連鎖誘爆（チェーン・イグニッション）Trap CardContinuous Trap Card
Chain Materialチェーン・マテリアルTrap CardNormal Trap Card
Champion's Vigilance王（おう）者（じゃ）の看（かん）破（ぱ）Trap CardCounter Trap Card
Chaos Burstカオス・バーストTrap CardNormal Trap Card
Chaos Endカオス・エンドSpell CardNormal Spell Card
Chaos Infinityカオス・インフィニティTrap CardNormal Trap Card
Chef's Special RecipeＲｅｃｅｔｔｅ ｄｅ Ｓｐéｃｉａｌｉｔé（ルセット・ド・スペシャリテ）～料理長（シェフ）自（じ）慢（まん）のレシピ～Trap CardCounter Trap Card
Chivalry威（い）風（ふう）堂（どう）々（どう）Trap CardCounter Trap Card
Clay Chargeクレイ・チャージTrap CardNormal Trap Card
Cloningクローン複（ふく）製（せい）Trap CardNormal Trap Card
Contact with Gustoガスタの交（こう）信（しん）Spell CardNormal Spell Card
Core Blastコア・ブラストTrap CardContinuous Trap Card
Core Reinforcementコアの再（さい）練（れん）成（せい）Trap CardContinuous Trap Card
Cross CounterクロスカウンターTrap CardNormal Trap Card
Crush Card Virus死（し）のデッキ破（は）壊（かい）ウイルスTrap CardNormal Trap Card
Crusher Run超整地破砕（クラッシャー・ラン）Trap CardContinuous Trap Card
Crystal Miracle宝（ほう）玉（ぎょく）の奇（き）跡（せき）Trap CardCounter Trap Card
Crystal Raigeki宝（ほう）玉（ぎょく）の祈（いの）りTrap CardNormal Trap Card
Cyber Energy Shock電脳（サイバー）エナジーショックSpell CardQuick-Play Spell Card
Cyberdark Invasionサイバーダーク・インヴェイジョンTrap CardContinuous Trap Card
Cybernetic Hidden Technologyサイバネティック・ヒドゥン・テクノロジーTrap CardContinuous Trap Card
Cybernetic Overflowサイバネティック・オーバーフローTrap CardNormal Trap Card
Cybernetic Revolutionサイバネティック・レボリューションTrap CardNormal Trap Card
Cybernetic Zoneサイバネティック・ゾーンSpell CardQuick-Play Spell Card
Cybersal Cycloneサイバーサル・サイクロンSpell CardQuick-Play Spell Card
Cynet Crosswipeサイバネット・クロスワイプSpell CardQuick-Play Spell Card
Cynet Refreshサイバネット・リフレッシュTrap CardNormal Trap Card
Cynet Regressionサイバネット・リグレッションTrap CardNormal Trap Card
D - CounterＤ（ディー）－カウンターTrap CardNormal Trap Card
D.D. Trap Hole異（い）次（じ）元（げん）の落（お）とし穴（あな）Trap CardNormal Trap Card
Danger! Disturbance! Disorder!激（げき）動（どう）の未（み）界（かい）域（いき）Spell CardField Spell Card
Dangerous Machine Type-6デンジャラスマシン ＴＹＰＥ（タイプ）－６（シックス）Spell CardContinuous Spell Card
Dark Burning Magic黒・爆・裂・破・魔・導（ブラック・バーニング・マジック）Spell CardQuick-Play Spell Card
Dark Coffin呪（のろ）われた棺（ひつぎ）Trap CardNormal Trap Card
Dark Contract with the Witch戦乙女（ヴァルキリー）の契（けい）約（やく）書（しょ）Trap CardContinuous Trap Card
Dark Holeブラック・ホールSpell CardNormal Spell Card
Dark Illusion闇（やみ）の幻（げん）影（えい）Trap CardCounter Trap Card
Darklord Rebellion背（はい）徳（とく）の堕（だ）天（てん）使（し）Trap CardNormal Trap Card
Deck Devastation Virus魔（ま）のデッキ破（は）壊（かい）ウイルスTrap CardNormal Trap Card
Decode Destructionデコード・エンドSpell CardNormal Spell Card
Des Croaking死の合唱（デスコーラス）Spell CardNormal Spell Card
Destruct Potionデストラクト・ポーションTrap CardNormal Trap Card
Destruction Jammerデストラクション・ジャマーTrap CardCounter Trap Card
Destruction Sword Flash破（は）壊（かい）剣（けん）一（いっ）閃（せん）Trap CardNormal Trap Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"