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

Results 26 – 75 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Card type::Monster Card]] [[Medium::OCG-only]] [[Database ID::+]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0229",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Card type::Monster Card]] [[Medium::OCG-only]] [[Database ID::+]]

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 t2
INNER JOIN
`smw_di_blob` AS t5 ON t2.s_id=t5.s_id
INNER JOIN
`smw_di_number` AS t7 ON t2.s_id=t7.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='596' AND t2.o_id='1389'
   AND (
   (t5.o_hash='OCG-only') AND t5.p_id='599')
   AND (t7.p_id='999')
  )
  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
25

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t5	ref	s_id,o_hash,s_id_2,p_id	o_hash	258	const	552	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t5.s_id	1	Using where
1	SIMPLE	t7	ref	s_id,p_id,p_id_2,s_id_2	s_id_2	8	ygowiki.t5.s_id,const	1	Using index; Distinct
1	SIMPLE	t2	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	13	ygowiki.t5.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	Secondary type	[[Attribute]]	[[Type]]	[[Level]]/ [[Rank]]	[[ATK]]	[[DEF]]
Beaked Snake	くちばしヘビ	Normal Monster		EARTH	Reptile	3	800	900
Beautiful Beast Trainer	美（うつく）しき魔（ま）物（もの）使（つか）い	Normal Monster		EARTH	Warrior	5	1750	1500
The Bewitching Phantom Thief	魅（み）惑（わく）の怪（かい）盗（とう）	Normal Monster		DARK	Spellcaster	2	700	700
Big Inflate Dragon	ビッグ・インフレート・ドラゴン	Effect Monster		WIND	Dragon	8	2500	1500
Binding Chain	封（ふう）印（いん）の鎖（くさり）	Normal Monster		LIGHT	Fairy	3	1000	1100
Bio Plant	Ｂ（バイオ）・プラント	Normal Monster		DARK	Fiend	3	600	1300
Black Sheep Token	黒（くろ）羊（ひつじ）トークン	Normal Monster Monster Token		DARK	Zombie	1	0	0
Blaze, Supreme Ruler of Dragons	征（せい）覇（は）竜（りゅう）－ブレイズ	Effect Monster Xyz Monster		FIRE	Dragon	7	2800	1800
Bolt Escargot	ボルト・エスカルゴ	Normal Monster		WATER	Thunder	5	1400	1500
Bomb Token	ボムトークン	Normal Monster Monster Token		FIRE	Pyro	1	1000	1000
Bombing Beast Fire Bomber	爆（ばく）撃（げき）獣（じゅう）ファイヤ・ボンバー	Effect Monster Fusion Monster		FIRE	Machine	6	1900	2400
Bone Mouse	骨（ホネ）ネズミ	Normal Monster		DARK	Zombie	1	400	300
Boo Koo	ブークー	Normal Monster		DARK	Spellcaster	2	650	500
Boulder Tortoise	岩（がん）石（せき）カメッター	Normal Monster		WATER	Aqua	6	1450	2200
Broomy	ブルーミー	Effect Monster	Tuner monster	LIGHT	Spellcaster	2	700	700
Burgundy the Magic Elf	魔法妖精（マジック・エルフ）バーガンディ	Effect Monster		DARK	Spellcaster	4	1600	1400
Candle of Fate	運（うん）命（めい）のろうそく	Normal Monster		DARK	Fiend	2	600	600
The Caveman that Awoke after a Millennium	千（せん）年（ねん）の眠（ねむ）りから覚（さ）めし原（げん）人（じん）	Effect Monster		EARTH	Beast-Warrior	8	2750	2500
Centur-Ion Atry	竜騎士（センチュリオン）アトリィ	Effect Monster	Tuner monster	DARK	Dragon	4	1800	1400
Chronicle Sorceress	クロニクル・ソーサレス	Effect Monster		DARK	Spellcaster	4	1250	1250
Combination Maneuver - Engage Zero	合（がっ）体（たい）術（じゅつ）式（しき）－エンゲージ・ゼロ	Effect Monster Link Monster		LIGHT	Machine		1500
Cosmo Queen, the Queen of Prayers	祈（いの）りの女（じょう）王（おう）－コスモクイーン	Effect Monster		DARK	Spellcaster	8	2900	2450
Creator of Hope	希（き）望（ぼう）の創（そう）造（ぞう）者（しゃ）	Effect Monster		LIGHT	Warrior	2	500	900
Creator of Miracles	奇（き）跡（せき）の創（そう）造（ぞう）者（しゃ）	Effect Monster		LIGHT	Warrior	4	1800	900
Crow Goblin	カラス天（てん）狗（ぐ）	Normal Monster		WIND	Winged Beast	5	1850	1600
Crystron Token	水晶機巧（クリストロン）トークン	Normal Monster Monster Token		WATER	Machine	1	0	0
Cursed Fire King Doom Burst	呪（じゅ）炎（えん）王（おう）バースト・カースド	Effect Monster		FIRE	Fiend	3	1600	800
CXyz Gimmick Puppet Fanatix Makina	ＣＸ（カオスエクシーズ）ギミック・パペット－ファナティクス・マキナ	Effect Monster Xyz Monster		DARK	Machine	9	3100	1500
Cyber Commander	コマンダー	Normal Monster		DARK	Machine	2	750	700
Cyber Soldier	機（き）械（かい）の兵（へい）隊（たい）	Normal Monster		DARK	Machine	5	1500	1700
Dark Chimera	ダーク・キメラ	Normal Monster		DARK	Fiend	5	1610	1460
Dark End Evaporation Dragon	闇と消滅の竜（ダークエンドイヴァポレイション・ドラゴン）	Effect Monster		DARK	Dragon	8	2600	2100
Dark Magician the Ebon Sorcerer	黒（くろ）き魔（ま）術（じゅつ）師（し）－ブラック・マジシャン	Effect Monster		DARK	Spellcaster	7	2500	2100
Dark Plant	ダーク・プラント	Normal Monster		DARK	Plant	1	300	400
Dark Shade	ダークシェイド	Normal Monster		WIND	Fiend	3	1000	1000
Detonating Kuriboh	機（き）雷（らい）化（か）するクリボー	Effect Monster		DARK	Fiend	1	300	200
Diabell, Fiendess of the White Woods	白（しろ）き森（もり）の妖（よう）魔（ま）ディアベル	Effect Monster Synchro Monster		LIGHT	Illusion	8	2500	2000
Dice Armadillo	ダイス・アルマジロ	Normal Monster		EARTH	Machine	5	1650	1800
Disablaster the Matchless Turret	無（む）孔（こう）砲（ほう）塔（とう）－ディセイブラスター	Effect Monster Pendulum Monster		LIGHT	Machine	5	500	2000
Divine Dragon Token	神（しん）龍（りゅう）トークン	Normal Monster Monster Token		WATER	Fish	10	3300	3000
Division	ディーヴジャン	Effect Monster		FIRE	Machine	2	200	200
Djinn the Watcher of the Wind	風（かぜ）の番（ばん）人（にん）ジン	Normal Monster		WIND	Spellcaster	3	700	900
Dokuroizo the Grim Reaper	死（しに）神（がみ）のドクロイゾ	Normal Monster		DARK	Zombie	3	900	1200
Doppel Token	ドッペル・トークン	Normal Monster Monster Token		DARK	Warrior	1	400	400
Dora Draco	ドラ・ドラ	Effect Monster		FIRE	Dragon	3	400	200
Doriado	ドリアード	Normal Monster		EARTH	Spellcaster	4	1200	1400
Doron	ドローン	Normal Monster		EARTH	Warrior	2	900	500
Dorover	ドローバ	Normal Monster		WATER	Aqua	3	900	800
DPA Jeanne d'Moore	Ｄ（ディー）Ｐ（ピー）Ａ（エー）ジャンダムーア	Effect Monster Synchro Monster	Tuner monster	FIRE	Cyberse	8	2000	2800
Dragluxion	神（しん）影（えい）金（きん）龍（りゅう）ドラッグルクシオン	Effect Monster Xyz Monster		LIGHT	Dragon	8	2500	3000

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools