Semantic search

This page or action requires Javascript to work, please enable Javascript in your browser or use a browser where this is supported so that functionality can be served and is provided as requested. For further assistance, please have a look at the noscript help page.

Options | Search Clear all entries |

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

ResultCodeDebugExtra

To embed this query inline into a wiki page use the code below.

{{#ask: [[Concept:CG cards]] [[Concept:Non-monster cards]] [[Banishing::Banishes itself from Graveyard||Banishes itself from Graveyard for cost]]
 |?English name (linked)
 |?Japanese name
 |?Card type=[[Card type]]
 |?Property=[[Property]]
 |format=table
 |limit=50
 |offset=50
 |sort=
 |order=asc
 |headers= plain
 |mainlabel= -
 |searchlabel= ... further results (179 more)
 |class= sortable wikitable smwtable card-list
}}

Results 51 – 100 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Concept:CG cards]] [[Concept:Non-monster cards]] [[Banishing::Banishes itself from Graveyard||Banishes itself from Graveyard for cost]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0445",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Concept:CG cards]] [[Concept:Non-monster cards]] [[Banishing::Banishes itself from Graveyard||Banishes itself from Graveyard for cost]]

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 t9
INNER JOIN
`t11` AS t11 ON t9.o_id=t11.id
INNER JOIN
(`smw_di_blob` AS t4
INNER JOIN
`smw_di_blob` AS t6 ON t4.s_id=t6.s_id) ON t9.s_id=t4.s_id
INNER JOIN
(`smw_di_wikipage` AS t22
INNER JOIN
`t24` AS t24 ON t22.o_id=t24.id) ON t9.s_id=t22.s_id) ON t0.smw_id=t9.s_id
WHERE
(t9.p_id='596'
   AND (
   ((t4.o_hash='OCG') OR (t4.o_hash='TCG')
  ) AND t4.p_id='599'
   AND (
   (t6.o_hash='Card page') AND t6.p_id='880')
  )
   AND (t22.p_id='570')
  )
  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

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t24	ALL	PRIMARY				2	Using temporary; Using filesort
1	SIMPLE	t22	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id_3	9	ygowiki.t24.id,const	12
1	SIMPLE	t4	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t22.s_id,const	1	Using where
1	SIMPLE	t6	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t22.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t22.s_id	1	Using where
1	SIMPLE	t9	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	8	ygowiki.t22.s_id,const	1	Using where; Using index; Distinct
1	SIMPLE	t11	eq_ref	PRIMARY	PRIMARY	4	ygowiki.t9.o_id	1	Distinct

Auxilliary Tables

Temporary table t11
  INSERT IGNORE INTO `t11` (id) VALUES ('1329')
  INSERT IGNORE INTO `t11` (id) VALUES ('1787')
  INSERT IGNORE INTO `t11` (id) VALUES ('87260')
  INSERT IGNORE INTO `t11` (id) VALUES ('70265')
  INSERT IGNORE INTO `t11` (id) VALUES ('2881')
  INSERT IGNORE INTO `t11` (id) VALUES ('77217')
  INSERT IGNORE INTO `t11` (id) VALUES ('769993')
  INSERT IGNORE INTO `t11` (id) VALUES ('72320')
  INSERT IGNORE INTO `t11` (id) VALUES ('0')
  INSERT IGNORE INTO `t11` (id) VALUES ('38099')
Temporary table t24
INSERT IGNORE INTO `t24` (id) VALUES ('47870')
INSERT IGNORE INTO `t24` (id) VALUES ('4363')

Query Metrics

Query-Size:5
Query-Depth:1

Errors and Warnings

None

English name (linked)	Japanese name	[[Card type]]	[[Property]]
Contact Gate	コンタクト・ゲート	Spell Card	Normal Spell Card
The Continuing Epic of Charles	シャルルの叙（じょ）事（じ）詩（し）	Trap Card	Normal Trap Card
Cosmic Flare	シューティング・ソニック	Spell Card	Quick-Play Spell Card
Cross-Dimensional Duel	競（きょう）闘（とう）－クロス・ディメンション	Trap Card	Normal Trap Card
Crusher Run	超整地破砕（クラッシャー・ラン）	Trap Card	Continuous Trap Card
Crystal Aegis	宝（ほう）玉（ぎょく）の加（か）護（ご）	Spell Card	Normal Spell Card
Crystal Boon	宝（ほう）玉（ぎょく）の祝（しゅく）福（ふく）	Trap Card	Normal Trap Card
Crystal Miracle	宝（ほう）玉（ぎょく）の奇（き）跡（せき）	Trap Card	Counter Trap Card
Crystron Entry	クリストロン・エントリー	Trap Card	Normal Trap Card
Crystron Impact	クリストロン・インパクト	Trap Card	Normal Trap Card
Cubic Ascension	方（ほう）界（かい）降（ごう）世（ぜ）	Trap Card	Normal Trap Card
Cubic Causality	方（ほう）界（かい）縁（えん）起（ぎ）	Trap Card	Normal Trap Card
Cubic Dharma	方（ほう）界（かい）法（ダーマ）	Spell Card	Continuous Spell Card
Cubic Karma	方（ほう）界（かい）業（カルマ）	Spell Card	Continuous Spell Card
Cubic Wave	方（ほう）界（かい）波（は）動（どう）	Spell Card	Normal Spell Card
Cyber Eternal	エターナル・サイバー	Spell Card	Quick-Play Spell Card
Cynet Circuit	サイバネット・サーキット	Trap Card	Normal Trap Card
Cynet Refresh	サイバネット・リフレッシュ	Trap Card	Normal Trap Card
Cynet Ritual	サイバネット・リチューアル	Spell Card	Ritual Spell Card
Cynet Rollback	サイバネット・ロールバック	Spell Card	Quick-Play Spell Card
D/D Reroll	Ｄ（ディー）Ｄ（ディー）リビルド	Trap Card	Continuous Trap Card
Damage Diet	ダメージ・ダイエット	Trap Card	Normal Trap Card
Dark Dragon Ritual	黒（こく）竜（りゅう）降（こう）臨（りん）	Spell Card	Ritual Spell Card
Dark Element	ダーク・エレメント	Spell Card	Normal Spell Card
Dark Spell Regeneration	暗（あん）黒（こく）の魔（ま）再（さい）生（せい）	Trap Card	Normal Trap Card
Dark Spirit's Mastery	ダーク・オカルティズム	Spell Card	Normal Spell Card
Dark World Punishment	暗（あん）黒（こく）界（かい）の懲（ちょう）罰（ばつ）	Trap Card	Counter Trap Card
Dark World Puppetry	暗（あん）黒（こく）界（かい）の傀（かい）儡（らい）	Spell Card	Quick-Play Spell Card
Dawn of the Herald	宣告者の預言（デクレアラー・プロフェシー）	Spell Card	Ritual Spell Card
Destruction Sword Flash	破（は）壊（かい）剣（けん）一（いっ）閃（せん）	Trap Card	Normal Trap Card
Destruction Sword Memories	破（は）壊（かい）剣（けん）の追（つい）憶（おく）	Trap Card	Normal Trap Card
Diamond Core of Koa'ki Meiru	コアキメイルの金（こん）剛（ごう）核（かく）	Spell Card	Normal Spell Card
Dimer Synthesis	二量合成（ダイマー・シンセシス）	Spell Card	Normal Spell Card
Dinomorphia Alert	ダイノルフィア・アラート	Trap Card	Normal Trap Card
Dinomorphia Brute	ダイノルフィア・ブルート	Trap Card	Normal Trap Card
Dinomorphia Domain	ダイノルフィア・ドメイン	Trap Card	Normal Trap Card
Dinomorphia Frenzy	ダイノルフィア・フレンジー	Trap Card	Normal Trap Card
Dinomorphia Intact	ダイノルフィア・インタクト	Trap Card	Counter Trap Card
Dinomorphia Reversion	ダイノルフィア・リヴァージョン	Trap Card	Counter Trap Card
Dinomorphia Shell	ダイノルフィア・シェル	Trap Card	Counter Trap Card
Dinomorphia Sonic	ダイノルフィア・ソニック	Trap Card	Counter Trap Card
Discordance of the Tistina	ティスティナの変（へん）晶（しょう）	Trap Card	Normal Trap Card
Doctor D	ドクターＤ（ディー）	Spell Card	Normal Spell Card
Dogmatikaturgy	ドラグマトゥルギー	Trap Card	Normal Trap Card
Doodlebook - Uh uh uh!	らくがきちょう－とおせんぼ	Trap Card	Normal Trap Card
Double Attack! Wind and Thunder!!	魔（ま）風（ふう）衝（しょう）撃（げき）波（は）	Spell Card	Quick-Play Spell Card
Dragonmaid Tidying	ドラゴンメイドのお片（かた）付（づ）け	Trap Card	Normal Trap Card
Dragunity Glow	ドラグニティ・グロー	Spell Card	Normal Spell Card
Dramatic Snake-Eye Chase	スネークアイ追（つい）走（そう）劇（げき）	Spell Card	Quick-Play Spell Card
Dream Mirror Fantasy	夢（ゆめ）魔（ま）鏡（きょう）の夢（ゆめ）物（もの）語（がたり）	Trap Card	Normal Trap Card

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools