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]] [[Stats::Your monsters gain DEF]]
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='629' AND t16.o_id='2874')
  )
  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
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]]
Fairy Breathフェアリー・ブレスTrap CardCounter Trap Card
Falloutフォール・アウトSpell CardNormal Spell Card
Fire Prison (anime)天（てん）火（ぴ）の牢（ろう）獄（ごく）Spell CardField Spell Card
Full MoonフルムーンSpell CardNormal Spell Card
Galactica Latticeギャラクティカ・ラティスTrap CardNormal Trap Card
Galactica Lattice (anime)ギャラクティカ・ラティスTrap CardNormal Trap Card
Galactica Lattice (LP)ギャラクティカ・ラティスTrap CardNormal Trap Card
Golden Gearbox黄（おう）金（ごん）の歯（は）車（ぐるま）装（そう）置（ち）箱（ばこ）Spell CardQuick-Play Spell Card
Golden Gearbox (Duel Links)黄（おう）金（ごん）の歯（は）車（ぐるま）装（そう）置（ち）箱（ばこ）Spell CardQuick-Play Spell Card
Graceful Dice天（てん）使（し）のサイコロSpell CardQuick-Play Spell Card
Graceful Dice (anime Rush Duel)天（てん）使（し）のサイコロSpell CardNormal Spell Card
Graceful Dice (Duel Links)天（てん）使（し）のサイコロSpell CardQuick-Play Spell Card
Graceful Dice (Rush Duel)天（てん）使（し）のサイコロSpell CardNormal Spell Card
Gravity Vision重力幻影（グラヴィティ・ヴィジョン）Trap CardNormal Trap Card
Guard ChangeガードチェンジSpell Card
Guard PlusガードプラスSpell CardNormal Spell Card
Guardragon Shield守（しゅ）護（ご）竜（りゅう）の結（けっ）界（かい）Spell CardField Spell Card
Impenetrable Formation鉄（てっ）壁（ぺき）の布（ふ）陣（じん）Spell CardContinuous Spell Card
Impenetrable Formation (Duel Links)鉄（てっ）壁（ぺき）の布（ふ）陣（じん）Spell CardContinuous Spell Card
Karma of the Destruction Swordsman破（は）壊（かい）剣（けん）士（し）の宿（しゅく）命（めい）Spell CardQuick-Play Spell Card
Karma of the Destruction Swordsman (Duel Links)破（は）壊（かい）剣（けん）士（し）の宿（しゅく）命（めい）Spell CardQuick-Play Spell Card
Light of the Master主（しゅ）からの光（ひかり）Spell CardQuick-Play Spell Card
Magical Shift Boxマジカル・シフトボックスTrap CardNormal Trap Card
Magnificent Machine Angel荘（そう）厳（ごん）なる機（き）械（かい）天（てん）使（し）Spell CardQuick-Play Spell Card
Magnificent Machine Angel (Duel Links)荘（そう）厳（ごん）なる機（き）械（かい）天（てん）使（し）Spell CardQuick-Play Spell Card
Majespecter Sonicsマジェスペクター・ソニックSpell CardQuick-Play Spell Card
Majespecter Sonics (Duel Links)マジェスペクター・ソニックSpell CardQuick-Play Spell Card
Medicine Eater薬（やく）食（ぐ）いSpell Card
Metalmorph (manga)メタル化（か）・魔（ま）法（ほう）反（はん）射（しゃ）装（そう）甲（こう）Trap CardEquip Trap Card
MetamorformationメタモルＦ（フォーメーション）Spell CardField Spell Card
Midnight Ferocious Thiefミッドナイト・タケダケシーフTrap CardNormal Trap Card
Miracle Stone開（かい）運（うん）ミラクルストーンSpell CardContinuous Spell Card
Miracle Stone (Duel Links)開（かい）運（うん）ミラクルストーンSpell CardContinuous Spell Card
NananaナナナSpell CardNormal Spell Card
Onomatopia希（き）望（ぼう）郷（きょう）－オノマトピア－Spell CardField Spell Card
Onomatopia (Duel Links)希（き）望（ぼう）郷（きょう）－オノマトピア－Spell CardField Spell Card
Overwindオーバー・レンチTrap CardNormal Trap Card
Overwind (Duel Links)オーバー・レンチTrap CardNormal Trap Card
Palace of the Elemental Lords霊（れい）神（しん）の聖（せい）殿（でん）Spell CardField Spell Card
Palace of the Elemental Lords (Duel Links)霊（れい）神（しん）の聖（せい）殿（でん）Spell CardField Spell Card
Paleozoic Eldoniaバージェストマ・エルドニアTrap CardNormal Trap Card
Paleozoic Eldonia (Duel Links)バージェストマ・エルドニアTrap CardNormal Trap Card
The Phantom Knights of Shadow Veil幻影騎士団（ファントム・ナイツ）シャドーベイルTrap CardNormal Trap Card
The Phantom Knights of Shadow Veil (anime)幻影騎士団（ファントム・ナイツ）シャドーベイルSpell CardNormal Spell Card
The Power Upザ☆パワーアップSpell CardNormal Spell Card
The Power Up (anime)ザ☆パワーアップSpell CardNormal Spell Card
The Power Up (LP)ザ☆パワーアップSpell CardNormal Spell Card
Powerful Rebirth強（きょう）化（か）蘇（そ）生（せい）Trap CardContinuous Trap Card
Powerful Rebirth (Duel Links)強（きょう）化（か）蘇（そ）生（せい）Trap CardContinuous Trap Card
Pressured Planet Wraitsoth六（む）世（せ）壊（かい）＝パライゾスSpell CardField Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"