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:CG non-monster cards]] [[Stats::All monsters gain DEF]]
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 t24
INNER JOIN
  (`smw_di_wikipage` AS t11
INNER JOIN
  `t13` AS t13 ON t11.o_id=t13.id
INNER JOIN
  (`smw_di_blob` AS t6
INNER JOIN
  `smw_di_blob` AS t8 ON t6.s_id=t8.s_id) ON t11.s_id=t6.s_id) ON t24.s_id=t11.s_id) ON t0.smw_id=t24.s_id
WHERE
  (t24.p_id='629' AND t24.o_id='4683'
   AND (t11.p_id='596'
   AND (
   ((t6.o_hash='OCG') OR (t6.o_hash='TCG')
  ) AND t6.p_id='599'
   AND (
   (t8.o_hash='Card page') AND t8.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
1SIMPLEt24refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id5const130Using where; Using temporary; Using filesort
1SIMPLEt6refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t24.s_id,const1Using where
1SIMPLEt8refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t24.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t24.s_id1Using where
1SIMPLEt11refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_38ygowiki.t24.s_id,const1Using where; Using index; Distinct
1SIMPLEt13eq_refPRIMARYPRIMARY4ygowiki.t11.o_id1Distinct
Auxilliary Tables
  • Temporary table t13
      INSERT IGNORE INTO `t13` (id) VALUES ('1329')
      INSERT IGNORE INTO `t13` (id) VALUES ('1787')
      INSERT IGNORE INTO `t13` (id) VALUES ('87260')
      INSERT IGNORE INTO `t13` (id) VALUES ('70265')
      INSERT IGNORE INTO `t13` (id) VALUES ('2881')
      INSERT IGNORE INTO `t13` (id) VALUES ('77217')
      INSERT IGNORE INTO `t13` (id) VALUES ('769993')
      INSERT IGNORE INTO `t13` (id) VALUES ('72320')
      INSERT IGNORE INTO `t13` (id) VALUES ('0')
      INSERT IGNORE INTO `t13` (id) VALUES ('38099')
Query Metrics
Query-Size:3
Query-Depth:1
Errors and Warnings
None
NameJapanese name[[Card type]][[Property]]
Acidic DownpourアシッドレインSpell CardField Spell Card
Amorphage Infectionアモルファージ・インフェクションSpell CardContinuous Spell Card
Amorphous PersonaアモルファスＰ（ペルソナ）Spell CardField Spell Card
Boot Sector Launchリボルブート・セクターSpell CardField Spell Card
Celestia異（い）層（そう）空（くう）間（かん）Spell CardField Spell Card
Chorus of Sanctuary聖（せい）域（いき）の歌（うた）声（ごえ）Spell CardField Spell Card
Colosseum - Cage of the Gladiator Beasts剣闘獣（グラディアルビースト）の檻（おり）－コロッセウムSpell CardField Spell Card
Cynet Stormサイバネット・ストームSpell CardField Spell Card
Deskbot Baseブンボーグ・ベースSpell CardField Spell Card
Dinomic PowerloadダイナミックＰ（パワーロード）Spell CardField Spell Card
Dragonic PendulumドラゴニックＰ（ペンデュラム）Spell CardField Spell Card
Elborz, the Sacred Lands of Simorgh神鳥（シムルグ）の霊（れい）峰（ほう）エルブルズSpell CardField Spell Card
Fire Prison天（てん）火（ぴ）の牢（ろう）獄（ごく）Spell CardField Spell Card
Forest森（もり）Spell CardField Spell Card
The Gates of Dark World暗（あん）黒（こく）界（かい）の門（もん）Spell CardField Spell Card
Harpies' Hunting Groundハーピィの狩（かり）場（ば）Spell CardField Spell Card
Ignition PhoenixイグニッションＰ（フェニックス）Spell CardField Spell Card
Jurassic WorldジュラシックワールドSpell CardField Spell Card
A Legendary Ocean伝（でん）説（せつ）の都（みやこ） アトランティスSpell CardField Spell Card
Lemuria, the Forgotten City忘（ぼう）却（きゃく）の都（みやこ） レミューリアSpell CardField Spell Card
Madolche Chateauマドルチェ・シャトーSpell CardField Spell Card
Madolche Lessonマドルチェ・マナーTrap CardNormal Trap Card
Majesty's PegasusマジェスティックＰ（ペガサス）Spell CardField Spell Card
Mountain山（やま）Spell CardField Spell Card
Necrovalley王（おう）家（け）の眠（ねむ）る谷（たに）－ネクロバレーSpell CardField Spell Card
PlancktonプランクスケールTrap CardNormal Trap Card
Ragnaraika Bloom蕾禍（ライカ）繚（リョウ）乱（ラン）狂（クルイ）咲（ザキ）Spell CardContinuous Spell Card
The Sanctum of Parshathパーシアスの神（しん）域（いき）Spell CardContinuous Spell Card
Scrap Factoryスクラップ・ファクトリーSpell CardField Spell Card
Sogen草（そう）原（げん）Spell CardField Spell Card
Spright Gamma Burstスプライト・ガンマ・バーストSpell CardQuick-Play Spell Card
Triamid Fortressトラミッド・フォートレスSpell CardField Spell Card
Umi海（うみ）Spell CardField Spell Card
Wasteland荒（こう）野（や）Spell CardField Spell Card
World Legacy Discovery星（せい）遺（い）物（ぶつ）との邂（かい）逅（こう）Spell CardField Spell Card
World Legacy in Shadow星（せい）遺（い）物（ぶつ）に差（さ）す影（かげ）Spell CardField Spell Card
World Legacy Scars星（せい）遺（い）物（ぶつ）が刻（きざ）む傷（きず）痕（あと）Spell CardField Spell Card
Xyz Territoryエクシーズ・テリトリーSpell CardField Spell Card
Yami闇（やみ）Spell CardField Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"