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::Your opponent's monsters lose ATK]]
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
  (`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 t21.o_id='1475'
   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
  0
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt10ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt8refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t10.id,const12
1SIMPLEt5refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t8.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t8.s_id1Using where
1SIMPLEt21refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t8.s_id,const,const1Using index; Distinct
Auxilliary Tables
  • 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:3
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
Abyss Maxibubbleアビス・マキシバブルTrap CardNormal Trap Card
Abysskite Ray Monochromeアビスカイト・レイ・モノクロームTrap CardNormal Trap Card
Amazon Archersアマゾネスの弩（ど）弓（きゅう）隊（たい）Trap CardNormal Trap Card
Amazoness Archersアマゾネスの弩（ど）弓（きゅう）隊（たい）Trap CardNormal Trap Card
Amusi Cheerアミュージー・チアSpell CardNormal Spell Card
Armor Ninjitsu Art of Rust Mist機（き）甲（こう）忍（にん）法（ぽう）ラスト・ミストTrap CardContinuous Trap Card
Asura Dice阿（あ）修（しゅ）羅（ラ）のサイコロTrap CardNormal Trap Card
Attrition消（しょう）耗（もう）戦（せん）Spell CardContinuous Spell Card
Ayers Rock Sunriseエアーズロック・サンライズSpell CardNormal Spell Card
Bait Bite Ballキラー・バイトボールTrap CardNormal Trap Card
The Barrierザ☆バリアTrap CardNormal Trap Card
Battle Simulation模擬戦闘（バトル・シミュレーション）Trap CardNormal Trap Card
Battle Waltz武闘円舞（バトルワルツ）Spell CardNormal Spell Card
Beastborg Medal of the Steel Chain鉄（てっ）鎖（さ）の獣（じゅう）闘（とう）機（き）勲（くん）章（しょう）Trap CardContinuous Trap Card
Bizarrmor奇（き）装（そう）天（てん）鎧（がい）Spell CardNormal Spell Card
Bleach Mortar白（はく）激（げき）泡（ほう）－ブリーチ・モーターSpell CardNormal Spell Card
Borrel Ringロシアン・ヴァレルTrap CardContinuous Trap Card
Burden of the Mighty強（きょう）者（しゃ）の苦（く）痛（つう）Spell CardContinuous Spell Card
Camouflage Sword擬（ぎ）態（たい）の迷（めい）彩（さい）剣（けん）Spell CardNormal Spell Card
Caught in the Rain雨（あめ）に打（う）たれればSpell CardNormal Spell Card
Celeb Brace - Death Wiseセレブレス・デスワイズSpell CardEquip Spell Card
Chain Arrowチェーン・アローTrap CardNormal Trap Card
Chain of the Underworld冥（めい）界（かい）の鎖（くさり）Trap CardNormal Trap Card
Chemicalize Devil Burstケミカライズ・デビルバーストSpell CardNormal Spell Card
Clockwork Night機（き）械（かい）仕（じ）掛（か）けの夜（よる）－クロック・ワーク・ナイト－Spell CardContinuous Spell Card
Constructor Ambush幻（げん）刃（ば）急（きゅう）攻（こう）Trap CardNormal Trap Card
Constructor Art - Buildestruction幻（げん）刃（ば）奥（おう）義（ぎ）－突（とっ）陥（かん）攻（こう）事（じ）Spell CardNormal Spell Card
Counter Pigeonsカウンター・ハートTrap CardNormal Trap Card
Counter Shieldカウンター・シールドTrap CardNormal Trap Card
Curtain of Sparks火（ひ）の粉（こ）のカーテンTrap CardNormal Trap Card
Cut Jewel宝（ほう）玉（ぎょく）割（かつ）断（だん）Trap CardNormal Trap Card
D-Doom DanceＤ（ディー）－デビル・ダンスTrap CardNormal Trap Card
Damage Lanceダメージ・ランスTrap CardNormal Trap Card
Darkness Disorderダークネス・ディスオーダーTrap CardNormal Trap Card
Darkness Divineダークネス・ディバインSpell CardNormal Spell Card
Deceitful Dark Contract with the War Deity戦（せん）神（じん）との不（ふ）正（せい）契（けい）約（やく）書（しょ）Spell CardContinuous Spell Card
Desperate Maneuverデスパレート・スクレイプSpell CardNormal Spell Card
Destruction Flower破（は）滅（めつ）の花（はな）Spell CardContinuous Spell Card
Destructurtle MeteorレッカメテオSpell CardNormal Spell Card
Dice Dungeonダイス・ダンジョンSpell CardField Spell Card
Djinn Orchestra魔（ま）人（じん）オーケストラSpell CardNormal Spell Card
Download Dragonダウンロー・ドラゴンSpell CardNormal Spell Card
Drag-on-Dropドラッグ・オン・ドロップSpell CardNormal Spell Card
Dragon Breakドラゴン・ブレイクTrap CardNormal Trap Card
Dragon Dance神龍演武（ドラゴンダンス）Trap CardNormal Trap Card
Dragon's Burst Fusionドラゴンズ・バースト・フュージョンSpell CardNormal Spell Card
Dragon's Fortitude竜（りゅう）の執（しゅう）念（ねん）Trap CardNormal Trap Card
Dragonic Giasドラゴニック・ギアスSpell CardNormal Spell Card
Dralight Formatドライト・フォーマットTrap CardNormal Trap Card
Dramatic Pose大（おお）見（み）得（え）Spell CardNormal Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"