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]][[Actions::Changes battle positions]]
 |?English name (linked)=Name
 |?Japanese name
 |?Primary type
 |?Secondary type
 |?Attribute=[[Attribute]]
 |?Type=[[Type]]
 |?Stars string=[[Level]]/
[[Rank]]
 |?ATK string=[[ATK]]
 |?DEF string=[[DEF]]
 |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]][[Actions::Changes battle positions]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0586",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Concept:CG monsters]] [[Actions::Changes battle positions]]

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 t13
INNER JOIN
(`smw_di_wikipage` AS t10
INNER JOIN
(`smw_di_blob` AS t6
INNER JOIN
`smw_di_blob` AS t8 ON t6.s_id=t8.s_id) ON t10.s_id=t6.s_id) ON t13.s_id=t10.s_id) ON t0.smw_id=t13.s_id
WHERE
(t13.p_id='628' AND t13.o_id='1643'
   AND (t10.p_id='596' AND t10.o_id='1389'
   AND (
   ((t6.o_hash='OCG') OR (t6.o_hash='TCG')
  ) AND t6.p_id='599'
   AND (
   (t8.o_hash='Card page') AND t8.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	t13	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id	5	const	1069	Using where; Using temporary; Using filesort
1	SIMPLE	t6	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t13.s_id,const	1	Using where
1	SIMPLE	t8	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t13.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t13.s_id	1	Using where
1	SIMPLE	t10	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	13	ygowiki.t13.s_id,const,const	1	Using index; Distinct

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Name	Japanese name	Primary type	Secondary type	[[Attribute]]	[[Type]]	[[Level]]/ [[Rank]]	[[ATK]]	[[DEF]]
8-Claws Scorpion	八（や）つ手（で）サソリ	Effect Monster		DARK	Insect	2	300	200
A/D Changer	Ａ（エー）Ｄ（ディー）チェンジャー	Effect Monster		LIGHT	Warrior	1	100	100
Advanced Crystal Beast Emerald Tortoise	Ａ（アドバンスド）宝（ほう）玉（ぎょく）獣（じゅう）エメラルド・タートル	Effect Monster		WATER	Aqua	3	600	2000
Alchemist of Black Spells	黒（くろ）魔（ま）力（りょく）の精（せい）製（せい）者（しゃ）	Effect Monster		WIND	Spellcaster	4	1200	1800
Alien Psychic	エーリアン・サイコ	Effect Monster		DARK	Reptile	1	200	100
Ally of Justice Searcher	Ａ・Ｏ・Ｊ（アーリー・オブ・ジャスティス）リサーチャー	Effect Monster		DARK	Machine	3	1400	100
Aqua Spirit	水（みず）の精（せい）霊（れい）アクエリア	Effect Monster		WATER	Aqua	4	1600	1200
Aromage Rosemary	アロマージ－ローズマリー	Effect Monster		WATER	Plant	4	1800	700
Asset Mountis		Effect Monster		LIGHT	Insect	7	2300	2000
Avenging Knight Parshath	神聖騎士（ホーリーナイト）パーシアス	Effect Monster Synchro Monster		LIGHT	Fairy	8	2600	2100
B.E.S. Crystal Core	巨（きょ）大（だい）戦（せん）艦（かん）クリスタル・コア	Effect Monster		WATER	Machine	5	2100	1000
Berry Magician Girl	ベリー・マジシャン・ガール	Effect Monster		EARTH	Spellcaster	1	400	400
Bite Shoes	朱（あか）い靴（くつ）	Effect Monster	Flip monster	DARK	Fiend	2	500	300
Black Brachios	暗黒（ブラック）ブラキ	Effect Monster		EARTH	Dinosaur	4	1800	1100
Black Mamba	ブラックマンバ	Effect Monster		DARK	Reptile	3	1300	1000
Black Rose Dragon	ブラック・ローズ・ドラゴン	Effect Monster Synchro Monster		FIRE	Dragon	7	2400	1800
Blackwing - Elphin the Raven	ＢＦ（ブラックフェザー）－漆（しっ）黒（こく）のエルフェン	Effect Monster		DARK	Winged Beast	6	2200	1200
Blackwing - Fane the Steel Chain	ＢＦ（ブラックフェザー）－鉄（てっ）鎖（さ）のフェーン	Effect Monster		DARK	Winged Beast	2	500	800
Blackwing - Oroshi the Squall	ＢＦ（ブラックフェザー）－突（とっ）風（ぷう）のオロシ	Effect Monster	Tuner monster	DARK	Winged Beast	1	400	600
Blue-Eyes Chaos Dragon	青眼の混沌龍（ブルーアイズ・カオス・ドラゴン）	Effect Monster Ritual Monster		DARK	Dragon	8	3000	0
Borrelguard Dragon	ヴァレルガード・ドラゴン	Effect Monster Link Monster		DARK	Dragon		3000
Borrelsword Dragon	ヴァレルソード・ドラゴン	Effect Monster Link Monster		DARK	Dragon		3000
Bujingi Boar	武（ぶ）神（じん）器（ぎ）－イクタ	Effect Monster		LIGHT	Beast	4	1100	1900
Buster Blader, the Dragon Destroyer Swordsman	竜（りゅう）破（は）壊（かい）の剣（けん）士（し）－バスター・ブレイダー	Effect Monster Fusion Monster		LIGHT	Warrior	8	2800	2500
Canon the Melodious Diva	幻（げん）奏（そう）の音（おと）女（め）カノン	Effect Monster		LIGHT	Fairy	4	1400	2000
Castel, the Skyblaster Musketeer	鳥（ちょう）銃（じゅう）士（し）カステル	Effect Monster Xyz Monster		WIND	Winged Beast	4	2000	1500
Changer Synchron	チェンジ・シンクロン	Effect Monster	Tuner monster	DARK	Machine	1	0	0
Chronomaly Colossal Head	先史遺産（オーパーツ）コロッサル・ヘッド	Effect Monster		EARTH	Rock	4	800	1600
Cloudian - Eye of the Typhoon	雲魔物（クラウディアン）－アイ・オブ・ザ・タイフーン	Effect Monster		WIND	Aqua	8	3000	1000
Cobraman Sakuzy	半（はん）蛇（じゃ）人（じん）サクズィー	Effect Monster		EARTH	Reptile	3	800	1400
Constellar Hyades	セイクリッド・ヒアデス	Effect Monster Xyz Monster		LIGHT	Beast-Warrior	3	1900	1100
Cosmic Slicer Zer'oll	宇（そ）宙（ら）鋏（ばさみ）ゼロオル	Effect Monster Link Monster		LIGHT	Reptile		2600
Crystal Beast Emerald Tortoise	宝（ほう）玉（ぎょく）獣（じゅう）エメラルド・タートル	Effect Monster		WATER	Aqua	3	600	2000
Crystal God Tistina	結（けっ）晶（しょう）神（しん）ティスティナ	Effect Monster		LIGHT	Aqua	10	2000	3000
Crystron Ametrix	水晶機巧（クリストロン）－アメトリクス	Effect Monster Synchro Monster		WATER	Machine	5	2500	1500
CXyz Mechquipped Djinn Angeneral	ＣＸ（カオスエクシーズ）機（き）装（そう）魔（ま）人（じん）エンジェネラル	Effect Monster Xyz Monster		DARK	Fairy	4	2600	1600
CXyz Simon the Great Moral Leader	ＣＸ（カオスエクシーズ）風（ふう）紀（き）大（だい）宮（ぐう）司（じ）サイモン	Effect Monster Xyz Monster		LIGHT	Spellcaster	7	3000	2500
Cyberse Enchanter	サイバース・エンチャンター	Effect Monster Link Monster		LIGHT	Cyberse		2400
Cyberse Wizard	サイバース・ウィザード	Effect Monster		LIGHT	Cyberse	4	1800	800
Dante, Traveler of the Burning Abyss	彼（ひ）岸（がん）の旅（たび）人（びと）ダンテ	Effect Monster Xyz Monster		LIGHT	Warrior	3	1000	2500
Defcon Bird	デフコンバード	Effect Monster		WIND	Cyberse	3	100	1700
Demigod of the Tistina	ティスティナの半（はん）神（しん）	Effect Monster		LIGHT	Aqua	10	2000	0
Des Lacooda	デス・ラクーダ	Effect Monster		EARTH	Zombie	3	500	600
Deskbot 006	ブンボーグ０（ゼロ）０（ゼロ）６（シックス）	Effect Monster Pendulum Monster		EARTH	Machine	6	500	500
Destiny HERO - Dasher	Ｄ－ＨＥＲＯ（デステニーヒーロー）ダッシュガイ	Effect Monster		DARK	Warrior	6	2100	1000
Digital Bug Registrider	電子光虫（デジタル・バグ）－レジストライダー	Effect Monster		LIGHT	Insect	3	1000	1000
Digital Bug Scaradiator	電子光虫（デジタル・バグ）－スカラジエータ	Effect Monster Xyz Monster		LIGHT	Insect	3	1800	1400
Digital Bug Websolder	電子光虫（デジタル・バグ）－ウェブソルダー	Effect Monster		LIGHT	Insect	3	500	1500
Dragon Piper	壺（つぼ）魔（ま）人（じん）	Effect Monster	Flip monster	FIRE	Pyro	3	200	1800
Dream Cicada	夢（ゆめ）蝉（ぜみ）スイミンミン	Effect Monster		WIND	Insect	3	300	1300

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools