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:Non-monster cards]][[MonsterSpellTrap::Negates the activation of your opponent's Trap Cards]]
 |?Japanese name
 |?Card type=[[Card type]]
 |?Property=[[Property]]
 |format=broadtable
 |limit=50
 |offset=50
 |sort=
 |order=asc
 |mainlabel=Name
}}

Results 51 – 81 previous 50 20 50 100 250 500 next 50

JSON CSV RSS RDF

Query log

{
    "query_string": "[[Concept:Non-monster cards]][[MonsterSpellTrap::Negates the activation of your opponent's Trap Cards]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0554",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Concept:Non-monster cards]] [[MonsterSpellTrap::Negates the activation of your opponent's Trap Cards]]

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 t3
INNER JOIN
`t5` AS t5 ON t3.o_id=t5.id
INNER JOIN
`smw_di_wikipage` AS t16 ON t3.s_id=t16.s_id) ON t0.smw_id=t3.s_id
WHERE
(t3.p_id='596'
   AND (t16.p_id='556' AND t16.o_id='2297')
  )
  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
50

SQL Explain

ID	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t16	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id	5	const	200	Using where; Using temporary; Using filesort
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t16.s_id	1	Using where
1	SIMPLE	t3	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	s_id_3	8	ygowiki.t16.s_id,const	1	Using where; Using index; Distinct
1	SIMPLE	t5	eq_ref	PRIMARY	PRIMARY	4	ygowiki.t3.o_id	1	Distinct

Auxilliary Tables

Temporary table t5
  INSERT IGNORE INTO `t5` (id) VALUES ('1329')
  INSERT IGNORE INTO `t5` (id) VALUES ('1787')
  INSERT IGNORE INTO `t5` (id) VALUES ('87260')
  INSERT IGNORE INTO `t5` (id) VALUES ('70265')
  INSERT IGNORE INTO `t5` (id) VALUES ('2881')
  INSERT IGNORE INTO `t5` (id) VALUES ('77217')
  INSERT IGNORE INTO `t5` (id) VALUES ('769993')
  INSERT IGNORE INTO `t5` (id) VALUES ('72320')
  INSERT IGNORE INTO `t5` (id) VALUES ('0')
  INSERT IGNORE INTO `t5` (id) VALUES ('38099')

Query Metrics

Query-Size:3
Query-Depth:1

Errors and Warnings

None

Name	Japanese name	[[Card type]]	[[Property]]
My Body as a Shield (Duel Links)	我（わ）が身（み）を盾（たて）に	Spell Card	Quick-Play Spell Card
Phantom Knights' Spear (anime)	幻影死槍（ファントム・デススピア）	Spell Card	Continuous Spell Card
Power Change Barrier	パワー・チェンジ・バリア	Trap Card	Continuous Trap Card
Protection of the Elements (manga)	エレメントの加（か）護（ご）	Trap Card	Counter Trap Card
Raptor's Gust	ラプターズ・ガスト	Trap Card	Counter Trap Card
Raptor's Storm	ラプターズ・ストーム	Trap Card	Counter Trap Card
Red Reboot	レッド・リブート	Trap Card	Counter Trap Card
Retort	しっぺ返（がえ）し	Trap Card	Counter Trap Card
Retort (Duel Links)	しっぺ返（がえ）し	Trap Card	Counter Trap Card
Royal Surrender	王（おう）宮（きゅう）の陥（かん）落（らく）	Trap Card	Counter Trap Card
Royal Surrender (Duel Links)	王（おう）宮（きゅう）の陥（かん）落（らく）	Trap Card	Counter Trap Card
Sea King's Verdict	深（しん）海（かい）王（おう）の宣（せん）告（こく）	Trap Card	Counter Trap Card
Showdown of the Secret Sense Scroll Techniques	見（み）切（き）りの極（ごく）意（い）	Trap Card	Counter Trap Card
Showdown of the Secret Sense Scroll Techniques (Duel Links)	見（み）切（き）りの極（ごく）意（い）	Trap Card	Counter Trap Card
Snowfall Sword	残（ざん）雪（せつ）剣（けん）	Spell Card	Quick-Play Spell Card
Space Gate	スペース・ゲート	Trap Card	Normal Trap Card
Spirit Shield	死（し）霊（りょう）の盾（たて）	Trap Card	Continuous Trap Card
Tachyon Transmigration	タキオン・トランスミグレイション	Trap Card	Counter Trap Card
Tachyon Transmigration (Duel Links)	タキオン・トランスミグレイション	Trap Card	Counter Trap Card
Trap Jammer	トラップ・ジャマー	Trap Card	Counter Trap Card
Trap Jammer (anime)	トラップ・ジャマー	Trap Card	Counter Trap Card
Trap Jammer (Duel Links)	トラップ・ジャマー	Trap Card	Counter Trap Card
Trap Jammer (later anime)	トラップ・ジャマー	Trap Card	Counter Trap Card
Ultimate Fire Formation - Sinto	極（ごく）炎（えん）舞（ぶ）－「辰（シン）斗（ト）」	Trap Card	Counter Trap Card
Ultimate Fire Formation - Sinto (Duel Links)	極（ごく）炎（えん）舞（ぶ）－「辰（シン）斗（ト）」	Trap Card	Counter Trap Card
Vanquish Soul Calamity Caesar	ＶＳ（ヴァンキッシュ・ソウル）龍帝ノ槍（カラミティ・カイザー）	Trap Card	Counter Trap Card
Wings of Misdirection	ミスディレクションの翼（つばさ）	Trap Card	Normal Trap Card
Wiretap (anime)	ギャクタン	Trap Card	Counter Trap Card
World Legacy's Sorrow	星（せい）遺（い）物（ぶつ）に響（ひび）く残（ざん）叫（きょう）	Trap Card	Counter Trap Card
Yosenjus' Secret Move	妖（よう）仙（せん）獣（じゅう）の秘（ひ）技（ぎ）	Trap Card	Counter Trap Card
Yosenjus' Secret Move (Duel Links)	妖（よう）仙（せん）獣（じゅう）の秘（ひ）技（ぎ）	Trap Card	Counter Trap Card

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools