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:Duel Links non-monsters]] [[Stats::Your monsters gain ATK]]
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 t25
INNER JOIN
  (`smw_di_wikipage` AS t12
INNER JOIN
  `t14` AS t14 ON t12.o_id=t14.id
INNER JOIN
  (`smw_di_wikipage` AS t6
INNER JOIN
  `smw_di_blob` AS t9 ON t6.s_id=t9.s_id) ON t12.s_id=t6.s_id) ON t25.s_id=t12.s_id) ON t0.smw_id=t25.s_id
WHERE
  (t25.p_id='629' AND t25.o_id='2873'
   AND (t12.p_id='596'
   AND (t6.p_id='1149' AND t6.o_id='46579'
   AND (
   (t9.o_hash='Card page') AND t9.p_id='880')
  ))
  )
  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
1SIMPLEt14ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt12refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t14.id,const12
1SIMPLEt9refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t12.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t12.s_id1Using where
1SIMPLEt25refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t12.s_id,const,const1Using index; Distinct
1SIMPLEt6refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t12.s_id,const,const1Using index; Distinct
Auxilliary Tables
  • Temporary table t14
      INSERT IGNORE INTO `t14` (id) VALUES ('1329')
      INSERT IGNORE INTO `t14` (id) VALUES ('1787')
      INSERT IGNORE INTO `t14` (id) VALUES ('87260')
      INSERT IGNORE INTO `t14` (id) VALUES ('70265')
      INSERT IGNORE INTO `t14` (id) VALUES ('2881')
      INSERT IGNORE INTO `t14` (id) VALUES ('77217')
      INSERT IGNORE INTO `t14` (id) VALUES ('769993')
      INSERT IGNORE INTO `t14` (id) VALUES ('72320')
      INSERT IGNORE INTO `t14` (id) VALUES ('0')
      INSERT IGNORE INTO `t14` (id) VALUES ('38099')
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
The A. Forces連（れん）合（ごう）軍（ぐん）Spell CardContinuous Spell Card
Abyss-scornアビスコーンTrap CardNormal Trap Card
Amazoness Fighting Spiritアマゾネスの闘（とう）志（し）Spell CardContinuous Spell Card
Amazoness Onslaughtアマゾネスの急（きゅう）襲（しゅう）Trap CardContinuous Trap Card
Ancient Gear Reborn古代の機械蘇生（アンティーク・ギアリボーン）Trap CardContinuous Trap Card
Aqua Chorusアクアの合（がっ）唱（しょう）Trap CardContinuous Trap Card
Aqua Jetアクア・ジェットSpell CardNormal Spell Card
Aquarium Lighting水照明（アクアリウム・ライティング）Spell CardContinuous Spell Card
Aquarium Set水舞台装置（アクアリウム・セット）Spell CardContinuous Spell Card
Archfiend Palabyrinth伏魔殿（デーモンパレス）－悪（あく）魔（ま）の迷（めい）宮（きゅう）－Spell CardField Spell Card
Aroma GardenアロマガーデンSpell CardField Spell Card
Attack Forceアタック・フォースSpell CardNormal Spell Card
Awakening of Nephthysネフティスの覚（かく）醒（せい）Trap CardContinuous Trap Card
Back-Up Rider一（いっ）騎（き）加（か）勢（せい）Spell CardNormal Spell Card
Banner of Courage勇（ゆう）気（き）の旗（はた）印（じるし）Spell CardContinuous Spell Card
Battle Fusion決（けっ）闘（とう）融（ゆう）合（ごう）－バトル・フュージョンSpell CardQuick-Play Spell Card
Battle TunedイージーチューニングSpell CardQuick-Play Spell Card
Battleguard Rageバーバリアン・レイジTrap CardContinuous Trap Card
Beast RageビーストレイジSpell CardNormal Spell Card
Beast RisingビーストライザーTrap CardContinuous Trap Card
Berserk Scales蛮勇鱗粉（バーサーク・スケールス）Spell CardQuick-Play Spell Card
BerserkingバーサーキングTrap CardContinuous Trap Card
The Big March of Animals百（ひゃく）獣（じゅう）大（だい）行（こう）進（しん）Spell CardQuick-Play Spell Card
Blackwing - BombardmentＢＦ（ブラックフェザー）－アンカーTrap CardNormal Trap Card
Blind Spot Strike死（し）角（かく）からの一（いち）撃（げき）Spell CardQuick-Play Spell Card
Blustering Winds破（は）天（てん）荒（こう）な風（かぜ）Spell CardNormal Spell Card
Bug Matrix光虫基盤（バグ・マトリックス）Spell CardField Spell Card
Castle of Dragon Souls竜（りゅう）魂（こん）の城（しろ）Trap CardContinuous Trap Card
Celestial Sword - Eatos女（め）神（がみ）の聖（せい）剣（けん）－エアトスSpell CardEquip Spell Card
Chronomaly Pyramid Eye Tablet先史遺産（オーパーツ）－ピラミッド・アイ・タブレットSpell CardContinuous Spell Card
Closed Forestクローザー・フォレストSpell CardField Spell Card
Common Soul魂（たましい）の共（きょう）有（ゆう）－コモンソウルSpell CardContinuous Spell Card
Concentrating CurrentコンセントレイトSpell CardQuick-Play Spell Card
Core Overclockオーバー・コアリミットSpell CardContinuous Spell Card
Covering Fire援（えん）護（ご）射（しゃ）撃（げき）Trap CardNormal Trap Card
Crystal Release宝（ほう）玉（ぎょく）の解（かい）放（ほう）Spell CardEquip Spell Card
Crystolic PotentialクリスタルＰ（ポテンシャル）Spell CardField Spell Card
Cubic Karma方（ほう）界（かい）業（カルマ）Spell CardContinuous Spell Card
Cubic Wave方（ほう）界（かい）波（は）動（どう）Spell CardNormal Spell Card
Cybernetic Zoneサイバネティック・ゾーンSpell CardQuick-Play Spell Card
Dark Cityダーク・シティSpell CardField Spell Card
Dark Contract with the Witch戦乙女（ヴァルキリー）の契（けい）約（やく）書（しょ）Trap CardContinuous Trap Card
Dark Magic Expanded黒魔導強化（マジック・エクスパンド）Spell CardQuick-Play Spell Card
Dark Magic Twin Burst黒・魔・導・連・弾（ブラックツインバースト）Spell CardNormal Spell Card
Deal of Phantom守（しゅ）護（ご）霊（れい）のお守（まも）りTrap CardNormal Trap Card
Double or Nothing!ダブル・アップ・チャンスSpell CardQuick-Play Spell Card
Dragon Mastery竜（りゅう）操（そう）術（じゅつ）Spell CardContinuous Spell Card
Ego Boost虚（きょ）栄（えい）巨（きょ）影（えい）Spell CardQuick-Play Spell Card
Energy Drainエナジー・ドレインTrap CardNormal Trap Card
ESP Amplifier超能力増幅器（サイキック・ブースター）Spell CardQuick-Play Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"