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]] [[Actions::Returns itself from Graveyard 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 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='628' AND t16.o_id='2034')
  )
  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
1SIMPLEt16refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const181Using where; Using temporary; Using filesort
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')
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
 Japanese name[[Card type]][[Property]]
Iron Core of Koa'ki Meiruコアキメイルの鋼（こう）核（かく）Spell CardNormal Spell Card
Iron Core of Koa'ki Meiru (Duel Links)コアキメイルの鋼（こう）核（かく）Spell CardNormal Spell Card
Joker's Straightジョーカーズ・ストレートSpell CardNormal Spell Card
Joker's Wildジョーカーズ・ワイルドTrap CardNormal Trap Card
Karma of the Destruction Swordsman破（は）壊（かい）剣（けん）士（し）の宿（しゅく）命（めい）Spell CardQuick-Play Spell Card
Karma of the Destruction Swordsman (Duel Links)破（は）壊（かい）剣（けん）士（し）の宿（しゅく）命（めい）Spell CardQuick-Play Spell Card
Kozmo LightswordＫｏｚｍｏ（コズモ）－レイブレードSpell CardEquip Spell Card
Loka Samsara世壊輪廻（ローカ・サンサーラ）Trap CardNormal Trap Card
Magical BlastマジックブラストSpell CardNormal Spell Card
Magical Blast (anime)マジックブラストSpell CardNormal Spell Card
Magical Blast (Duel Links)マジックブラストSpell CardNormal Spell Card
Meteonis Drytron流星輝巧群（メテオニス・ドライトロン）Spell CardRitual Spell Card
Meteor Flareメテオ・プロミネンスTrap CardNormal Trap Card
Meteor Flare (anime)メテオ・プロミネンスTrap CardNormal Trap Card
Meteor Flare (Duel Links)メテオ・プロミネンスTrap CardNormal Trap Card
The Most Distant, Deepest Depths最（さい）果（は）ての宇宙（うみ）Spell CardField Spell Card
Orb of Yasaka八尺勾玉（ヤサカノマガタマ）Spell CardEquip Spell Card
Orb of Yasaka (Duel Links)八尺勾玉（ヤサカノマガタマ）Spell CardEquip Spell Card
Orcustrated Babelオルフェゴール・バベルSpell CardField Spell Card
Phoenix Gearbladeフェニックス・ギア・ブレードSpell CardEquip Spell Card
Rank-Up-Magic Argent Chaos ForceＲＵＭ（ランクアップマジック）－アージェント・カオス・フォースSpell CardNormal Spell Card
Rank-Up-Magic Argent Chaos Force (Duel Links)ＲＵＭ（ランクアップマジック）－アージェント・カオス・フォースSpell CardNormal Spell Card
Rank-Up-Magic Astral ForceＲＵＭ（ランクアップマジック）－アストラル・フォースSpell CardNormal Spell Card
Rank-Up-Magic Astral Force (anime)ＲＵＭ（ランクアップマジック）－アストラル・フォースSpell CardNormal Spell Card
Rank-Up-Magic Astral Force (D Team)ＲＵＭ（ランクアップマジック）－アストラル・フォースSpell CardNormal Spell Card
Recycle BarrierリサイクルバリアTrap CardNormal Trap Card
Red Reignスカーレッド・レインTrap CardNormal Trap Card
Ruins of the Divine Dragon Lords巨（きょ）神（しん）竜（りゅう）の遺（い）跡（せき）Spell CardContinuous Spell Card
Ruins of the Divine Dragon Lords (Duel Links)巨（きょ）神（しん）竜（りゅう）の遺（い）跡（せき）Spell CardContinuous Spell Card
Scab Blastスカブ・ブラストSpell CardNormal Spell Card
Shade of Stringsストリングス・シェードTrap CardNormal Trap Card
Sharv Sarga新世廻（シャルヴ・サルガ）Trap CardNormal Trap Card
Spirit Burnerスピリット・バーナーSpell CardEquip Spell Card
Spirit Burner (anime)スピリット・バーナーSpell CardEquip Spell Card
Spirit Burner (Duel Links)スピリット・バーナーSpell CardEquip Spell Card
Spirit Contamination精（せい）神（しん）汚（お）染（せん）Spell CardNormal Spell Card
Sword of Dark Ritesサクリファイス・ソードSpell CardEquip Spell Card
Sword of Dark Rites (Duel Links)サクリファイス・ソードSpell CardEquip Spell Card
Sword of Kusanagi草薙剣（クサナギノツルギ）Spell CardEquip Spell Card
Sword of Kusanagi (Duel Links)草薙剣（クサナギノツルギ）Spell CardEquip Spell Card
Swordsoul Punishment赫（かく）聖（せい）の相（そう）剣（けん）Spell CardNormal Spell Card
Tally-ho! Springansタリホー！スプリガンズ！Spell CardQuick-Play Spell Card
Telekinetic Charging Cell念（ねん）動（どう）増（ぞう）幅（ふく）装（そう）置（ち）Spell CardEquip Spell Card
Telekinetic Charging Cell (Duel Links)念（ねん）動（どう）増（ぞう）幅（ふく）装（そう）置（ち）Spell CardEquip Spell Card
U.A. Powered JerseyＵ．Ａ．（ウルトラアスリート）パワードギプスSpell CardEquip Spell Card
U.A. Powered Jersey (Duel Links)Ｕ．Ａ．（ウルトラアスリート）パワードギプスSpell CardEquip Spell Card
Witchcrafter Collaborationウィッチクラフト・コラボレーションSpell CardNormal Spell Card
Witchcrafter Collaboration (Duel Links)ウィッチクラフト・コラボレーションSpell CardNormal Spell Card
Witchcrafter Confusion Confessionウィッチクラフト・コンフュージョンSpell CardNormal Spell Card
Witchcrafter Creationウィッチクラフト・クリエイションSpell CardNormal Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"