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:Duel Links monsters]][[ATK string::1000]]
 |?English name (linked)=Name
 |?Japanese name
 |?Primary type
 |?Secondary type
 |?Attribute=[[Attribute]]
 |?Type=[[Type]]
 |?Stars string=[[Level]]/
[[Rank]]
 |?Pendulum Scale=[[Pendulum Scale|Scale]]
 |?DEF string=[[DEF]]
 |?Link Rating=[[Link Rating|Link]]
 |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:Duel Links monsters]][[ATK string::1000]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0713",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Concept:Duel Links monsters]] [[ATK string::1000]]

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 t14
INNER JOIN
(`smw_di_wikipage` AS t11
INNER JOIN
(`smw_di_wikipage` AS t6
INNER JOIN
`smw_di_blob` AS t9 ON t6.s_id=t9.s_id) ON t11.s_id=t6.s_id) ON t14.s_id=t11.s_id) ON t0.smw_id=t14.s_id
WHERE
(
   (t14.o_hash='1000') AND t14.p_id='970'
   AND (t11.p_id='596' AND t11.o_id='1389'
   AND (t6.p_id='1149' AND t6.o_id='46579'
   AND (
   (t9.o_hash='Card page') AND t9.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	t14	ref	s_id,o_hash,s_id_2,p_id	p_id	262	const,const	2598	Using index condition; Using temporary; Using filesort
1	SIMPLE	t9	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t14.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t14.s_id	1	Using where
1	SIMPLE	t6	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	13	ygowiki.t14.s_id,const,const	1	Using index; Distinct
1	SIMPLE	t11	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	13	ygowiki.t14.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]]	[[Pendulum Scale\|Scale]]	[[DEF]]
Abyss Actor - Comic Relief	魔（ま）界（かい）劇（げき）団（だん）－コミック・リリーフ	Pendulum Monster		DARK	Fiend	3	8	2000
Abyss Actor - Twinkle Little Star	魔（ま）界（かい）劇（げき）団（だん）－ティンクル・リトルスター	Pendulum Monster		DARK	Fiend	4	9	1000
Acrobat Monkey	アクロバットモンキー	Normal Monster		EARTH	Machine	3		1800
Adhesive Explosive	瞬（しゅん）着（ちゃく）ボマー	Effect Monster		WIND	Machine	3		1000
The Agent of Mystery - Earth	神（しん）秘（ぴ）の代（だい）行（こう）者（しゃ）アース	Effect Monster	Tuner monster	LIGHT	Fairy	2		800
Akakieisu	レッド・エース	Normal Monster		DARK	Spellcaster	3		800
Aleister the Invoker	召（しょう）喚（かん）師（し）アレイスター	Effect Monster		DARK	Spellcaster	4		1800
Alien Mars	エーリアン・マーズ	Effect Monster		FIRE	Reptile	3		1000
Allure Queen LV5	魅惑の女王（アリュール・クィーン）ＬＶ（レベル）５	Effect Monster		DARK	Spellcaster	5		1000
Ally of Justice Cycle Reader	Ａ・Ｏ・Ｊ（アーリー・オブ・ジャスティス）サイクルリーダー	Effect Monster	Tuner monster	DARK	Machine	3		1000
Ancient Brain	魔（ま）天（てん）老（ろう）	Normal Monster		DARK	Fiend	3		700
Ancient Sorcerer	古（こ）代（だい）魔（ま）導（どう）士（し）	Normal Monster		DARK	Spellcaster	4		1300
Anthrosaurus	恐（きょう）竜（りゅう）人（じん）	Normal Monster		EARTH	Dinosaur	3		850
Arcane Apprentice	アーケイン・ファイロ	Effect Monster	Tuner monster	FIRE	Spellcaster	2		400
Ariel, Priestess of the Nekroz	影霊衣（ネクロス）の巫（み）女（こ）エリアル	Effect Monster		WATER	Psychic	4		1800
Arma Knight	アンモ・ナイト	Normal Monster		WATER	Aqua	4		1200
The Atmosphere	Ｔｈｅ（ジ）アトモスフィア	Effect Monster		WIND	Winged Beast	8		800
Barrel Rock	ガンロック	Normal Monster		EARTH	Rock	4		1300
Barrier Statue of the Inferno	業（ごう）火（か）の結（けっ）界（かい）像（ぞう）	Effect Monster		FIRE	Pyro	4		1000
Batteryman 9-Volt	電（でん）池（ち）メン－角（かく）型（がた）	Effect Monster		LIGHT	Thunder	4		1000
Battle Footballer	バトルフットボーラー	Normal Monster		FIRE	Machine	4		2100
Battlewasp - Twinbow the Attacker	Ｂ・Ｆ（ビー・フォース）－連（れん）撃（げき）のツインボウ	Effect Monster		WIND	Insect	3		500
Battlin' Boxer Headgeared	ＢＫ（バーニングナックラー）ヘッドギア	Effect Monster		FIRE	Warrior	4		1800
Beastking of the Swamps	沼（ぬま）地（ち）の魔（ま）獣（じゅう）王（おう）	Effect Monster		WATER	Aqua	4		1100
Big Belly Knight	三（さん）段（だん）腹（ばら）ナイト	Effect Monster		EARTH	Warrior	4		1600
Big Whale	ビッグ・ホエール	Effect Monster		WATER	Fish	9		3000
Binding Chain	封（ふう）印（いん）の鎖（くさり）	Normal Monster		LIGHT	Fairy	3		1100
Black Ptera	暗黒（ブラック）プテラ	Effect Monster		WIND	Dinosaur	3		500
Blackwing - Decay the Ill Wind	ＢＦ（ブラックフェザー）－弔（とむらい）風（かぜ）のデス	Effect Monster	Tuner monster	DARK	Winged Beast	4		1000
Blackwing - Tornado the Reverse Wind	ＢＦ（ブラックフェザー）－逆（さか）巻（まき）のトルネード	Effect Monster		DARK	Winged Beast	4		1200
Blast Asmodian	連爆魔人（ブラスト・デビル）	Effect Monster		FIRE	Fiend	3		300
Block Golem	ブロック・ゴーレム	Effect Monster		EARTH	Rock	3		1500
Block Token	ブロックトークン	Monster Token		EARTH	Rock	4		1500
Blockman	ブロックマン	Effect Monster		EARTH	Rock	4		1500
Bloom Diva the Melodious Choir	幻（げん）奏（そう）の華（はな）歌（か）聖（せい）ブルーム・ディーヴァ	Fusion Monster		LIGHT	Fairy	6		2000
Blue-Blooded Oni	蒼（そう）血（けつ）鬼（き）	Effect Monster		DARK	Zombie	4		1700
Boycotton	ボイコットン	Effect Monster		EARTH	Plant	4		2500
Brinegir	ブライニグル	Effect Monster		WATER	Sea Serpent	7		2600
Brotherhood of the Fire Fist - Elephant	俊（しゅん）炎（えん）星（せい）－ゾウセイ	Effect Monster		FIRE	Beast-Warrior	4		1800
Bujin Hiruko	武（ぶ）神（じん）－ヒルコ	Normal Monster Pendulum Monster		LIGHT	Beast-Warrior	4	3	2000
Burning Skull Head	バーニング・スカルヘッド	Effect Monster		FIRE	Zombie	3		800
Cannonball Spear Shellfish	砲（ほう）弾（だん）ヤリ貝（がい）	Effect Monster		WATER	Aqua	2		1000
Carrierroid	ネイビィロイド	Effect Monster		WATER	Machine	4		800
Catapult Turtle	カタパルト・タートル	Effect Monster		WATER	Aqua	5		2000
Chain Thrasher	チェイン・スラッシャー	Effect Monster		WIND	Warrior	4		600
Chronomaly Tuspa Rocket	先史遺産（オーパーツ）トゥスパ・ロケット	Effect Monster		EARTH	Rock	4		1000
Cipher Biplane	光波複葉機（サイファー・バイプレーン）	Effect Monster		LIGHT	Machine	6		2000
Claw Reacher	キラー・ザ・クロー	Normal Monster		DARK	Fiend	3		800
Cloudian - Nimbusman	雲魔物（クラウディアン）－ニンバスマン	Effect Monster		WATER	Fairy	5		1000
Cloudian - Storm Dragon	雲魔物（クラウディアン）－ストーム・ドラゴン	Effect Monster		WATER	Fairy	4		0

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools