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]] [[Actions::You draw cards]]
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='628' AND t18.o_id='1931')
  )
  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]]
Card of Reversal逆（ぎゃく）転（てん）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Card of Sacrifice捨（す）て身（み）の宝（ほう）札（さつ）Trap CardNormal Trap Card
Card of Safe Return生（せい）還（かん）の宝（ほう）札（さつ）Spell CardContinuous Spell Card
Card of Sanctity天（てん）よりの宝（ほう）札（さつ）Spell CardNormal Spell Card
Card of Spell Containment魔（ま）封（ふう）印（いん）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Card of the Dragon King竜（りゅう）皇（おう）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Card of Variation流（る）転（てん）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Card Reprinting手（て）札（ふだ）増（ぞう）刷（さつ）Trap CardNormal Trap Card
Card TraderカードトレーダーSpell CardContinuous Spell Card
Cards for Black Feathers黒（くろ）羽（はね）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Cards from the Sky天（てん）空（くう）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Cards of Consonance調（ちょう）和（わ）の宝（ほう）札（さつ）Spell CardNormal Spell Card
Catastrophe Drawカタストロフ・ドローSpell CardNormal Spell Card
Celeb Charityセレブの施（ほどこ）しSpell CardNormal Spell Card
Chaos Greedカオス・グリードSpell CardNormal Spell Card
Chaos Tempest Drawカオス・テンペスト・ドローSpell CardNormal Spell Card
Charis Magic - Elegant Changeカリス・マジック－エレガントチェンジSpell CardNormal Spell Card
Charm of Lamentation悲（ひ）嘆（たん）の宝（ほう）札（さつ）Spell CardContinuous Spell Card
Chemicalize Centrifugeケミカライズ・セントリフュージSpell CardNormal Spell Card
Chronomaly Technology先史遺産技術（オーパーツテクノロジー）Spell CardNormal Spell Card
Clairvoyance透視（クリアボヤンス）Spell CardNormal Spell Card
Command Silencerコマンド・サイレンサーSpell CardQuick-Play Spell Card
Constructor Sword Foreman幻（げん）刃（ば）剣（けん）匠（しょう）Spell CardNormal Spell Card
Contract Laundering契約洗浄（リース・ロンダリング）Trap CardNormal Trap Card
Contract with Don Thousandドン・サウザンドの契（けい）約（やく）Spell CardContinuous Spell Card
Convert Contactコンバート・コンタクトSpell CardNormal Spell Card
Convert Contactコンバート・コンタクトSpell CardNormal Spell Card
Counter Gateカウンター・ゲートTrap CardNormal Trap Card
Crazy Evolution狂（きょう）進（しん）化（か）Spell CardNormal Spell Card
Cross Draw of Destiny運（うん）命（めい）のクロス・ドローSpell CardNormal Spell Card
Cross Linkage Hackクロス・リンケージ・ハックSpell CardNormal Spell Card
Cup of Aceカップ・オブ・エースSpell CardNormal Spell Card
Cure Conversionキュア・コンバージョンTrap CardNormal Trap Card
Cyberse Bridgeサイバース・ブリッジSpell CardNormal Spell Card
Cyberse Cacheサイバース・キャッシュSpell CardNormal Spell Card
Cyberse Shatterサイバース・シャッターTrap CardNormal Trap Card
D - BoostＤ（ディー）－ブーストTrap CardNormal Trap Card
D - BurstＤ（ディー）－バーストSpell CardNormal Spell Card
D2 ShieldＤ（ディー）２（ツー）シールドTrap CardNormal Trap Card
Damage Polarizerダメージ・ポラリライザーTrap CardCounter Trap Card
Dance of the Guardian守（しゅ）護（ご）神（しん）の舞（まい）Trap CardNormal Trap Card
Danger Drawマストダイ・ドローTrap CardNormal Trap Card
Danger Drawデンジャラス・ドローTrap CardNormal Trap Card
Dangerous Machine Type-6デンジャラスマシン ＴＹＰＥ（タイプ）－６（シックス）Spell CardContinuous Spell Card
Dark Contract with the Insurance魔（ま）界（かい）保（ほ）険（けん）の契（けい）約（やく）書（しょ）Spell CardNormal Spell Card
Dark Matterダーク・マターTrap CardNormal Trap Card
Dark Matter Parallel Podダークマター・パラレルポッドSpell CardNormal Spell Card
Dark World Dealings暗（あん）黒（こく）界（かい）の取（とり）引（ひき）Spell CardNormal Spell Card
Darkness Divineダークネス・ディバインSpell CardNormal Spell Card
Darkness Greedダークネス・マジック５４９Spell CardNormal Spell Card
Retrieved from "https://yugipedia.com/wiki/Special:Ask"