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]] [[Actions::Activates if destroyed by battle]]
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 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='628' AND t18.o_id='1468')
  )
  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
1SIMPLEt7ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt5refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t7.id,const12
1SIMPLEt2refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t5.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t5.s_id1Using where
1SIMPLEt18refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t5.s_id,const,const1Using index; Distinct
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')
Query Metrics
Query-Size:6
Query-Depth:1
Errors and Warnings
None
English name (linked)Japanese name[[Card type]][[Property]]
GamusharaガムシャラTrap CardNormal Trap Card
Gemini Trap Hole二重の落とし穴（デュアル・ホール）Trap CardNormal Trap Card
Generaider Boss Loot王の報酬（ジェネレイド・リワード）Spell CardContinuous Spell Card
Ghostrick Breakゴーストリック・ブレイクTrap CardNormal Trap Card
The Grave of Enkindling復（ふっ）活（かつ）の墓（はか）穴（あな）Trap CardNormal Trap Card
Graveyard of Wandering Souls魂（たましい）のさまよう墓（はか）場（ば）Trap CardContinuous Trap Card
Guard Go!ガードゴー！Trap CardNormal Trap Card
Guardian of the Voiceless Voice粛（しゅく）声（せい）のガーディアンTrap CardContinuous Trap Card
Gunkan Sushipyard Seaside Supper Spot軍（ぐん）貫（かん）処（どころ） 『海（かい）せん』Spell CardField Spell Card
Heritage of the Chalice聖（せい）杯（はい）の継（けい）承（しょう）Spell CardNormal Spell Card
Hero Counterattackヒーロー逆（ぎゃく）襲（しゅう）Trap CardNormal Trap Card
Hero Signalヒーロー・シグナルTrap CardNormal Trap Card
Hero SpiritヒーロースピリッツTrap CardNormal Trap Card
Hollow Giants龍馬躓図（りゅうめつまずきのず）Spell CardContinuous Spell Card
How Did Dai Get Here?奇（き）異（い）界（かい）開（かい）Trap CardNormal Trap Card
Icejade Curse氷（ヒ）水（スイ）呪（ジュ）縛（バク）Spell CardContinuous Spell Card
Infernity Reflectorインフェルニティ・リフレクターTrap CardNormal Trap Card
Kashtira Akstraクシャトリラ・アクストラSpell CardQuick-Play Spell Card
Krystal Avatarクリスタル・アバターTrap CardContinuous Trap Card
Level Resist Wallレベル・レジストウォールTrap CardNormal Trap Card
Liberty at Last!自（じ）由（ゆう）解（かい）放（ほう）Trap CardNormal Trap Card
Link into the VRAINS!Ｉｎｔｏ（イントゥ） ｔｈｅ（ザ） ＶＲＡＩＮＳ（ヴレインズ）！Spell CardNormal Spell Card
Lunalight Reincarnation Dance月光輪廻舞踊（ムーンライト・リンカネーション・ダンス）Trap CardNormal Trap Card
Machina Armored Unit機甲部隊の最前線（マシンナーズ・フロントライン）Spell CardContinuous Spell Card
Machina Defense Perimeter機甲部隊の防衛圏（マシンナーズ・ディフェンスリジョン）Spell CardContinuous Spell Card
Machine Assembly Lineマシン・デベロッパーSpell CardContinuous Spell Card
Marincess Snow海晶乙女雪花（マリンセス・スノー）Trap CardNormal Trap Card
Meklord Assembly機（き）皇（こう）創（そう）出（しゅつ）Spell CardContinuous Spell Card
Mementomictlan冥（めい）骸（がい）府（ふ）－メメントランSpell CardField Spell Card
Metalfoes Counterメタルフォーゼ・カウンターTrap CardNormal Trap Card
Mini-Gutsミニマム・ガッツSpell CardNormal Spell Card
Mokey Mokey Smackdown怒（いか）れるもけもけSpell CardContinuous Spell Card
Mythical Institution魔導研究所（マジック・ラボ）Spell CardContinuous Spell Card
Necklace of Command与（よ）奪（だつ）の首（くび）飾（かざ）りSpell CardEquip Spell Card
New World - Amritara新（しん）世（せ）壊（かい）＝アムリターラSpell CardField Spell Card
Nitro UnitニトロユニットSpell CardEquip Spell Card
Numbers Protectionナンバーズ・プロテクトTrap CardCounter Trap Card
Ogdoadic Origin溟（めい）界（かい）の淵（えん）源（げん）Spell CardField Spell Card
Option HunterオプションハンターTrap CardNormal Trap Card
Parallel Selectionパラレル・セレクトTrap CardNormal Trap Card
Peaceful Planet Calarium伍（ご）世（せ）壊（かい）＝カラリウムSpell CardField Spell Card
Pennant of Revolution革（かく）命（めい）の御（み）旗（はた）Trap CardContinuous Trap Card
Perform Puppetパフォーム・パペットSpell CardContinuous Spell Card
Performapal RevivalＥＭ（エンタメイト）リバイバルTrap CardNormal Trap Card
Psi-Curseカース・サイキックTrap CardNormal Trap Card
Ragnaraika Hunting Dance蕾禍（ライカ）大（ダイ）輪（リン）首（クビ）狩（カリ）舞（マイ）Trap CardNormal Trap Card
Raidraptor - ReturnＲＲ（レイド・ラプターズ）－リターンTrap CardNormal Trap Card
Realm Elegy世（せ）壊（かい）挽（ばん）歌（か）Spell CardNormal Spell Card
Red-Eyes Burnレッドアイズ・バーンTrap CardNormal Trap Card
Ribbon of RebirthリボーンリボンSpell CardEquip Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"