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]] [[MonsterSpellTrap::Unaffected by Trap Cards||Unaffected by the opponent's Trap Cards||Unaffected by other card effects||Unaffected by the opponent's card effects]]
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
INNER JOIN
  `t18` AS t18 ON t16.o_id=t18.id) ON t3.s_id=t16.s_id) ON t0.smw_id=t3.s_id
WHERE
  (t3.p_id='596'
   AND (t16.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
1SIMPLEt18ALLPRIMARY4Using temporary; Using filesort
1SIMPLEt16refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t18.id,const12
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t16.s_id1Using where
1SIMPLEt3refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_38ygowiki.t16.s_id,const1Using where; Using index; Distinct
1SIMPLEt5eq_refPRIMARYPRIMARY4ygowiki.t3.o_id1Distinct
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')
  • Temporary table t18
      INSERT IGNORE INTO `t18` (id) VALUES ('5650')
      INSERT IGNORE INTO `t18` (id) VALUES ('75692')
      INSERT IGNORE INTO `t18` (id) VALUES ('51810')
      INSERT IGNORE INTO `t18` (id) VALUES ('107875')
Query Metrics
Query-Size:6
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
Marincess Snow (anime)海晶乙女雪花（マリンセス・スノー）Trap CardNormal Trap Card
Marincess Wave海晶乙女波動（マリンセス・ウェーブ）Trap CardNormal Trap Card
Marincess Wave (anime)海晶乙女波動（マリンセス・ウェーブ）Trap CardNormal Trap Card
Melodious Illusion幻（げん）奏（そう）のイリュージョンTrap CardNormal Trap Card
Melodious Illusion (Duel Links)幻（げん）奏（そう）のイリュージョンTrap CardNormal Trap Card
MetamorformationメタモルＦ（フォーメーション）Spell CardField Spell Card
The Monarchs Awaken帝（てい）王（おう）の凍（とう）志（し）Trap CardNormal Trap Card
The Monarchs Awaken (Duel Links)帝（てい）王（おう）の凍（とう）志（し）Trap CardNormal Trap Card
Overlay Menaceオーバーレイ・メナスTrap CardNormal Trap Card
Qlipper Launch起動する機殻（クリフォートラン）Trap CardNormal Trap Card
Red Reignスカーレッド・レインTrap CardNormal Trap Card
Salamangreat Ringサラマングレイト・ヘイローTrap CardContinuous Trap Card
Sangen Summoning盃（さかずき）満（み）ちる燦（さん）幻（げん）荘（そう）Spell CardField Spell Card
Shiranui Style Success不知火（しらぬい）流（りゅう） 才（さい）華（か）の陣（じん）Trap CardNormal Trap Card
Shutter Layer 2ペルソナ・シャッター・レイヤー２（ツー）Spell CardContinuous Spell Card
Silent Sword Slash沈（ちん）黙（もく）の剣（つるぎ）Spell CardQuick-Play Spell Card
Silent Sword Slash (Duel Links)沈（ちん）黙（もく）の剣（つるぎ）Spell CardQuick-Play Spell Card
Sky Excalibur蒼（そう）空（くう）の覇（は）剣（けん） スカイ・エクスカリバーSpell CardEquip Spell Card
Sky Striker Mecha - Eagle Booster閃（せん）刀（とう）機（き）－イーグルブースターSpell CardQuick-Play Spell Card
Sky Striker Mecha - Eagle Booster (Duel Links)閃（せん）刀（とう）機（き）－イーグルブースターSpell CardQuick-Play Spell Card
Solemn Authority (anime)神（かみ）の威（い）光（こう）Trap CardContinuous Trap Card
Solfachord Formalドレミコード・フォーマルTrap CardCounter Trap Card
Sonic Boom超音速波（ソニック・ブーム）Trap CardNormal Trap Card
Sonic Boom (Duel Links)超音速波（ソニック・ブーム）Trap CardNormal Trap Card
Soul Fist魂を刻む右（エングレイブ・ソウル・ライト）Spell CardEquip Spell Card
Spectral Ice Floe幽（ゆう）鬼（き）の氷（ひょう）塊（かい）Spell CardContinuous Spell Card
Spellbook of Wisdomトーラの魔（ま）導（どう）書（しょ）Spell CardQuick-Play Spell Card
Spellbook of Wisdom (Duel Links)トーラの魔（ま）導（どう）書（しょ）Spell CardQuick-Play Spell Card
Spirit Sword of Sealing死（し）霊（りょう）の封（ふう）印（いん）剣（けん）Spell CardNormal Spell Card
Stand-Off実（じつ）力（りょく）伯（はく）仲（ちゅう）Spell CardNormal Spell Card
Stellarknight Alpha星輝士（ステラナイト）の因（いん）子（し）Spell CardEquip Spell Card
Sylvan Blessing森（しん）羅（ら）の恵（めぐ）みTrap CardNormal Trap Card
Tachyon Spiral Galaxyタキオン・ギャラクシースパイラルTrap CardNormal Trap Card
Trap Charm罠（わな）の護（ご）符（ふ）Spell CardNormal Spell Card
Tyrant's Temper暴（ぼう）君（くん）の威（い）圧（あつ）Trap CardContinuous Trap Card
Tyrant's Temper (Duel Links)暴（ぼう）君（くん）の威（い）圧（あつ）Trap CardContinuous Trap Card
The Ultimate Creature of Destruction強（きょう）靭（じん）！無（む）敵（てき）！最（さい）強（きょう）！Trap CardNormal Trap Card
Vaccinationワクチンの接（せっ）種（しゅ）Spell CardEquip Spell Card
Void Seer煉（れん）獄（ごく）の死（し）徒（と）Spell CardQuick-Play Spell Card
A Wild Monster Appears!青（せい）天（てん）の霹（へき）靂（れき）Spell CardNormal Spell Card
Wings of Silence沈（ちん）黙（もく）の翼（つばさ）Spell CardEquip Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"