Difference between revisions of "Template:Card query"
(Restoring revision 5181833 by User:Dinoguy1000 on 2023-02-10 14:15:07. "fix the first query on Card Tips:Revolution Synchron: that query currently has a query size of 16, which is fine, except this template uses the full query plus `[[MAXIMUM A...) |
Dinoguy1000 (talk | contribs) (fix MAXIMUM ATK column determination (the value of `$cq_medium` is always lowercase)) |
||
Line 219: | Line 219: | ||
| {{ #if: {{ #var: $cq_equal_atkdef }} || ?DEF string = [[DEF]] }} | | {{ #if: {{ #var: $cq_equal_atkdef }} || ?DEF string = [[DEF]] }} | ||
}} }} | }} }} | ||
− | }}{{ #vardefine: $cq_col_maximum_atk | {{ #ifeq: {{ #var: $cq_medium }} | | + | }}{{ #vardefine: $cq_col_maximum_atk | {{ #ifeq: {{ #var: $cq_medium }} | rush duel | {{ #ifeq: {{ #ask: {{ #var: $cq_full_query }} [[MAXIMUM ATK::+]] | format=count }} | 0 || ?MAXIMUM ATK#- = [[MAXIMUM ATK]] }} }} |
}} | }} | ||
| {{ #vardefine: $cq_col_property | {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}property:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}property::^ }} | ?Property = [[Property]] }} | ?Property = [[Property]] }} | | {{ #vardefine: $cq_col_property | {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}property:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}property::^ }} | ?Property = [[Property]] }} | ?Property = [[Property]] }} |
Revision as of 10:45, 6 April 2023
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,
t0.smw_title,
t0.smw_subobject
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,
t0.smw_title ASC,
t0.smw_subobject ASC
LIMIT
55
OFFSET
0
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
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,
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 | t0 | ALL | smw_iw,smw_iw_2 | 4826705 | Using where; Using filesort |
Auxilliary Tables
No auxilliary tables used.Query Metrics
Query-Size:0Query-Depth:0
Errors and Warnings
The query description has an empty condition.The query description has an empty condition.
#ask
query:- $cq_query:
- $cq_query_lc:
- $cq_query_normalized:
- $cq_medium:
- $cq_medium_query:
- $cq_query_medium:
- $cq_card_type:
- $cq_card_type_query:
- $cq_concept_query:
- $cq_col_card_type:
?Card type =
- $cq_col_primary_type:
- $cq_col_secondary_type:
- $cq_col_attribute:
- $cq_col_type:
- $cq_col_level/rank/link:
- $cq_col_scale:
- $cq_col_link_rating:
- $cq_col_atk:
- $cq_col_def:
- $cq_col_maximum_atk:
- $cq_col_card_type_st:
?Card type = [[Card type]]
- $cq_col_property:
?Property = [[Property]]
{{{extra_column}}}
:{{{extra_column2}}}
:- $cq_col_extra:
- $cq_col_extra_2:
- limit: 50
- $cq_sort:
#
- $cq_order:
- $cq_default:
- $cq_count: 0