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:Anime non-monsters]] [[Stats::Changes ATK value||Changes ATK value of equipped||Changes own ATK value||Reduces ATK to 0||Restores original ATK value]]
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 t21
INNER JOIN
  `t23` AS t23 ON t21.o_id=t23.id
INNER JOIN
  (`smw_di_blob` AS t5
INNER JOIN
  (`smw_di_wikipage` AS t8
INNER JOIN
  `t10` AS t10 ON t8.o_id=t10.id) ON t5.s_id=t8.s_id) ON t21.s_id=t5.s_id) ON t0.smw_id=t21.s_id
WHERE
  (t21.p_id='629'
   AND (
   (t5.o_hash='Anime') AND t5.p_id='599'
   AND (t8.p_id='596')
  ))
  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
1SIMPLEt23ALLPRIMARY5Using temporary; Using filesort
1SIMPLEt21refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t23.id,const12
1SIMPLEt5refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t21.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t21.s_id1Using where
1SIMPLEt8refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_38ygowiki.t21.s_id,const1Using where; Using index; Distinct
1SIMPLEt10eq_refPRIMARYPRIMARY4ygowiki.t8.o_id1Distinct
Auxilliary Tables
  • Temporary table t23
      INSERT IGNORE INTO `t23` (id) VALUES ('11959')
      INSERT IGNORE INTO `t23` (id) VALUES ('9274')
      INSERT IGNORE INTO `t23` (id) VALUES ('3413')
      INSERT IGNORE INTO `t23` (id) VALUES ('1541')
      INSERT IGNORE INTO `t23` (id) VALUES ('258884')
  • Temporary table t10
      INSERT IGNORE INTO `t10` (id) VALUES ('1329')
      INSERT IGNORE INTO `t10` (id) VALUES ('1787')
      INSERT IGNORE INTO `t10` (id) VALUES ('87260')
      INSERT IGNORE INTO `t10` (id) VALUES ('70265')
      INSERT IGNORE INTO `t10` (id) VALUES ('2881')
      INSERT IGNORE INTO `t10` (id) VALUES ('77217')
      INSERT IGNORE INTO `t10` (id) VALUES ('769993')
      INSERT IGNORE INTO `t10` (id) VALUES ('72320')
      INSERT IGNORE INTO `t10` (id) VALUES ('0')
      INSERT IGNORE INTO `t10` (id) VALUES ('38099')
Query Metrics
Query-Size:7
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
Fairy BoxモンスターＢＯＸ（ボックス）Trap CardContinuous Trap Card
Fairy Railフェアリー・レイルTrap CardNormal Trap Card
Fiend's Sanctuaryデビルズ・サンクチュアリSpell CardQuick-Play Spell Card
Fife and Drum Corps鼓（こ）笛（てき）隊（たい）Spell CardNormal Spell Card
Fighter's Charm戦士の誘惑（ファイターズ・チャーム）Spell CardNormal Spell Card
Freezing Point絶（ぜっ）対（たい）零（れい）度（ど）Spell CardQuick-Play Spell Card
Gagaga Mirror Slashガガガ流（りゅう）－明（めい）鏡（きょう）死（し）斬（ざん）Spell CardQuick-Play Spell Card
Galaxy Zero銀河零式（ギャラクシー・ゼロ）Spell CardEquip Spell Card
GamusharushガムシャラッシュSpell CardQuick-Play Spell Card
Gestalt Trapゲシュタルト・トラップTrap CardContinuous Trap Card
Gimmick Boxギミック・ボックスTrap CardContinuous Trap Card
Gladiator Beast's Great Fortress剣闘獣の大砦（グラディアルビースト・グレート・フォートレス）Spell CardContinuous Spell Card
Goddess Bow女（め）神（がみ）の聖（せい）弓（きゅう）－アルテミスSpell CardEquip Spell Card
The Golden ApplesフリッグのリンゴTrap CardNormal Trap Card
Gottoms' Second Callガトムズの非（ひ）常（じょう）召（しょう）集（しゅう）Spell CardNormal Spell Card
Graveyard Incubation墓（ぼ）地（ち）培（ばい）養（よう）Spell CardNormal Spell Card
Gravity Balance重力均衡（グラヴィティ・バランス）Spell CardNormal Spell Card
HardshipハードシップTrap CardContinuous Trap Card
Heroic Advanceヒロイック・アドバンスTrap CardNormal Trap Card
Heroic Chanceヒロイック・チャンスSpell CardNormal Spell Card
Hologram Projectionホログラム・プロジェクションSpell CardContinuous Spell Card
Hydradrive Cycleハイドライブ・サイクルTrap CardContinuous Trap Card
Ice Fire Egg氷炎の卵（オーバル・アイス・ファイヤー）Trap CardNormal Trap Card
Instant Shutterペルソナ・シャッター－インスタントTrap CardNormal Trap Card
Joyful Doom歓喜の断末魔Trap CardNormal Trap Card
Judgment Arrows裁きの矢（ジャッジメント・アローズ）Spell CardLink Spell Card
Judgment Arrows裁きの矢（ジャッジメント・アローズ）Spell CardLink Spell Card
Judgment Roll裁きの賽渦（ジャッジメント・ロール）Trap CardContinuous Trap Card
Krystal Avatarクリスタル・アバターTrap CardContinuous Trap Card
Last Counterラスト・カウンターTrap CardCounter Trap Card
Limiter Removalリミッター解（かい）除（じょ）Spell CardQuick-Play Spell Card
Link Surge Counterリンク・サージ・カウンターTrap CardNormal Trap Card
Lost Wind迷（まよ）い風（かぜ）Trap CardNormal Trap Card
Magicians Uniteマジシャンズ・クロスSpell CardQuick-Play Spell Card
Martyr Flag殉（じゅん）教（きょう）者（しゃ）の旗（はた）Trap CardNormal Trap Card
Megamorph巨（きょ）大（だい）化（か）Spell CardEquip Spell Card
Message in a Bottle未（み）来（らい）への思（おも）いSpell CardNormal Spell Card
Micron Forceマイクロン・フォースTrap CardContinuous Trap Card
Mini-Gutsミニマム・ガッツSpell CardNormal Spell Card
Mirror Mail聖（せい）なる鎧（よろい）－ミラーメール－Trap CardNormal Trap Card
Mirror Stage of Discipline規（き）律（りつ）の鏡（かがみ）舞（ぶ）台（たい）Spell CardContinuous Spell Card
Mokey Mokey Smackdown怒（いか）れるもけもけSpell CardContinuous Spell Card
Morphtronic EngineＤ（ディフォーマー）・パワーユニットSpell CardEquip Spell Card
Negative Energy闇（やみ）・エナジーSpell CardNormal Spell Card
Neos Spiral Forceネオス・スパイラル・フォースTrap CardNormal Trap Card
Nihilistic Summoning Technique虚（きょ）無（む）の召（しょう）喚（かん）術（じゅつ）Trap CardContinuous Trap Card
Nonexistence虚（きょ）無（む）械（かい）アインTrap CardContinuous Trap Card
Nordic Relic Brisingamen極（きょく）星（せい）宝（ほう）ブリージンガ・メンTrap CardNormal Trap Card
Over the Redオーバー・ザ・レッドTrap CardNormal Trap Card
Overlay Rebornオーバーレイ・ドロップ・リボーンSpell CardNormal Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"