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]] [[MonsterSpellTrap::Destroys itself]]
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='556' AND t19.o_id='2072')
  )
  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]]
7７（セブン）Spell CardContinuous Spell Card
Abyss-sphereアビスフィアーTrap CardContinuous Trap Card
Aerial Recharge空中補給（エアリアル・チャージ）Trap CardContinuous Trap Card
Amazoness Willpowerアマゾネスの意（い）地（じ）Trap CardContinuous Trap Card
Battleguard Rageバーバリアン・レイジTrap CardContinuous Trap Card
Big Evolution Pill大（だい）進（しん）化（か）薬（やく）Spell CardNormal Spell Card
Birthright正（せい）統（とう）なる血（けっ）統（とう）Trap CardContinuous Trap Card
Bottomless Shifting Sand底（そこ）なし流（りゅう）砂（さ）Trap CardContinuous Trap Card
Brain HazardブレインハザードTrap CardContinuous Trap Card
Brainwashing Beam洗（せん）脳（のう）光（こう）線（せん）Trap CardContinuous Trap Card
Break! Draw!ブレイク・ドローSpell CardEquip Spell Card
Bubble Blasterバブル・ショットSpell CardEquip Spell Card
Call of the Hauntedリビングデッドの呼（よ）び声（ごえ）Trap CardContinuous Trap Card
Clear Worldクリアー・ワールドSpell CardField Spell Card
Core Reinforcementコアの再（さい）練（れん）成（せい）Trap CardContinuous Trap Card
Crackdown大（おお）捕（と）り物（もの）Trap CardContinuous Trap Card
Cubic Mandala方（ほう）界（かい）曼（まん）荼（だ）羅（ら）Trap CardContinuous Trap Card
Cyber Networkサイバー・ネットワークTrap CardContinuous Trap Card
Dangerous Machine Type-6デンジャラスマシン ＴＹＰＥ（タイプ）－６（シックス）Spell CardContinuous Spell Card
Depth Amuletデプス・アミュレットTrap CardContinuous Trap Card
Different Dimension CapsuleタイムカプセルSpell CardNormal Spell Card
Dimension Guardianディメンション・ガーディアンTrap CardContinuous Trap Card
Dimension Sphinxディメンション・スフィンクスTrap CardContinuous Trap Card
Double Payback倍（ばい）返（がえ）しTrap CardContinuous Trap Card
Dust Barrier砂（さ）塵（じん）の結（けっ）界（かい）Spell CardContinuous Spell Card
Escape from the Dark Dimension闇（やみ）次（じ）元（げん）の解（かい）放（ほう）Trap CardContinuous Trap Card
Fake Trap偽（にせ）物（もの）のわなTrap CardNormal Trap Card
Fiendish Chainデモンズ・チェーンTrap CardContinuous Trap Card
Fighting Spiritファイティング・スピリッツSpell CardEquip Spell Card
Fossil Excavation化（か）石（せき）発（はっ）掘（くつ）Trap CardContinuous Trap Card
Future Fusion未（み）来（らい）融（ゆう）合（ごう）－フューチャー・フュージョンSpell CardContinuous Spell Card
Galaxy Zero銀河零式（ギャラクシー・ゼロ）Spell CardEquip Spell Card
Gladiator Beast's Battle Archfiend Shield剣闘獣（グラディアルビースト）の闘（とう）器（き）デーモンズシールドSpell CardEquip Spell Card
Glorious Illusion閃（せん）光（こう）のイリュージョンTrap CardContinuous Trap Card
Graceful Revivalエンジェル・リフトTrap CardContinuous Trap Card
Hidden Temples of Necrovalleyネクロバレーの祭（さい）殿（でん）Spell CardContinuous Spell Card
Impenetrable Formation鉄（てっ）壁（ぺき）の布（ふ）陣（じん）Spell CardContinuous Spell Card
Iron Cage鉄（てつ）の檻（おり）Spell CardContinuous Spell Card
Iron Core Specimen Lab鋼（こう）核（かく）合（ごう）成（せい）獣（じゅう）研（けん）究（きゅう）所（じょ）Spell CardField Spell Card
Legendary Ebon Steed漆（しっ）黒（こく）の名（めい）馬（ば）Spell CardEquip Spell Card
Limit Reverseリミット・リバースTrap CardContinuous Trap Card
Lucky PunchラッキーパンチTrap CardContinuous Trap Card
Mask of Brutality凶（きょう）暴（ぼう）化（か）の仮（か）面（めん）Spell CardEquip Spell Card
Mask of Dispel魔（ま）力（りょく）無（む）力（りょく）化（か）の仮（か）面（めん）Spell CardContinuous Spell Card
Mass Hypnosis集（しゅう）団（だん）催（さい）眠（みん）Trap CardContinuous Trap Card
MiniaturizeミニチュアライズTrap CardContinuous Trap Card
Miracle Fertilizer増（ぞう）草（そう）剤（ざい）Spell CardContinuous Spell Card
Miraculous Descent奇（き）跡（せき）の光（こう）臨（りん）Trap CardContinuous Trap Card
Mirror of Yata八汰鏡（ヤタノカガミ）Spell CardEquip Spell Card
Mirror Wall銀（ぎん）幕（まく）の鏡壁（ミラーウォール）Trap CardContinuous Trap Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"