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]][[Archseries::Six Samurai]]
 |?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=Name
}}

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

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Card type::Monster Card]][[Archseries::Six Samurai]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0398",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Card type::Monster Card]] [[Archseries::Six Samurai]]

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_wikipage` AS t5 ON t2.s_id=t5.s_id) ON t0.smw_id=t2.s_id
WHERE
(t2.p_id='596' AND t2.o_id='1389'
   AND (t5.p_id='559' AND t5.o_id='70249')
  )
  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	t5	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id_3	9	const,const	65	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	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:4
Query-Depth:1

Errors and Warnings

None

Name	Japanese name	Primary type	Secondary type	[[Attribute]]	[[Type]]	[[Level]]/ [[Rank]]	[[ATK]]	[[DEF]]
Battle Shogun of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）の軍（ぐん）大（だい）将（しょう）	Effect Monster Link Monster		EARTH	Warrior		1000
Chamberlain of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）の侍（じ）従（じゅう）	Normal Monster		EARTH	Warrior	3	200	2000
Chamberlain of the Six Samurai (Duel Links)	六（ろく）武（ぶ）衆（しゅう）の侍（じ）従（じゅう）	Normal Monster		EARTH	Warrior	3	200	2000
Elder of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）のご隠（いん）居（きょ）	Effect Monster		EARTH	Warrior	3	400	0
Elder of the Six Samurai (Duel Links)	六（ろく）武（ぶ）衆（しゅう）のご隠（いん）居（きょ）	Effect Monster		EARTH	Warrior	3	400	0
Grandmaster of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）の師（し）範（はん）	Effect Monster		EARTH	Warrior	5	2100	800
Grandmaster of the Six Samurai (Duel Links)	六（ろく）武（ぶ）衆（しゅう）の師（し）範（はん）	Effect Monster		EARTH	Warrior	5	2100	800
Hand of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）の露（つゆ）払（はら）い	Effect Monster		FIRE	Warrior	3	1600	1000
Hand of the Six Samurai (Duel Links)	六（ろく）武（ぶ）衆（しゅう）の露（つゆ）払（はら）い	Effect Monster		FIRE	Warrior	3	1600	1000
Kagemusha of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）の影（かげ）武（む）者（しゃ）	Effect Monster	Tuner monster	EARTH	Warrior	2	400	1800
Kagemusha of the Six Samurai (Duel Links)	六（ろく）武（ぶ）衆（しゅう）の影（かげ）武（む）者（しゃ）	Effect Monster	Tuner monster	EARTH	Warrior	2	400	1800
Legendary Secret of the Six Samurai	六（ろく）武（ぶ）衆（しゅう）の真（しん）影（えい）	Effect Monster		DARK	Warrior	4	500	2000
Legendary Secret of the Six Samurai (Duel Links)	六（ろく）武（ぶ）衆（しゅう）の真（しん）影（えい）	Effect Monster		DARK	Warrior	4	500	2000
Legendary Six Samurai - Enishi	真（しん）六（ろく）武（ぶ）衆（しゅう）－エニシ	Effect Monster		LIGHT	Warrior	4	1700	700
Legendary Six Samurai - Enishi (Duel Links)	真（しん）六（ろく）武（ぶ）衆（しゅう）－エニシ	Effect Monster		LIGHT	Warrior	4	1700	700
Legendary Six Samurai - Kageki	真（しん）六（ろく）武（ぶ）衆（しゅう）－カゲキ	Effect Monster		WIND	Warrior	3	200	2000
Legendary Six Samurai - Kageki (Duel Links)	真（しん）六（ろく）武（ぶ）衆（しゅう）－カゲキ	Effect Monster		WIND	Warrior	3	200	2000
Legendary Six Samurai - Kizan	真（しん）六（ろく）武（ぶ）衆（しゅう）－キザン	Effect Monster		EARTH	Warrior	4	1800	500
Legendary Six Samurai - Kizan (Duel Links)	真（しん）六（ろく）武（ぶ）衆（しゅう）－キザン	Effect Monster		EARTH	Warrior	4	1800	500
Legendary Six Samurai - Mizuho	真（しん）六（ろく）武（ぶ）衆（しゅう）－ミズホ	Effect Monster		FIRE	Warrior	3	1600	1000
Legendary Six Samurai - Mizuho (Duel Links)	真（しん）六（ろく）武（ぶ）衆（しゅう）－ミズホ	Effect Monster		FIRE	Warrior	3	1600	1000
Legendary Six Samurai - Shi En	真（しん）六（ろく）武（ぶ）衆（しゅう）－シエン	Effect Monster Synchro Monster		DARK	Warrior	5	2500	1400
Legendary Six Samurai - Shi En (Duel Links)	真（しん）六（ろく）武（ぶ）衆（しゅう）－シエン	Synchro Monster		DARK	Warrior	5	2500	1400
Legendary Six Samurai - Shinai	真（しん）六（ろく）武（ぶ）衆（しゅう）－シナイ	Effect Monster		WATER	Warrior	3	1500	1500
Legendary Six Samurai - Shinai (Duel Links)	真（しん）六（ろく）武（ぶ）衆（しゅう）－シナイ	Effect Monster		WATER	Warrior	3	1500	1500
Secret Six Samurai - Doji	影（かげ）六（ろく）武（ぶ）衆（しゅう）－ドウジ	Effect Monster		DARK	Warrior	4	1700	1200
Secret Six Samurai - Doji (Duel Links)	影（かげ）六（ろく）武（ぶ）衆（しゅう）－ドウジ	Effect Monster		DARK	Warrior	4	1700	1200
Secret Six Samurai - Fuma	影（かげ）六（ろく）武（ぶ）衆（しゅう）－フウマ	Effect Monster	Tuner monster	WIND	Warrior	1	200	1800
Secret Six Samurai - Fuma (Duel Links)	影（かげ）六（ろく）武（ぶ）衆（しゅう）－フウマ	Effect Monster	Tuner monster	WIND	Warrior	1	200	1800
Secret Six Samurai - Genba	影（かげ）六（ろく）武（ぶ）衆（しゅう）－ゲンバ	Effect Monster	Tuner monster	FIRE	Warrior	2	500	2100
Secret Six Samurai - Genba (Duel Links)	影（かげ）六（ろく）武（ぶ）衆（しゅう）－ゲンバ	Effect Monster	Tuner monster	FIRE	Warrior	2	500	2100
Secret Six Samurai - Hatsume	影（かげ）六（ろく）武（ぶ）衆（しゅう）－ハツメ	Effect Monster		WATER	Warrior	3	1600	1500
Secret Six Samurai - Hatsume (Duel Links)	影（かげ）六（ろく）武（ぶ）衆（しゅう）－ハツメ	Effect Monster		WATER	Warrior	3	1600	1500
Secret Six Samurai - Kizaru	影（かげ）六（ろく）武（ぶ）衆（しゅう）－キザル	Effect Monster		EARTH	Warrior	4	1900	1000
Secret Six Samurai - Kizaru (Duel Links)	影（かげ）六（ろく）武（ぶ）衆（しゅう）－キザル	Effect Monster		EARTH	Warrior	4	1900	1000
Secret Six Samurai - Rihan	影（かげ）六（ろく）武（ぶ）衆（しゅう）－リハン	Effect Monster Fusion Monster		LIGHT	Warrior	5	2400	2400
Secret Six Samurai - Rihan (Duel Links)	影（かげ）六（ろく）武（ぶ）衆（しゅう）－リハン	Fusion Monster		LIGHT	Warrior	5	2400	2400
Shadow of the Six Samurai - Shien	六（ろく）武（ぶ）衆（しゅう）の影（かげ）－紫（シ）炎（エン）	Effect Monster Xyz Monster		EARTH	Warrior	4	2500	400
Shadow of the Six Samurai - Shien (Duel Links)	六（ろく）武（ぶ）衆（しゅう）の影（かげ）－紫（シ）炎（エン）	Xyz Monster		EARTH	Warrior	4	2500	400
The Six Samurai - Irou	六（ろく）武（ぶ）衆（しゅう）－イロウ	Effect Monster		DARK	Warrior	4	1700	1200
The Six Samurai - Irou (Duel Links)	六（ろく）武（ぶ）衆（しゅう）－イロウ	Effect Monster		DARK	Warrior	4	1700	1200
The Six Samurai - Kamon	六（ろく）武（ぶ）衆（しゅう）－カモン	Effect Monster		FIRE	Warrior	3	1500	1000
The Six Samurai - Kamon (Duel Links)	六（ろく）武（ぶ）衆（しゅう）－カモン	Effect Monster		FIRE	Warrior	3	1500	1000
The Six Samurai - Nisashi	六（ろく）武（ぶ）衆（しゅう）－ニサシ	Effect Monster		WIND	Warrior	4	1400	700
The Six Samurai - Nisashi (anime)	六（ろく）武（ぶ）衆（しゅう）－ニサシ	Effect Monster		WIND	Warrior	4	1400	700
The Six Samurai - Nisashi (Duel Links)	六（ろく）武（ぶ）衆（しゅう）－ニサシ	Effect Monster		WIND	Warrior	4	1400	700
The Six Samurai - Yaichi	六（ろく）武（ぶ）衆（しゅう）－ヤイチ	Effect Monster		WATER	Warrior	3	1300	800
The Six Samurai - Yaichi (Duel Links)	六（ろく）武（ぶ）衆（しゅう）－ヤイチ	Effect Monster		WATER	Warrior	3	1300	800
The Six Samurai - Yariza	六（ろく）武（ぶ）衆（しゅう）－ヤリザ	Effect Monster		EARTH	Warrior	3	1000	500
The Six Samurai - Yariza (anime)	六（ろく）武（ぶ）衆（しゅう）－ヤリザ	Effect Monster		EARTH	Warrior	3	1000	500

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools