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
[[Medium::Anime]] [[Concept:Non-monster cards]] [[LP::Damages your opponent]]
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_blob` AS t2
INNER JOIN
  (`smw_di_wikipage` AS t5
INNER JOIN
  `t7` AS t7 ON t5.o_id=t7.id) ON t2.s_id=t5.s_id
INNER JOIN
  `smw_di_wikipage` AS t18 ON t2.s_id=t18.s_id) ON t0.smw_id=t2.s_id
WHERE
  (
   (t2.o_hash='Anime') AND t2.p_id='599'
   AND (t5.p_id='596')
   AND (t18.p_id='558' AND t18.o_id='2100')
  )
  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
  50
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt7ALLPRIMARY10Using temporary; Using filesort
1SIMPLEt5refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3o_id_39ygowiki.t7.id,const12
1SIMPLEt2refs_id,o_hash,s_id_2,p_ids_id8ygowiki.t5.s_id,const1Using where
1SIMPLEt0eq_refPRIMARY,smw_id,smw_iw,smw_iw_2PRIMARY4ygowiki.t5.s_id1Using where
1SIMPLEt18refs_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3s_id_313ygowiki.t5.s_id,const,const1Using index; Distinct
Auxilliary Tables
  • Temporary table t7
      INSERT IGNORE INTO `t7` (id) VALUES ('1329')
      INSERT IGNORE INTO `t7` (id) VALUES ('1787')
      INSERT IGNORE INTO `t7` (id) VALUES ('87260')
      INSERT IGNORE INTO `t7` (id) VALUES ('70265')
      INSERT IGNORE INTO `t7` (id) VALUES ('2881')
      INSERT IGNORE INTO `t7` (id) VALUES ('77217')
      INSERT IGNORE INTO `t7` (id) VALUES ('769993')
      INSERT IGNORE INTO `t7` (id) VALUES ('72320')
      INSERT IGNORE INTO `t7` (id) VALUES ('0')
      INSERT IGNORE INTO `t7` (id) VALUES ('38099')
Query Metrics
Query-Size:5
Query-Depth:1
Errors and Warnings
None
English name (linked)Japanese name[[Card type]][[Property]]
Brain Rebootブレイン・リブートSpell CardNormal Spell Card
Breaking News!事（じ）件（けん）です！Trap CardNormal Trap Card
Brilliant Sparkブリリアント・スパークTrap CardNormal Trap Card
Brocoohearted PigeonハートブレイクルックTrap CardNormal Trap Card
Broken Ruinブレイク・ルインSpell CardNormal Spell Card
The Burnザ☆バーンTrap CardNormal Trap Card
Burning Barrel大（おお）火（ひ）筒（つつ）Spell CardNormal Spell Card
Burst Impactバースト・インパクトSpell CardNormal Spell Card
Butterfly Ballet胡（こ）蝶（ちょう）の舞（まい）Spell CardContinuous Spell Card
Butterfly Mist胡（こ）蝶（ちょう）の毒（どく）Trap CardContinuous Trap Card
Butterfly Swarm死蝶の誘い（デスバタフライ・インビテーション）Spell CardContinuous Spell Card
Ceasefire停（てい）戦（せん）協（きょう）定（てい）Trap CardNormal Trap Card
Cemetary Bombセメタリー・ボムTrap CardNormal Trap Card
Chain Burst連鎖炸薬（チェーン・バースト）Trap CardContinuous Trap Card
Chain Strike連鎖爆撃（チェーン・ストライク）Spell CardQuick-Play Spell Card
Change of Hero - Reflector Ray英雄変化（チェンジ・オブ・ヒーロー）－リフレクター・レイTrap CardNormal Trap Card
Chaos Barrier Field混沌のバリア－カオスフィールド－Trap CardNormal Trap Card
Chaos Burstカオス・バーストTrap CardNormal Trap Card
Chaos Burstカオス・バーストTrap CardNormal Trap Card
Charging Blade魁（さきがけ）の旋（せん）刃（じん）Spell CardEquip Spell Card
Chariot Pileチャリオット・パイルTrap CardContinuous Trap Card
Chemicalize Devil Burstケミカライズ・デビルバーストSpell CardNormal Spell Card
Chthonian Blastヘル・ブラストSpell CardNormal Spell Card
Cipher Chain光波連環（サイファー・チェーン）Trap CardContinuous Trap Card
Clay Chargeクレイ・チャージTrap CardNormal Trap Card
Clear Worldクリアー・ワールドSpell CardField Spell Card
Climactic Barricadeヘル・バリケードTrap CardNormal Trap Card
Climax Clash交（こう）剣（けん）死（し）哀（あい）Trap CardNormal Trap Card
Codebreak Backfireコードブレイク・バックファイアTrap CardContinuous Trap Card
Codebreak Bindコードブレイク・バインドSpell CardContinuous Spell Card
Coffin Seller棺（かん）桶（おけ）売（う）りTrap CardContinuous Trap Card
Contagion of Madness狂（きょう）気（き）の伝（でん）染（せん）Spell CardQuick-Play Spell Card
Corkscrew Counterコークスクリュー・クロスTrap CardCounter Trap Card
Cosmic Blastコズミック・ブラストTrap CardNormal Trap Card
Counter Cannonballカウンター・ボムTrap CardNormal Trap Card
Counter Forceカウンター・フォースTrap CardContinuous Trap Card
Counterforce反（はん）発（ぱつ）力（りょく）Trap CardNormal Trap Card
CrackingクラッキングSpell CardContinuous Spell Card
Crimson Fireクリムゾン・ヘルフレアTrap CardCounter Trap Card
Critical Serviceクリティカル・サービスTrap CardNormal Trap Card
Cross Damageクロス・ダメージTrap CardNormal Trap Card
Crystal Veilクリスタル・ヴェールTrap CardNormal Trap Card
Cure Shotアキュア・ショットTrap CardNormal Trap Card
Curse Reflection Doll呪詛（のろい）返（がえ）しのヒトガタSpell CardQuick-Play Spell Card
Cursed Ivyカースド・アイヴィTrap CardContinuous Trap Card
Cyber Summon Blasterサイバー・サモン・ブラスターTrap CardContinuous Trap Card
Cyberse Annihilationサイバース・アナイレーションSpell CardEquip Spell Card
Cyclone Boomerangサイクロン・ブーメランSpell CardEquip Spell Card
D - ChainＤ（ディ）－チェーンTrap CardNormal Trap Card
D - ChainＤ（ディー）－チェーンTrap CardNormal Trap Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"