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 non-monster cards]][[MonsterSpellTrap::Prevents activation of Spell Cards||Prevents activation of your Spell Cards||Prevents activation of your opponent's Spell Cards]]
 |?English name (linked)=Name
 |?Japanese name
 |?Card type=[[Card type]]
 |?Property=[[Property]]
 |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 non-monster cards]][[MonsterSpellTrap::Prevents activation of Spell Cards||Prevents activation of your Spell Cards||Prevents activation of your opponent's Spell Cards]]",
    "query_source": "SMWSQLStore",
    "query_time": "0.0390",
    "from_cache": false
}

SQLStore debug output

ASK Query

[[Concept:CG non-monster cards]] [[MonsterSpellTrap::Prevents activation of Spell Cards||Prevents activation of your Spell Cards||Prevents activation of your opponent's Spell 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 t24
INNER JOIN
`t26` AS t26 ON t24.o_id=t26.id
INNER JOIN
(`smw_di_wikipage` AS t11
INNER JOIN
`t13` AS t13 ON t11.o_id=t13.id
INNER JOIN
(`smw_di_blob` AS t6
INNER JOIN
`smw_di_blob` AS t8 ON t6.s_id=t8.s_id) ON t11.s_id=t6.s_id) ON t24.s_id=t11.s_id) ON t0.smw_id=t24.s_id
WHERE
(t24.p_id='556'
   AND (t11.p_id='596'
   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	t26	ALL	PRIMARY				3	Using temporary; Using filesort
1	SIMPLE	t24	ref	s_id,o_id,p_id,s_id_2,s_id_3,o_id_2,o_id_3	o_id_3	9	ygowiki.t26.id,const	12
1	SIMPLE	t6	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t24.s_id,const	1	Using where
1	SIMPLE	t8	ref	s_id,o_hash,s_id_2,p_id	s_id	8	ygowiki.t24.s_id,const	1	Using where
1	SIMPLE	t0	eq_ref	PRIMARY,smw_id,smw_iw,smw_iw_2	PRIMARY	4	ygowiki.t24.s_id	1	Using where
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	8	ygowiki.t24.s_id,const	1	Using where; Using index; Distinct
1	SIMPLE	t13	eq_ref	PRIMARY	PRIMARY	4	ygowiki.t11.o_id	1	Distinct

Auxilliary Tables

Temporary table t26
  INSERT IGNORE INTO `t26` (id) VALUES ('2218')
  INSERT IGNORE INTO `t26` (id) VALUES ('3445')
  INSERT IGNORE INTO `t26` (id) VALUES ('13599')
Temporary table t13
  INSERT IGNORE INTO `t13` (id) VALUES ('1329')
  INSERT IGNORE INTO `t13` (id) VALUES ('1787')
  INSERT IGNORE INTO `t13` (id) VALUES ('87260')
  INSERT IGNORE INTO `t13` (id) VALUES ('70265')
  INSERT IGNORE INTO `t13` (id) VALUES ('2881')
  INSERT IGNORE INTO `t13` (id) VALUES ('77217')
  INSERT IGNORE INTO `t13` (id) VALUES ('769993')
  INSERT IGNORE INTO `t13` (id) VALUES ('72320')
  INSERT IGNORE INTO `t13` (id) VALUES ('0')
  INSERT IGNORE INTO `t13` (id) VALUES ('38099')

Query Metrics

Query-Size:5
Query-Depth:1

Errors and Warnings

None

Name	Japanese name	[[Card type]]	[[Property]]
A.I. Challenge You	果（は）たし－Ａｉ（アイ）－	Trap Card	Continuous Trap Card
Absolute Powerforce	アブソリュート・パワーフォース	Spell Card	Quick-Play Spell Card
Abyss Script - Rise of the Abyss King	魔（ま）界（かい）台（だい）本（ほん）「魔（ま）王（おう）の降（こう）臨（りん）」	Spell Card	Normal Spell Card
Abyss-sphere	アビスフィアー	Trap Card	Continuous Trap Card
Ancient Gear Drill	古代の採掘機（アンティーク・ギアドリル）	Spell Card	Normal Spell Card
Ancient Warriors Saga - Defense of Changban	戦（せん）華（か）史（し）略（りゃく）－長（ちょう）坂（はん）之（の）雄（ゆう）	Trap Card	Continuous Trap Card
Anti-Magic Arrows	封（ふう）魔（ま）の矢（や）	Spell Card	Quick-Play Spell Card
Anti-Spell Fragrance	魔（ま）封（ふう）じの芳（ほう）香（こう）	Trap Card	Continuous Trap Card
Aqua Chorus Round	アクアの輪（りん）唱（しょう）	Spell Card	Normal Spell Card
Armageddon Designator	終（しゅう）焉（えん）の指（し）名（めい）者（しゃ）	Trap Card	Normal Trap Card
Bayonet Punisher	ベイオネット・パニッシャー	Spell Card	Quick-Play Spell Card
The Big Cattle Drive	烏（う）合（ごう）の行（こう）進（しん）	Spell Card	Normal Spell Card
Bownty	犬（けん）賞（しょう）金（きん）	Spell Card	Quick-Play Spell Card
Branded Lost	失（しつ）烙（らく）印（いん）	Spell Card	Continuous Spell Card
Bujin Regalia - The Mirror	鏡（きょう）鳴（めい）する武（ぶ）神（じん）	Spell Card	Normal Spell Card
Call of Darkness	闇（やみ）からの呼（よ）び声（ごえ）	Trap Card	Continuous Trap Card
Chicken Game	チキンレース	Spell Card	Field Spell Card
Closed Forest	クローザー・フォレスト	Spell Card	Field Spell Card
Cold Feet	大（だい）寒（かん）気（き）	Spell Card	Quick-Play Spell Card
Cold Wave	大（だい）寒（かん）波（ぱ）	Spell Card	Normal Spell Card
Confusion Chaff	コンフュージョン・チャフ	Trap Card	Normal Trap Card
Crusadia Testament	テスタメント・パラディオン	Spell Card	Quick-Play Spell Card
Cursed Seal of the Forbidden Spell	封（ふう）魔（ま）の呪（じゅ）印（いん）	Trap Card	Counter Trap Card
Cynet Conflict	サイバネット・コンフリクト	Trap Card	Counter Trap Card
Cynet Optimization	サイバネット・オプティマイズ	Spell Card	Continuous Spell Card
Dark Magic Expanded	黒魔導強化（マジック・エクスパンド）	Spell Card	Quick-Play Spell Card
Darkness/Trap A	ダークネス／罠（トラップ）Ａ	Trap Card	Continuous Trap Card
Darkness/Trap B	ダークネス／罠（トラップ）Ｂ	Trap Card	Continuous Trap Card
Dimension Fusion Destruction	次（じ）元（げん）融（ゆう）合（ごう）殺（さつ）	Spell Card	Normal Spell Card
Dinomic Powerload	ダイナミックＰ（パワーロード）	Spell Card	Field Spell Card
Draw of Fate	運（うん）命（めい）のドロー	Spell Card	Normal Spell Card
Dust Storm of Gusto	ガスタの風（ふう）塵（じん）	Trap Card	Normal Trap Card
Echelon of the Fire Kings	炎（えん）王（おう）の結（けっ）襲（しゅう）	Trap Card	Normal Trap Card
Equip Shot	イクイップ・シュート	Trap Card	Normal Trap Card
Eternal Favorite	エターナル・フェイバリット	Trap Card	Continuous Trap Card
Evo-Karma	進（しん）化（か）の宿（しゅく）命（めい）	Spell Card	Continuous Spell Card
Exodo Blaze	魔神火焔砲（エグゾード・ブレイズ）	Spell Card	Quick-Play Spell Card
Fairy of the Spring	泉（いずみ）の精（せい）霊（れい）	Spell Card	Normal Spell Card
Field Barrier	フィールドバリア	Spell Card	Continuous Spell Card
Fire Formation - Gyokkou	炎（えん）舞（ぶ）－「玉（ギョッ）衝（コウ）」	Spell Card	Continuous Spell Card
Fire Fortress atop Liang Peak	炎（えん）傑（けつ）の梁（りょう）山（ざん）閣（かく）	Spell Card	Field Spell Card
Flame Swordsrealm		Spell Card	Continuous Spell Card
Forbidden Droplet	禁（きん）じられた一（ひと）滴（しずく）	Spell Card	Quick-Play Spell Card
Frozen Domain Leading to the Ice Barrier	氷（ひょう）結（けっ）界（かい）に至（いた）る晶（しょう）域（いき）	Trap Card	Continuous Trap Card
Galloping Gaia	走（そう）破（は）するガイア	Spell Card	Field Spell Card
Gravekeeper's Inscription	墓（はか）守（もり）の刻（こく）印（いん）	Spell Card	Normal Spell Card
Gravekeeper's Trap	墓（はか）守（もり）の罠（わな）	Trap Card	Continuous Trap Card
Grinning Grave Virus	悪（あく）のデッキ破（は）壊（かい）ウイルス	Trap Card	Normal Trap Card
Heavenly Gate of the Mikanko	天（あまつ）御巫（みかんこ）の闔（とびら）	Spell Card	Field Spell Card
Hi-Five the Sky	かっとビング・チャレンジ	Trap Card	Normal Trap Card

Semantic search

Query log

Navigation menu

Personal tools

Namespaces

Variants

Views

More

Search

Navigation

Content

Community

Tools