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
[[Release::Yu-Gi-Oh! Duel Links]] [[Concept:Non-monster cards]] [[Actions::Adds from Deck to hand]]
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 t2
INNER JOIN
  (`smw_di_wikipage` AS t6
INNER JOIN
  `t8` AS t8 ON t6.o_id=t8.id) ON t2.s_id=t6.s_id
INNER JOIN
  `smw_di_wikipage` AS t19 ON t2.s_id=t19.s_id) ON t0.smw_id=t2.s_id
WHERE
  (t2.p_id='1149' AND t2.o_id='46579'
   AND (t6.p_id='596')
   AND (t19.p_id='628' AND t19.o_id='3258')
  )
  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
1SIMPLEt8ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt6refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t8.id,const12
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t6.s_id1Using where
1SIMPLEt19refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t6.s_id,const,const1Using index; Distinct
1SIMPLEt2refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t6.s_id,const,const1Using index; Distinct
Auxilliary Tables
  • Temporary table t8
      INSERT IGNORE INTO `t8` (id) VALUES ('1329')
      INSERT IGNORE INTO `t8` (id) VALUES ('1787')
      INSERT IGNORE INTO `t8` (id) VALUES ('87260')
      INSERT IGNORE INTO `t8` (id) VALUES ('70265')
      INSERT IGNORE INTO `t8` (id) VALUES ('2881')
      INSERT IGNORE INTO `t8` (id) VALUES ('77217')
      INSERT IGNORE INTO `t8` (id) VALUES ('769993')
      INSERT IGNORE INTO `t8` (id) VALUES ('72320')
      INSERT IGNORE INTO `t8` (id) VALUES ('0')
      INSERT IGNORE INTO `t8` (id) VALUES ('38099')
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
"A" Cell Recombination Device「Ａ（エー）」細（さい）胞（ぼう）組（く）み換（か）え装（そう）置（ち）Spell CardQuick-Play Spell Card
Abyss Script - Rise of the Abyss King魔（ま）界（かい）台（だい）本（ほん）「魔（ま）王（おう）の降（こう）臨（りん）」Spell CardNormal Spell Card
Armory Callアームズ・コールTrap CardNormal Trap Card
Augmented Heraldry昇華する紋章（オーグメント・メダリオン）Spell CardField Spell Card
Banishment of the Darklords堕（だ）天（てん）使（し）の追（つい）放（ほう）Spell CardNormal Spell Card
Beginning of Heaven and Earth天（てん）地（ち）開（かい）闢（びゃく）Trap CardNormal Trap Card
Bingo Machine, Go!!!ビンゴマシーンＧＯ（ゴー）！ＧＯ（ゴー）！Spell CardNormal Spell Card
Black Whirlwind黒（くろ）い旋（せん）風（ぷう）Spell CardContinuous Spell Card
Bonding - DHOボンディング－Ｄ（ディー）Ｈ（エイチ）Ｏ（オー）Trap CardNormal Trap Card
Bujinunity武（ぶ）神（じん）集（しゅう）結（けつ）Spell CardNormal Spell Card
Card of the Soul魂（たましい）のカードSpell CardNormal Spell Card
Chaos Zone混沌空間（カオス・ゾーン）Spell CardField Spell Card
Charge of the Light Brigade光（ひかり）の援（えん）軍（ぐん）Spell CardNormal Spell Card
Chronomaly Technology先史遺産技術（オーパーツテクノロジー）Spell CardNormal Spell Card
Core Transport Unitコア転（てん）送（そう）ユニットSpell CardContinuous Spell Card
Creeping Darkness忍（しの）び寄（よ）る闇（やみ）Spell CardNormal Spell Card
Cross Breedクロス・ブリードSpell CardNormal Spell Card
Crystal Bond宝（ほう）玉（ぎょく）の絆（きずな）Spell CardNormal Spell Card
Cubic Karma方（ほう）界（かい）業（カルマ）Spell CardContinuous Spell Card
Cursed Bamboo Sword妖（よう）刀（とう）竹（たけ）光（みつ）Spell CardEquip Spell Card
Cyber Emergencyエマージェンシー・サイバーSpell CardNormal Spell Card
Cyber Repair Plantサイバー・リペア・プラントSpell CardNormal Spell Card
Cyberdark Infernoサイバーダーク・インフェルノSpell CardField Spell Card
Cybernetic Overflowサイバネティック・オーバーフローTrap CardNormal Trap Card
Cyberse Beaconサイバース・ビーコンTrap CardNormal Trap Card
Cycle of the Worldエンドレス・オブ・ザ・ワールドSpell CardRitual Spell Card
D - FormationＤ（ディー）－フォーメーションSpell CardContinuous Spell Card
D - TimeＤ（ディー）－タイムTrap CardNormal Trap Card
D/D/D Contract ChangeＤ（ディー）Ｄ（ディー）Ｄ（ディー）の契（けい）約（やく）変（へん）更（こう）Trap CardNormal Trap Card
D/D/D Human ResourcesＤ（ディー）Ｄ（ディー）Ｄ（ディー）の人（じん）事（じ）権（けん）Trap CardNormal Trap Card
Dark Contract with the Gate地（じ）獄（ごく）門（もん）の契（けい）約（やく）書（しょ）Spell CardContinuous Spell Card
Dark Dragon Ritual黒（こく）竜（りゅう）降（こう）臨（りん）Spell CardRitual Spell Card
Dark Magic Inheritance黒（くろ）魔（ま）術（じゅつ）の継（けい）承（しょう）Spell CardQuick-Play Spell Card
Dark Magical Circle黒（くろ）の魔（ま）導（どう）陣（じん）Spell CardContinuous Spell Card
Diamond Core of Koa'ki Meiruコアキメイルの金（こん）剛（ごう）核（かく）Spell CardNormal Spell Card
Diced Dice賽（さい）挑（ちょう）戦（せん）Spell CardQuick-Play Spell Card
Dinomist Chargeダイナミスト・チャージSpell CardContinuous Spell Card
Draconnection竜（りゅう）の交（こう）感（かん）Spell CardNormal Spell Card
E - Emergency CallＥ（イー）－エマージェンシーコールSpell CardNormal Spell Card
Earthbound Geoglyph地（じ）縛（ばく）地（ち）上（じょう）絵（え）Spell CardField Spell Card
Emblem of Dragon Destroyer竜（りゅう）破（は）壊（かい）の証（あかし）Spell CardNormal Spell Card
Eternal Soul永（えい）遠（えん）の魂（たましい）Trap CardContinuous Trap Card
Evil Eye Domain - Pareidolia呪（じゅ）眼（がん）領（りょう）閾（いき）－パレイドリア－Spell CardField Spell Card
Evil Eye of Gorgoneioゴルゴネイオの呪（じゅ）眼（がん）Spell CardEquip Spell Card
Evo-Diversity多（た）様（よう）進（しん）化（か）Spell CardNormal Spell Card
F.A. Circuit Grand PrixＦ．Ａ．（フォーミュラアスリート）サーキットＧＰ（グランプリ）Spell CardField Spell Card
F.A. Off-Road Grand PrixＦ．Ａ．（フォーミュラアスリート）オフロードＧＰ（グランプリ）Spell CardField Spell Card
Fire Formation - Tenki炎（えん）舞（ぶ）－「天（テン）璣（キ）」Spell CardContinuous Spell Card
Fire King Island炎（えん）王（おう）の孤（こ）島（とう）Spell CardField Spell Card
First-Aid Squad救（きゅう）護（ご）部（ぶ）隊（たい）Trap CardNormal Trap Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"