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:Manga non-monsters]] [[Summoning::Special Summons from your Graveyard||Special Summons itself from your Graveyard||Special Summons from your Graveyard to your opponent's field]]
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='555'
   AND (
   (t5.o_hash='Manga') 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
1SIMPLEt23ALLPRIMARY3Using 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 ('1623')
      INSERT IGNORE INTO `t23` (id) VALUES ('2392')
      INSERT IGNORE INTO `t23` (id) VALUES ('49200')
  • 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:5
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
Advent of the Goddess女（め）神（がみ）の降（こう）臨（りん）Trap CardNormal Trap Card
Angel's Tearエンジェル・ティアTrap CardNormal Trap Card
Armament Reincarnation武（ぶ）装（そう）転（てん）生（せい）Spell Card
Atmospheric Regeneration大（たい）気（き）再（さい）生（せい）Trap CardNormal Trap Card
Auguste Dragon's Counterattack反（はん）攻（こう）の竜（りゅう）来（らい）Trap CardNormal Trap Card
Big Hit!ビッグ･ヒット！Trap CardNormal Trap Card
Blackwing - Delta UnionＢＦ（ブラックフェザー）・デルタ・ユニオンTrap Card
Brutal Retribution暴（ぼう）虐（ぎゃく）の報（むく）いTrap CardNormal Trap Card
Call of the Hauntedリビングデッドの呼（よ）び声（ごえ）Trap CardContinuous Trap Card
Call of the Hauntedリビング・デッド（生ける屍）の呼（よ）び声（ごえ）Spell CardContinuous Spell Card
Clinch Rebornクリンチ・リボーンSpell CardQuick-Play Spell Card
Coffin of Dark Resurrection黒（くろ）魔（ま）族（ぞく）復（ふっ）活（かつ）の棺（ひつぎ）Trap CardNormal Trap Card
Contract With the Void煉（れん）獄（ごく）の契（けい）約（やく）Spell Card
The Copyザ☆コピーSpell CardNormal Spell Card
Cosmos Channelling宇（う）宙（ちゅう）との交（こう）信（しん）Spell CardContinuous Spell Card
Cylinder of Chaos Slots円（えん）筒（とう）の混（こん）乱（らん）スロットTrap CardNormal Trap Card
Damaged Mask破（は）損（そん）した仮（か）面（めん）Trap CardNormal Trap Card
Dark RiseダークライズSpell CardNormal Spell Card
Darklord Contact堕（だ）天（てん）使（し）の戒（かい）壇（だん）Spell CardNormal Spell Card
Darklord Descends堕（だ）天（てん）使（し）降（こう）臨（りん）Trap CardNormal Trap Card
Darklord Descent堕（だ）天（てん）使（し）降（こう）臨（りん）Trap CardNormal Trap Card
De-Fusion融（ゆう）合（ごう）解（かい）除（じょ）Spell CardQuick-Play Spell Card
Dragon Enduroドラゴン・エンデューロTrap CardNormal Trap Card
Dragon Spirit Army竜（りゅう）精（せい）軍（ぐん）Trap CardNormal Trap Card
Dragonic Playドラゴニック・プレイSpell CardNormal Spell Card
Dragonic Pressureドラゴニック・プレッシャーSpell CardNormal Spell Card
Dragonic Pressureドラゴニック・プレッシャーSpell CardNormal Spell Card
Endless Bond永（えい）遠（えん）の絆（きずな）Spell CardContinuous Spell Card
Eternal Bondエターナル・ボンドTrap CardNormal Trap Card
Fairy Tale Chapter 3: Evening SunＦａｉｒｙ（フェアリー） Ｔａｌｅ（テイル） 第（だい）三（さん）章（しょう） 黄（たそ）昏（がれ）の夕（ゆう）日（ひ）Spell CardField Spell Card
Frightfur Rebornデストーイ・リニッチSpell Card
Gagaga IllusionガガガイリュージョンSpell CardNormal Spell Card
Galactic Fury銀（ぎん）河（が）の逆（げき）鱗（りん）Trap CardNormal Trap Card
Galactica Riseギャラクティカ・ライズSpell CardNormal Spell Card
Galactica Sparkギャラクティカ・スパークSpell CardNormal Spell Card
Ghostly Reinforcements妖（よう）魔（ま）の援（えん）軍（ぐん）Trap CardNormal Trap Card
Haunted Shrineもののけの巣（す）くう祠（ほこら）Trap CardNormal Trap Card
Hell Summon地獄召喚（ヘル・サモン）Trap Card
Hero's Return英雄（えいゆう）の帰還（きかん）Spell CardNormal Spell Card
Hyper Galaxyハイパー・ギャラクシーSpell CardQuick-Play Spell Card
Illegal Modding違（い）法（ほう）改（かい）造（ぞう）Spell Card
Immortal Dragon不（ふ）死（し）の竜（りゅう）Trap CardNormal Trap Card
Inferno Reckless Summon地（じ）獄（ごく）の暴（ぼう）走（そう）召（しょう）喚（かん）Spell CardQuick-Play Spell Card
Insect Horde昆（こん）虫（ちゅう）の大（たい）群（ぐん）Trap CardNormal Trap Card
Lifeline from the Graveyard墓（ぼ）地（ち）からの命（いのち）綱（づな）Trap CardNormal Trap Card
Line World Revivalラインワールド・リバイバルSpell CardNormal Spell Card
Mathmech Equation斬（ザン）機（キ）方（ホウ）程（テイ）式（シキ）Spell CardNormal Spell Card
Monster Reborn死（し）者（しゃ）蘇（そ）生（せい）Spell CardNormal Spell Card
Monster Reborn死（し）者（しゃ）蘇（そ）生（せい）Spell CardNormal Spell Card
Monster Reborn死（し）者（しゃ）蘇（そ）生（せい）Spell CardNormal Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"