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]][[Card type::Monster Card]][[Effect type::Ignition Effect]]
 |?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=10
 |sort=
 |order=asc
 |mainlabel=-
}}

Results 11 – 60 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Concept:CG cards]][[Card type::Monster Card]][[Effect type::Ignition Effect]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.1303",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Concept:CG cards]] [[Card type::Monster Card]] [[Effect type::Ignition Effect]]

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 t8
INNER JOIN
(`smw_di_blob` AS t4
INNER JOIN
`smw_di_blob` AS t6 ON t4.s_id=t6.s_id) ON t8.s_id=t4.s_id
INNER JOIN
`smw_di_wikipage` AS t11 ON t8.s_id=t11.s_id) ON t0.smw_id=t8.s_id
WHERE
(t8.p_id='596' AND t8.o_id='1389'
   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 (t11.p_id='638' AND t11.o_id='1390')
  )
  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
10

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t11	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id	5	const	5214	Using where; Using temporary; Using filesort
1	SIMPLE	t4	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t11.s_id,const	1	Using where
1	SIMPLE	t6	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t11.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t11.s_id	1	Using where
1	SIMPLE	t8	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	13	ygowiki.t11.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

Name	Japanese name	Primary type	Secondary type	[[Attribute]]	[[Type]]	[[Level]]/ [[Rank]]	[[ATK]]	[[DEF]]
Abyss Actor - Trendy Understudy	魔（ま）界（かい）劇（げき）団（だん）－ダンディ・バイプレイヤー	Effect Monster Pendulum Monster		DARK	Fiend	2	700	700
Abyss Actor - Wild Hope	魔（ま）界（かい）劇（げき）団（だん）－ワイルド・ホープ	Effect Monster Pendulum Monster		DARK	Fiend	4	1600	1200
Abyss Keeper	アビス・オーパー	Effect Monster Link Monster		WATER	Fish		1500
Abyss Shark	アビス・シャーク	Effect Monster		WATER	Fish	5	1200	700
Abyss Soldier	アビス・ソルジャー	Effect Monster		WATER	Aqua	4	1800	1300
Abyss Warrior	アビス・ウォリアー	Effect Monster		WATER	Aqua	4	1800	1300
Accel Synchron	アクセル・シンクロン	Effect Monster Synchro Monster	Tuner monster	DARK	Machine	5	500	2100
Accesscode Talker	アクセスコード・トーカー	Effect Monster Link Monster		DARK	Cyberse		2300
Ace★Spades Speculation	Ａ（エー）★（スター）スペキュレーション	Effect Monster Fusion Monster		LIGHT	Warrior	7	2500	2500
Acorno	コロボックリ	Effect Monster		EARTH	Plant	1	200	400
Ad Libitum of Despia	デスピアの凶劇（アドリビトゥム）	Effect Monster		DARK	Fairy	8	1500	2000
Adamancipator Analyzer	魔救の分析者（アダマシア・アナライザー）	Effect Monster	Tuner monster	EARTH	Rock	4	1500	700
Adamancipator Crystal - Dragite	魔救の奇石（アダマシア・クリスタ）－ドラガイト	Effect Monster		WATER	Rock	4	0	2200
Adamancipator Crystal - Leonite	魔救の奇石（アダマシア・クリスタ）－レオナイト	Effect Monster		FIRE	Rock	4	0	2200
Adamancipator Crystal - Raptite	魔救の奇石（アダマシア・クリスタ）－ラプタイト	Effect Monster		WIND	Rock	4	0	2200
Adamancipator Researcher	魔救の探索者（アダマシア・リサーチャー）	Effect Monster	Tuner monster	EARTH	Rock	2	100	2100
Adamancipator Risen - Dragite	魔救の奇跡（アダマシア・ライズ）－ドラガイト	Effect Monster Synchro Monster		WATER	Rock	8	3000	2200
Adamancipator Risen - Leonite	魔救の奇跡（アダマシア・ライズ）－レオナイト	Effect Monster Synchro Monster		FIRE	Rock	6	2400	2200
Adamancipator Risen - Raptite	魔救の奇跡（アダマシア・ライズ）－ラプタイト	Effect Monster Synchro Monster		WIND	Rock	6	2200	2800
Adamancipator Seeker	魔救の追求者（アダマシア・シーカー）	Effect Monster	Tuner monster	EARTH	Rock	2	1200	1000
Adreus, Keeper of Armageddon	終（しゅう）焉（えん）の守（しゅ）護（ご）者（しゃ）アドレウス	Effect Monster Xyz Monster		DARK	Fiend	5	2600	1700
Adularia of the June Moon	水（すい）月（げつ）のアデュラリア	Effect Monster		WATER	Spellcaster	5	1000	1000
Advanced Crystal Beast Cobalt Eagle	Ａ（アドバンスド）宝（ほう）玉（ぎょく）獣（じゅう）コバルト・イーグル	Effect Monster		WIND	Winged Beast	4	1400	800
The Agent of Creation - Venus	創（そう）造（ぞう）の代（だい）行（こう）者（しゃ）ヴィーナス	Effect Monster		LIGHT	Fairy	3	1600	0
The Agent of Destruction - Venus	破（は）壊（かい）の代（だい）行（こう）者（しゃ）ヴィーナス	Effect Monster	Tuner monster	DARK	Fairy	3	0	1600
The Agent of Entropy - Uranus	死（し）の代（だい）行（こう）者（しゃ）ウラヌス	Effect Monster	Tuner monster	DARK	Fairy	5	2200	1200
The Agent of Judgment - Saturn	裁（さば）きの代（だい）行（こう）者（しゃ）サターン	Effect Monster		LIGHT	Fairy	6	2400	0
The Agent of Life - Neptune	命（いのち）の代（だい）行（こう）者（しゃ）ネプチューン	Effect Monster		LIGHT	Fairy	1	0	600
The Agent of Miracles - Jupiter	奇（き）跡（せき）の代（だい）行（こう）者（しゃ）ジュピター	Effect Monster		LIGHT	Fairy	4	1800	1000
Ahrima, the Wicked Warden	悪（あく）王（おう）アフリマ	Effect Monster		DARK	Fiend	4	1700	0
Airorca	エアジャチ	Effect Monster		WIND	Sea Serpent	3	1400	300
Akashic Magician	アカシック・マジシャン	Effect Monster Link Monster		DARK	Spellcaster		1700
Akz, the Pumer	ピューマン	Effect Monster		EARTH	Beast-Warrior	6	1500	1000
Albion the Sanctifire Dragon	真（しん）炎（えん）竜（りゅう）アルビオン	Effect Monster Fusion Monster		LIGHT	Dragon	8	3000	2500
Albion the Shrouded Dragon	黒（くろ）衣（ご）竜（りゅう）アルビオン	Effect Monster		DARK	Dragon	8	2500	2000
Alchemist of Black Spells	黒（くろ）魔（ま）力（りょく）の精（せい）製（せい）者（しゃ）	Effect Monster		WIND	Spellcaster	4	1200	1800
Alector, Sovereign of Birds	神（しん）禽（きん）王（おう）アレクトール	Effect Monster		WIND	Winged Beast	6	2400	2000
Aleirtt, the Ogdoadic Dark	溟（めい）界（かい）の昏闇（くらやみ）－アレート	Effect Monster		DARK	Reptile	8	2000	800
Alice, Lady of Lament	悪（あく）魔（ま）嬢（じょう）アリス	Effect Monster		DARK	Fiend	3	0	2000
Alich, Malebranche of the Burning Abyss	彼（ひ）岸（がん）の悪（あっ）鬼（き）アリキーノ	Effect Monster		DARK	Fiend	3	1200	0
Alien Hypno	エーリアン・ヒュプノ	Effect Monster	Gemini monster	WATER	Reptile	4	1600	700
Alien Infiltrator	エーリアン・ベーダー	Effect Monster		EARTH	Reptile	2	800	500
Alien Overlord	エーリアン・リベンジャー	Effect Monster		DARK	Reptile	6	2200	1600
Alien Stealthbuster	エーリアン・バスター	Effect Monster		LIGHT	Reptile	4	1700	1500
Alien Telepath	エーリアン・テレパス	Effect Monster		FIRE	Reptile	4	1600	1000
Allure Queen LV3	魅惑の女王（アリュール・クィーン）ＬＶ（レベル）３	Effect Monster		DARK	Spellcaster	3	500	500
Allure Queen LV5	魅惑の女王（アリュール・クィーン）ＬＶ（レベル）５	Effect Monster		DARK	Spellcaster	5	1000	1000
Allure Queen LV7	魅惑の女王（アリュール・クィーン）ＬＶ（レベル）７	Effect Monster		DARK	Spellcaster	7	1500	1500
Ally of Justice Cyclone Creator	Ａ・Ｏ・Ｊ（アーリー・オブ・ジャスティス）サイクロン・クリエイター	Effect Monster	Tuner monster	DARK	Machine	3	1400	1200
Ally of Justice Decisive Armor	Ａ・Ｏ・Ｊ（アーリー・オブ・ジャスティス）ディサイシブ・アームズ	Effect Monster Synchro Monster		DARK	Machine	10	3300	3300

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools