Template:Card query

SQLStore debug output

ASK Query

[[Card type::Monster Card]]

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,
  t0.smw_title,
  t0.smw_subobject
FROM
  `smw_object_ids` AS t0
INNER JOIN
  `smw_di_wikipage` AS t1 ON t0.smw_id=t1.s_id
WHERE
  (t1.p_id='596' AND t1.o_id='1389')
  AND t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-delete'
  AND t0.smw_iw!=':smw-redi'
ORDER BY
  t0.smw_sort ASC,
  t0.smw_title ASC,
  t0.smw_subobject ASC
LIMIT
  55
OFFSET
  0

SQL Explain

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

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:2
Query-Depth:1

Errors and Warnings

None

Showing first 50 results, of 44947 total ¦ Show next 50 results ¦ Show first [20 · 50 · 100 · 250 · 500] results (all links open a new page)

• #ask query ($cq_full_query): [[Card type::Monster Card]]
• $cq_query:
• $cq_query_lc:
• $cq_query_normalized:
• $cq_medium:
• $cq_medium_query:
• $cq_query_medium:
• $cq_card_type: monster
• $cq_card_type_query: [[Card type::Monster Card]]
• $cq_concept_query:
• $cq_monster_count: 44947
• $cq_nonmonster_count: 22379
• $cq_spell_count: 13091
• $cq_trap_count: 8875
• $cq_col_card_type: ?Card type =
• $cq_col_character:
• $cq_col_japanese_name: ?Japanese name
• $cq_col_primary_type: ?Primary type
• $cq_col_secondary_type: ?Secondary type
• $cq_col_attribute: ?Attribute = [[Attribute]]
• $cq_col_type: ?Type = [[Type]]
• $cq_level_in_results: 1
• $cq_rank_in_results: 1
• $cq_link_in_results:
• $cq_col_level/rank/link_label: [[Level]]/<br />[[Rank]]
• $cq_col_level/rank/link: ?Stars string = [[Level]]/<br />[[Rank]]
• $cq_col_level:
• $cq_col_rank:
• $cq_col_scale: ?Pendulum Scale = [[Pendulum Scale|Scale]]
• $cq_col_link_rating: ?Link Rating = [[Link Rating|Link]]
• $cq_equal_atkdef:
• $cq_col_atk: ?ATK string = [[ATK]]
• $cq_col_def: ?DEF string = [[DEF]]
• $cq_col_maximum_atk:
• $cq_col_card_type_st:
• $cq_col_property:
• {{{extra_column}}}:
• {{{extra_column2}}}:
• $cq_col_extra:
• $cq_col_extra_2:
• limit: 50
• $cq_sort: #
• $cq_order:
• $cq_default:
• $cq_count: 44947

Template documentation[create] [purge]

Editors can experiment in this template's sandbox (edit | diff) and testcases (edit) pages.
Add categories to the /doc subpage. Subpages of this template.