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
[[Concept:Non-monster cards]] [[Actions::Sends from hand to Graveyard for cost]]
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) ON t0.smw_id=t3.s_id
WHERE
  (t3.p_id='596'
   AND (t16.p_id='628' AND t16.o_id='3686')
  )
  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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt5ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt3refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t5.id,const12
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t3.s_id1Using where
1SIMPLEt16refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t3.s_id,const,const1Using index; 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:3
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
7 Shift7（セブン）シフトSpell CardNormal Spell Card
7 Shift (anime)7（セブン）シフトSpell CardNormal Spell Card
Abyss Arms - Madness Shellアビスアームズ・マッドネスシェルSpell CardEquip Spell Card
Additional Mirror Level 7アディショナル・ミラー・レベル７（セブン）Spell CardQuick-Play Spell Card
Additional Mirror Level 7 (manga)アディショナル・ミラー・レベル７（セブン）Spell CardQuick-Play Spell Card
Allure Palace魅惑の宮殿（アリュール・パレス）Spell CardField Spell Card
Altergeist Haunted Rockオルターガイスト・ホーンデッドロックTrap CardContinuous Trap Card
Armed Changerアームド・チェンジャーSpell CardEquip Spell Card
Armed Changer (anime)アームド・チェンジャーSpell CardEquip Spell Card
Armed Changer (Duel Links)アームド・チェンジャーSpell CardEquip Spell Card
Assault Spiritsアサルト・スピリッツTrap CardNormal Trap Card
Assault Spirits (anime)アサルト・スピリッツTrap CardContinuous Trap Card
Assault Spirits (Duel Links)アサルト・スピリッツTrap CardNormal Trap Card
Atrium's Wind吹（ふ）き抜（ぬ）ける風（かぜ）Spell CardNormal Spell Card
Big Summon Cloud大召喚雲（ビッグサモンクラウド）Spell CardContinuous Spell Card
Big Volcanoビッグ・ヴォルケーノSpell CardNormal Spell Card
Black-Winged Strafeブラックフェザー・シュートSpell CardNormal Spell Card
Black-Winged Strafe (anime)ＢＦ（ブラックフェザー）－シュートSpell CardNormal Spell Card
Black-Winged Strafe (Duel Links)ブラックフェザー・シュートSpell CardNormal Spell Card
Blaze Fiend Assault焔（えん）魔（ま）の強（きょう）襲（しゅう）Spell CardNormal Spell Card
Blessed Winds恵（めぐ）みの風（かぜ）Trap CardContinuous Trap Card
Blessed Winds (Duel Links)恵（めぐ）みの風（かぜ）Trap CardContinuous Trap Card
Break Away決（けつ）別（べつ）Trap CardNormal Trap Card
Break Away (anime)決（けつ）別（べつ）Trap CardNormal Trap Card
Break Away (Duel Links)決（けつ）別（べつ）Trap CardNormal Trap Card
Brilliant Fusion (anime)ブリリアント・フュージョンSpell CardContinuous Spell Card
Brilliant Sparkブリリアント・スパークTrap CardNormal Trap Card
Brilliant Spark (anime)ブリリアント・スパークTrap CardNormal Trap Card
Brilliant Spark (Duel Links)ブリリアント・スパークTrap CardNormal Trap Card
Bujincandescence武（ぶ）神（じん）籬（まがき）Spell CardContinuous Spell Card
Burgeoning Whirlflame炎（えん）渦（か）の胎（たい）動（どう）Trap CardCounter Trap Card
Burgeoning Whirlflame (Duel Links)炎（えん）渦（か）の胎（たい）動（どう）Trap CardCounter Trap Card
Burning Rebirthバーニング・リボーンTrap CardContinuous Trap Card
Card Rotatorカード・フリッパーSpell CardNormal Spell Card
Card Rotator (anime)カード・フリッパーSpell CardNormal Spell Card
Card Rotator (Duel Links)カード・フリッパーSpell CardNormal Spell Card
Cards for Black Feathers (anime)黒（くろ）羽（はね）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Cards of Consonance (anime)調（ちょう）和（わ）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Cards of the Red Stone紅（こう）玉（ぎょく）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Cards of the Red Stone (Duel Links)紅（こう）玉（ぎょく）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Chaos Returnカオス・リターンTrap CardNormal Trap Card
Chaos Space混沌領域（カオス・テリトリー）Spell CardNormal Spell Card
Charis Magic - Elegant Changeカリス・マジック－エレガントチェンジSpell CardNormal Spell Card
Charis Magic - Elegant Change (anime)カリス・マジック－エレガントチェンジSpell CardNormal Spell Card
Chemicalizing Impactケミカライジング・インパクトSpell CardNormal Spell Card
Coin Tech Lucky Rushコインテック・ラッキーラッシュSpell CardNormal Spell Card
Compulsory Recoil Device強（きょう）制（せい）帰（き）還（かん）装（そう）置（ち）Trap CardContinuous Trap Card
Constructor Ambush幻（げん）刃（ば）急（きゅう）攻（こう）Trap CardNormal Trap Card
Constructor Ambush (anime)幻（げん）刃（ば）急（きゅう）攻（こう）Trap CardNormal Trap Card
Constructor Ambush (manga)幻（げん）刃（ば）急（きゅう）攻（こう）Trap CardNormal Trap Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"