Template:Card query

{{ #ifeq: | monster

|

SQLStore debug output

ASK Query

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
WHERE
  t0.smw_iw!=':smw'
  AND t0.smw_iw!=':smw-redi'
  AND t0.smw_iw!=':smw-border'
  AND t0.smw_iw!=':smw-intprop'
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	t0	index	smw_iw,smw_iw_2	smw_sort	262		55	Using where

Auxilliary Tables

No auxilliary tables used.

Query Metrics

Query-Size:0
Query-Depth:0

Errors and Warnings

The part "{{{1}}}" of the query was not understood. Results might not be as expected.
Some subquery has no valid condition.

<ul><li>The part "{{{1}}}" of the query was not understood.Results might not be as expected.</li> <!--br--><li>Some subquery has no valid condition.</li></ul>

• #ask query: {{{1}}}
• $query_query: {{{1}}}
• $query_query_lc: {{{1}}}
• $query_medium:
• $query_medium_query:
• $query_query_medium:
• $query_card_type:
• $query_card_type_query:
• $query_col_card_type: ?Card type =
• $query_col_primary_type:
• $query_col_secondary_type: ?Secondary type
• $query_col_attribute: ?Attribute = [[Attribute]]
• $query_col_type: ?Type = [[Type]]
• $query_col_stars: ?Stars string = [[Level]]/[[Rank]]
• $query_col_scale:
• $query_col_link_rating:
• $query_col_atk: ?ATK string = [[ATK]]
• $query_col_def: ?DEF string = [[DEF]]
• $query_col_card_type_st: ?Card type = [[Card type]]
• $query_col_property: ?Property = [[Property]]
• {{{extra_column}}}:
• {{{extra_label}}}:
• $query_col_extra:
• limit: 50
• $query_sort:
• $query_order:
• $query_count: 0<ul><li>The part "{{{1}}}" of the query was not understood.Results might not be as expected.</li> <!--br--><li>Some subquery has no valid condition.</li></ul>

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.