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: [[Medium::Manga]] [[Card type::Monster Card]] [[Anti-support::+]]
 |?English name (linked)
 |?Japanese name
 |?Primary type
 |?Secondary type
 |?Attribute=[[Attribute]]
 |?Type=[[Type]]
 |?Stars string=[[Level]]/
[[Rank]]
 |?ATK string=[[ATK]]
 |?DEF string=[[DEF]]
 |?Anti-support=Anti-supports card(s)/group(s)
 |format=table
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |headers= plain
 |mainlabel= -
 |searchlabel= ... further results (14 more)
 |class= sortable wikitable smwtable card-list
}}

Results 1 – 40 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Medium::Manga]] [[Card type::Monster Card]] [[Anti-support::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0293",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Medium::Manga]] [[Card type::Monster Card]] [[Anti-support::+]]

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 t4 ON t2.s_id=t4.s_id
INNER JOIN
`smw_di_wikipage` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
WHERE
(
   (t2.o_hash='Manga') AND t2.p_id='599'
   AND (t4.p_id='596' AND t4.o_id='1389')
   AND (t7.p_id='553')
  )
  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

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t7	ref	s_id,p_id,s_id_2,s_id_3	p_id	4	const	2319	Using index; Using temporary; Using filesort
1	SIMPLE	t2	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t7.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t7.s_id	1	Using where
1	SIMPLE	t4	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	13	ygowiki.t7.s_id,const,const	1	Using index; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:5
Query-Depth:1

Errors and Warnings

None

English name (linked)	Japanese name	Primary type	[[Attribute]]	[[Type]]	[[Level]]/ [[Rank]]	[[ATK]]	[[DEF]]	Anti-supports card(s)/group(s)
Acid Hell Fly	地獄酸蠅（ヘル・アシッド・フライ）	Effect Monster			2	600	0	Equip Spell Card
Burning Blaze Dragon	バーニング・ブレイズ・ドラゴン	Effect Monster	FIRE	Dragon	6	1800	0	Field Spell Card
Buster Blader	バスター・ブレイダー	Effect Monster			8	2600	2300	Dragon
Constructor Fighter Mixer	幻（げん）刃（ば）闘（とう）士（し）ミキサ	Effect Monster	EARTH	Wyrm	4	1200	400	Field Spell Card
Constructor Wyrm Buildragon	幻（げん）刃（ば）竜（りゅう）ビルド・ドラゴン	Effect Monster	EARTH	Wyrm	8	2500	2000	Field Spell Card
D/D Extra Surveyor	Ｄ（ディー）Ｄ（ディー）エクストラ・サーベイヤー	Pendulum Monster		???	5	1000	0	Pendulum Monster
D/D Scale Surveyor	Ｄ（ディー）Ｄ（ディー）スケール・サーベイヤー	Pendulum Monster		???	2	0	1000	Pendulum Monster
Dark Paladin	超（ちょう）魔（ま）導（どう）剣（けん）士（し）－ブラック・パラディン	Effect Monster Fusion Monster		Black Magic		2900		Dragon
Draco Berserker of the Tenyi	天（てん）威（い）の龍（りゅう）鬼（き）神（しん）	Synchro Monster	DARK	Wyrm	8	3000	0	Effect Monster
Draco Masters of the Tenyi	天（てん）威（い）の龍（りゅう）拳（けん）聖（せい）	Link Monster	LIGHT	Wyrm		2600		Effect Monster
Dragon Capture Jar	ドラゴン族（ぞく）・封（ふう）印（いん）の壺（つぼ）	Normal Monster			2	100	200	Dragon
Dragon Piper	壺（つぼ）魔（ま）人（じん）	Normal Monster	DARK		2	200	1800	Dragon
Elemental Hero Inferno	Ｅ・ＨＥＲＯ（エレメンタルヒーロー）フレイム・ブラスト	Fusion Monster	FIRE	???	8	2300	1600	WATER
Elemental Hero Inferno	Ｅ・ＨＥＲＯ（エレメンタルヒーロー）フレイム・ブラスト	Fusion Monster	FIRE	???	8	2300	1600	WATER
Galaxy-Eyes Photon Dragon	銀河眼の光子竜（ギャラクシーアイズ・フォトン・ドラゴン）	Effect Monster	LIGHT	Dragon	8	3000	2500	Xyz Monster Xyz Material
Garakarasu	ガラカラス	Effect Monster			4	1500		Field Spell Card
Headhunters' Jaguar	尖頭狩猟（ヘッドハンターズ）ジャグール	Effect Monster	EARTH	Beast-Warrior	6	1700	0	Normal Monster
Ice Queen	氷（こおり）の女（じょ）王（おう）	Effect Monster	WATER	???	8	2900	2100	WATER
Insect Queen	インセクト女王（クイーン）	Normal Monster		Insect	8	2200	2400	Insect
Jester Puppet King Pantomime	道化傀儡王（ジェスター・パペット・キング）パントミーメ	Ritual Monster		???	7	1600	2400	Synchro Monster
Jinzo - Layered	人（じん）造（ぞう）人（にん）間（げん）－サイコ・レイヤー	Xyz Monster	DARK	Machine	6	2400	1500	Trap Card
Kappa Emperor River Slider	河（かっ）童（ぱ）大（たい）帝（てい）リバースライダー	Effect Monster	WATER	Aqua	7	2500	1500	Normal Monster
The King of Divine Punishment, Dark Highlander	天（てん）刑（けい）王（おう）ブラック・ハイランダー	Synchro Monster	DARK	Fiend	7	2800	2300	Equip Card Synchro Monster
Photon Slayer	フォトン・スレイヤー	Effect Monster	LIGHT	Warrior	5	2100	1000	Xyz Monster
Predaplant Spider Orchid	捕食植物（プレデター・プランツ）スパイダー・オーキッド	Pendulum Monster	DARK	Plant	1	0	0	Pendulum Monster
Rogue Doll	ホーリー・ドール	Normal Monster		White Magic	4	1600	1000	Zombie
Sevens Road Enchanter	セブンスロード・エンチャンター	Effect Monster	DARK	Spellcaster	3	1200	100	Spellcaster
Sevens Road Enchanter	セブンスロード・エンチャンター	Effect Monster	DARK	Spellcaster	3	1200	100	Spellcaster
Sky Fossil Lyrarapax	スカイフォッシル・ライララパクス	Effect Monster	WIND	Zombie	3	1300	0	LIGHT
Starship Spy Plane	スターシップ・スパイ・プレーン	Effect Monster	WIND	Machine	4	1100	500	Xyz Monster
Stealthroid	ステルスロイド	Effect Monster			4	400	2000	Flip monster
Strain Nuke	ストレイン・ニューク	Effect Monster			1	0		Xyz Monster
Tualatin	テュアラティン	Effect Monster	LIGHT	???	8	2800	2500	DARK
Voidvelgr Meteon	ヴォイドヴェルグ・メテオン	Effect Monster	DARK	Galaxy (Type)	2	500	900	LIGHT
Voidvelgr Meteon	ヴォイドヴェルグ・メテオン	Effect Monster	DARK	Galaxy (Type)	2	500	900	LIGHT
Voidvelgr Requiem	ヴォイドヴェルグ・レクイエム	Effect Monster	DARK	Galaxy (Type)	8	2500	2000	LIGHT
Voidvelgr Requiem	ヴォイドヴェルグ・レクイエム	Effect Monster	DARK	Galaxy (Type)	8	2500	2000	LIGHT
Voidvelgr Transi	ヴォイドヴェルグ・トランジ	Effect Monster	DARK	Galaxy (Type)	8	2400	2000	Normal Monster
The Wicked Avatar	ＴＨＥＤＥＶＩＬＳＡＶＡＴＡＲ	Effect Monster		Divine-Beast	10	?	?	Divine-Beast
Wyrm Excavator the Heavy Cavalry Draco [R]	幻（げん）竜（りゅう）重（じゅう）騎（き）ウォームＥｘ（エクス）カベーター［Ｒ（アール）］	Effect Monster Maximum Monster	EARTH	Wyrm	3	800	0	Field Spell Card

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools