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 monsters]]
 |?English name (linked)=Name
 |?Japanese name
 |?Primary type
 |?Secondary type
 |?Attribute=[[Attribute]]
 |?Type=[[Type]]
 |?Stars string=[[Level]]/
[[Rank]]
 |?Pendulum Scale=[[Pendulum Scale|Scale]]
 |?ATK string=[[ATK]]
 |?DEF string=[[DEF]]
 |?Link Rating=[[Link Rating|Link]]
 |?Password
 |format=broadtable
 |limit=50
 |offset=0
 |sort=
 |order=asc
 |mainlabel=-
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Concept:CG monsters]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0129",
    "from_cache": true
}

Other

Disable query cache

SQLStore debug output

ASK Query

[[Concept:CG monsters]]

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
(`smw_di_blob` AS t5
INNER JOIN
`smw_di_blob` AS t7 ON t5.s_id=t7.s_id) ON t9.s_id=t5.s_id) ON t0.smw_id=t9.s_id
WHERE
(t9.p_id='596' AND t9.o_id='1389'
   AND (
   ((t5.o_hash='OCG') OR (t5.o_hash='TCG')
  ) AND t5.p_id='599'
   AND (
   (t7.o_hash='Card page') AND t7.p_id='880')
  ))
  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	t9	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id_2	5	const	71860	Using where; Using temporary; Using filesort
1	SIMPLE	t5	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t9.s_id,const	1	Using where
1	SIMPLE	t7	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t9.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t9.s_id	1	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:1
Query-Depth:0

Errors and Warnings

None

Name	Japanese name	Primary type	Secondary type	[[Attribute]]	[[Type]]	[[Level]]/ [[Rank]]	[[Pendulum Scale\|Scale]]	[[ATK]]	[[DEF]]	[[Link Rating\|Link]]	Password
The 10th Yu-Gi-Oh! Championship Series Japan	Ｔｈｅ１０ｔｈＹｕ－Ｇｉ－Ｏｈ！ＣＨＡＭＰＩＯＮＳＨＩＰＳＥＲＩＥＳＪＡＰＡＮ	Normal Monster Monster Token
The 13th Grave	１３人（にん）目（め）の埋（まい）葬（そう）者（しゃ）	Normal Monster		DARK	Zombie	3		1200	900		00032864
3-Hump Lacooda	みつこぶラクーダ	Effect Monster		EARTH	Beast	3		500	1500		86988864
30,000-Year White Turtle	３万（まん）年（ねん）の白（しろ）亀（カメ）	Normal Monster		WATER	Aqua	5		1250	2100		11714098
4-Starred Ladybug of Doom	死（し）の４つ星（ほし）てんとう虫（ムシ）	Effect Monster	Flip monster	WIND	Insect	3		800	1200		83994646
7 Colored Fish	レインボー・フィッシュ	Normal Monster		WATER	Fish	4		1800	800		23771716
8-Claws Scorpion	八（や）つ手（で）サソリ	Effect Monster		DARK	Insect	2		300	200		14261867
@Ignister Token	＠（アット）イグニスタートークン	Normal Monster Monster Token		DARK	Cyberse	1		0	0
A-Assault Core	Ａ（エー）－アサルト・コア	Effect Monster	Union monster	LIGHT	Machine	4		1900	200		30012506
A-Team: Trap Disposal Unit	トラップ処（しょ）理（り）班（はん）Ａチーム	Effect Monster		FIRE	Machine	2		300	400		13026402
A-to-Z-Dragon Buster Cannon	ＡｔｏＺ（エートゥズィ）－ドラゴン・バスターキャノン	Effect Monster Fusion Monster		LIGHT	Machine	10		4000	4000		65172015
A/D Changer	Ａ（エー）Ｄ（ディー）チェンジャー	Effect Monster		LIGHT	Warrior	1		100	100		96146814
Abaki	暴（あば）鬼（き）	Effect Monster		FIRE	Fiend	4		1700	1100		12694768
Abare Ushioni	暴（あば）れ牛（うし）鬼（おに）	Effect Monster		EARTH	Beast-Warrior	4		1200	1200		89718302
ABC-Dragon Buster	Ａ（エー）Ｂ（ビー）Ｃ（シー）－ドラゴン・バスター	Effect Monster Fusion Monster		LIGHT	Machine	8		3000	2800		01561110
Abominable Unchained Soul	雙（そう）極（きょく）の破（は）械（かい）神（しん）	Effect Monster		DARK	Fiend	8		3000	1500		01966438
Absolute Crusader	レアル・クルセイダー	Effect Monster		EARTH	Warrior	4		1800	1200		70832512
Absolute King - Megaplunder	絶（ぜっ）対（たい）なる王（おう）者（じゃ）－メガプランダー	Normal Monster		EARTH	Dinosaur	6		2000	1500		27553701
Absolute King Back Jack	絶（ぜっ）対（たい）王（おう）バック・ジャック	Effect Monster		DARK	Fiend	1		0	0		60990740
Absorbing Jar	アブソーブポッド	Effect Monster	Flip monster	EARTH	Rock	3		600	500		03900605
Absorbing Kid from the Sky	吸（きゅう）収（しゅう）天（てん）児（じ）	Effect Monster		LIGHT	Fairy	4		1300	1000		49771608
Absorouter Dragon	アブソルーター・ドラゴン	Effect Monster		DARK	Dragon	7		1200	2800		67748760
Abyss Actor - Comic Relief	魔（ま）界（かい）劇（げき）団（だん）－コミック・リリーフ	Effect Monster Pendulum Monster		DARK	Fiend	3	8	1000	2000		15308295
Abyss Actor - Curtain Raiser	魔（ま）界（かい）劇（げき）団（だん）カーテン・ライザー	Effect Monster Pendulum Monster		DARK	Fiend	4	7	1100	1000		44179224
Abyss Actor - Evil Heel	魔（ま）界（かい）劇（げき）団（だん）－デビル・ヒール	Effect Monster Pendulum Monster		DARK	Fiend	8	1	3000	2000		52240819
Abyss Actor - Extras	魔（ま）界（かい）劇（げき）団（だん）－エキストラ	Effect Monster Pendulum Monster		DARK	Fiend	1	3	100	100		88412339
Abyss Actor - Funky Comedian	魔（ま）界（かい）劇（げき）団（だん）－ファンキー・コメディアン	Effect Monster Pendulum Monster		DARK	Fiend	1	8	300	200		99634927
Abyss Actor - Hyper Director	魔（ま）界（かい）劇（げき）団（だん）－ハイパー・ディレクター	Effect Monster Link Monster		DARK	Fiend			800		1	02368215
Abyss Actor - Leading Lady	魔（ま）界（かい）劇（げき）団（だん）－プリティ・ヒロイン	Effect Monster Pendulum Monster		DARK	Fiend	4	2	1500	1000		24907044
Abyss Actor - Liberty Dramatist	魔（ま）界（かい）劇（げき）団（だん）－リバティ・ドラマチスト	Effect Monster Pendulum Monster		DARK	Fiend	4	8	1500	1500		65477143
Abyss Actor - Mellow Madonna	魔（ま）界（かい）劇（げき）団（だん）－メロー・マドンナ	Effect Monster Pendulum Monster		DARK	Fiend	7	0	1800	2500		78310590
Abyss Actor - Sassy Rookie	魔（ま）界（かい）劇（げき）団（だん）－サッシー・ルーキー	Effect Monster Pendulum Monster		DARK	Fiend	4	2	1700	1000		51028231
Abyss Actor - Super Producer	魔（ま）界（かい）劇（げき）団（だん）－スーパー・プロデューサー	Effect Monster Link Monster		DARK	Fiend			1600		2	47404795
Abyss Actor - Superstar	魔（ま）界（かい）劇（げき）団（だん）－ビッグ・スター	Effect Monster Pendulum Monster		DARK	Fiend	7	3	2500	1800		25629622
Abyss Actor - Trendy Understudy	魔（ま）界（かい）劇（げき）団（だん）－ダンディ・バイプレイヤー	Effect Monster Pendulum Monster		DARK	Fiend	2	8	700	700		39024589
Abyss Actor - Twinkle Little Star	魔（ま）界（かい）劇（げき）団（だん）－ティンクル・リトルスター	Effect Monster Pendulum Monster		DARK	Fiend	4	9	1000	1000		07279373
Abyss Actor - Wild Hope	魔（ま）界（かい）劇（げき）団（だん）－ワイルド・ホープ	Effect Monster Pendulum Monster		DARK	Fiend	4	2	1600	1200		51391183
The Abyss Dragon Swordsoul	深（しん）淵（えん）の相（そう）剣（けん）龍（りゅう）	Effect Monster		FIRE	Wyrm	8		3000	2900		05141117
Abyss Dweller	深（しん）淵（えん）に潜（ひそ）む者（もの）	Effect Monster Xyz Monster		WATER	Sea Serpent	4		1700	1400		21044178
Abyss Flower	深（しん）淵（えん）に咲（さ）く花（はな）	Normal Monster		EARTH	Plant	2		750	400		40387124
Abyss Keeper	アビス・オーパー	Effect Monster Link Monster		WATER	Fish			1500		2	82184400
Abyss Shark	アビス・シャーク	Effect Monster		WATER	Fish	5		1200	700		61496006
Abyss Soldier	アビス・ソルジャー	Effect Monster		WATER	Aqua	4		1800	1300		18318842
Abyss Warrior	アビス・ウォリアー	Effect Monster		WATER	Aqua	4		1800	1300		88409165
Abyssal Kingshark	深（しん）海（かい）王（おう）デビルシャーク	Effect Monster		WATER	Fish	4		1700	600		44223284
Accel Synchro Stardust Dragon	アクセルシンクロ・スターダスト・ドラゴン	Effect Monster Synchro Monster		WIND	Dragon	8		2500	2000		30983281
Accel Synchron	アクセル・シンクロン	Effect Monster Synchro Monster	Tuner monster	DARK	Machine	5		500	2100		37675907
Accesscode Talker	アクセスコード・トーカー	Effect Monster Link Monster		DARK	Cyberse			2300		4	86066372
The Accumulator	ザ・アキュムレーター	Effect Monster		LIGHT	Thunder	1		0	0		70410002
Achacha Archer	アチャチャアーチャー	Effect Monster		FIRE	Warrior	3		1200	600		98865920

Semantic search

Query log

Other

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools