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]] [[Misc::Limited activations]]
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='557' AND t19.o_id='1984')
  )
  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
  100
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]]
Necrovalley Templeネクロバレーの神（しん）殿（でん）Trap CardContinuous Trap Card
Ninjitsu Art Notebook隠（おん）密（みつ）忍（にん）法（ぽう）帖（ちょう）Spell CardContinuous Spell Card
Noble Arms - Arfeudutyr聖（せい）剣（けん）アロンダイトSpell CardEquip Spell Card
Noble Arms - Caliburn聖（せい）剣（けん）カリバーンSpell CardEquip Spell Card
Noble Arms of Destiny天（てん）命（めい）の聖（せい）剣（けん）Spell CardEquip Spell Card
Noble Knights of the Round Table円（えん）卓（たく）の聖（せい）騎（き）士（し）Spell CardField Spell Card
Odin's Eyeオーディンの眼（まなこ）Trap CardContinuous Trap Card
Ojama Countryおジャマ・カントリーSpell CardField Spell Card
Omega GogglesΩ（オメガ）メガネSpell CardEquip Spell Card
Ominous Fortunetelling不（ふ）吉（きつ）な占（うらな）いTrap CardContinuous Trap Card
Onikuji鬼（おに）くじTrap CardContinuous Trap Card
Onomatopia希（き）望（ぼう）郷（きょう）－オノマトピア－Spell CardField Spell Card
Orcustrated Coreオルフェゴール・コアTrap CardContinuous Trap Card
Palace of the Elemental Lords霊（れい）神（しん）の聖（せい）殿（でん）Spell CardField Spell Card
Phantom Handハンドレス・フェイクTrap CardContinuous Trap Card
Pitch-Black Power Stone漆（しっ）黒（こく）のパワーストーンTrap CardContinuous Trap Card
Power Converterパワー・コンバーターSpell CardEquip Spell Card
Power Pickaxeパワー・ピカクスSpell CardEquip Spell Card
Predaponicsプレデター・プランターSpell CardContinuous Spell Card
The Prime Monarch真（しん）源（げん）の帝（てい）王（おう）Trap CardContinuous Trap Card
Primordial Soup原（げん）初（しょ）のスープSpell CardContinuous Spell Card
Proton Blast銃砲撃（ガン・キャノン・ショット）Trap CardContinuous Trap Card
Pseudo Space擬（ぎ）似（じ）空（くう）間（かん）Spell CardField Spell Card
PSY-Frame AcceleratorＰＳＹ（サイ）フレーム・アクセラレーターTrap CardContinuous Trap Card
Quarantine検（けん）疫（えき）Spell CardContinuous Spell Card
Rare Metalmorphレアメタル化（か）・魔（ま）法（ほう）反（はん）射（しゃ）装（そう）甲（こう）Trap CardContinuous Trap Card
Rikka Flurries六（りっ）花（か）の風（かざ）花（はな）Spell CardContinuous Spell Card
Roar of the Earthbound Immortal地（じ）縛（ばく）神（しん）の咆（ほう）哮（こう）Trap CardContinuous Trap Card
Ruins of the Divine Dragon Lords巨（きょ）神（しん）竜（りゅう）の遺（い）跡（せき）Spell CardContinuous Spell Card
The Sanctum of Parshathパーシアスの神（しん）域（いき）Spell CardContinuous Spell Card
Scramble!! Scramble!!緊急発進（スクランブル）Spell CardQuick-Play Spell Card
Sea Stealth Attack潜海奇襲（シー・ステルス・アタック）Trap CardContinuous Trap Card
Seal of Wickedness破（は）邪（じゃ）の刻（こく）印（いん）Trap CardContinuous Trap Card
Sealing Ceremony of Katon火（か）遁（とん）封（ふう）印（いん）式（しき）Trap CardContinuous Trap Card
Sealing Ceremony of Mokuton木（もく）遁（とん）封（ふう）印（いん）式（しき）Trap CardContinuous Trap Card
Sealing Ceremony of Raiton雷（らい）遁（とん）封（ふう）印（いん）式（しき）Trap CardContinuous Trap Card
Sealing Ceremony of Suiton水（すい）遁（とん）封（ふう）印（いん）式（しき）Trap CardContinuous Trap Card
Senet SwitchポジションチェンジSpell CardContinuous Spell Card
Senri Eye千（せん）里（り）眼（がん）Spell CardContinuous Spell Card
Shifting Shadowsうごめく影（かげ）Spell CardContinuous Spell Card
Shiranui Style Solemnity不知火（しらぬい）流（りゅう） 伝（でん）承（しょう）の陣（じん）Spell CardContinuous Spell Card
Shiranui Style Synthesis不知火（しらぬい）流（りゅう） 転（てん）生（せい）の陣（じん）Spell CardField Spell Card
Shrine of Mist Valley霞の谷（ミスト・バレー）の祭（さい）壇（だん）Spell CardField Spell Card
Silver Wing白（はく）銀（ぎん）の翼（つばさ）Spell CardEquip Spell Card
Skyscraper 2 - Hero City摩（ま）天（てん）楼（ろう）２－ヒーローシティSpell CardField Spell Card
Spark Breakerスパーク・ブレイカーTrap CardContinuous Trap Card
Spellbook of Lifeネクロの魔（ま）導（どう）書（しょ）Spell CardEquip Spell Card
Spiders' Lair蜘（く）蛛（も）の領（りょう）域（いき）Spell CardContinuous Spell Card
Spirit Burnerスピリット・バーナーSpell CardEquip Spell Card
Spirit Converterスピリット変（へん）換（かん）装（そう）置（ち）Spell CardContinuous Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"