Difference between revisions of "Template:Card query"
Dinoguy1000 (talk | contribs) (...only track them if they actually *have* a value) |
Dinoguy1000 (talk | contribs) (display only "Level" or "Rank" in the "Level/Rank" column header as appropriate (if the query searches specifically only for certain Levels or Ranks) - Card Tips:Obedience Schooled) |
||
| Line 110: | Line 110: | ||
}}{{ #vardefine: $query_col_type | {{ #if: {{ #pos: {{ #var: $query_query_lc }} | {{!((}}type:: }} || ?Type = [[Type]] }} | }}{{ #vardefine: $query_col_type | {{ #if: {{ #pos: {{ #var: $query_query_lc }} | {{!((}}type:: }} || ?Type = [[Type]] }} | ||
}}<!-- | }}<!-- | ||
| − | -->{{ #vardefine: $query_col_stars | + | -->{{ #vardefine: $query_col_level_rank_flags | {{ #if: {{ #pos: {{ #var: $query_query_lc }} | level:: }} | 1 | 0 }}{{ #if: {{ #pos: {{ #var: $query_query_lc }} | rank:: }} | 1 | 0 }} |
| − | | {{ #if: {{ #arraysearch: @check_query | /(\{{!( | + | }}{{ #ifeq: {{ #var: $query_col_level_rank_flags }} | 00 | {{ #vardefine: $query_col_level_rank_flags | 11 }} |
| + | }}{{ #vardefine: $query_col_stars | ||
| + | | {{ #if: {{ #arraysearch: @check_query | /(\{{!((}}\??(stars{{!}}level{{!}}rank){{!}}link (arrow{{!}}monster{{!}}rating))/ }} | ||
| {{ #if: {{ #arraysearch: @check_query | /(stars{{!}}level{{!}}rank)::(<{{!}}>{{!}}\d\d?\{{!}}\{{!}}\d)/ }} | | {{ #if: {{ #arraysearch: @check_query | /(stars{{!}}level{{!}}rank)::(<{{!}}>{{!}}\d\d?\{{!}}\{{!}}\d)/ }} | ||
| ?Stars string = {{ #if: {{ #arraysearch: @check_query | /(xyz( pendulum)? monster)/ }} | | ?Stars string = {{ #if: {{ #arraysearch: @check_query | /(xyz( pendulum)? monster)/ }} | ||
| | | | ||
| − | | [[Level]]/<br /> | + | | {{ #ifeq: {{ #var: $query_col_level_rank_flags }} | 10 | [[Level]] | {{ #ifeq: {{ #var: $query_col_level_rank_flags }} | 11 | [[Level]]/<br /> }} }} |
| − | }}[[Rank]] | + | }}{{ #switch: {{ #var: $query_col_level_rank_flags }} | 01 | 11 = [[Rank]] }} |
}} | }} | ||
| ?Stars string = {{ #if: {{ #arraysearch: @check_query | /(xyz( pendulum)? monster)/ }} | | ?Stars string = {{ #if: {{ #arraysearch: @check_query | /(xyz( pendulum)? monster)/ }} | ||
| | | | ||
| − | | [[Level]]/<br /> | + | | {{ #ifeq: {{ #var: $query_col_level_rank_flags }} | 10 | [[Level]] | {{ #ifeq: {{ #var: $query_col_level_rank_flags }} | 11 | [[Level]]/<br /> }} }} |
| − | }}[[Rank]] | + | }}{{ #switch: {{ #var: $query_col_level_rank_flags }} | 01 | 11 = [[Rank]] }} |
}} | }} | ||
}}<!-- | }}<!-- | ||
| Line 212: | Line 214: | ||
}}{{ #vardefine: $query_col_attribute | }}{{ #vardefine: $query_col_attribute | ||
}}{{ #vardefine: $query_col_type | }}{{ #vardefine: $query_col_type | ||
| + | }}{{ #vardefine: $query_col_level_rank_flags | ||
}}{{ #vardefine: $query_col_stars | }}{{ #vardefine: $query_col_stars | ||
}}{{ #vardefine: $query_col_scale | }}{{ #vardefine: $query_col_scale | ||
Revision as of 20:49, 14 October 2019
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 | 4174134 | 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.
#askquery:- $query_query:
- $query_query_lc:
- $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:
- $query_col_attribute:
- $query_col_type:
- $query_col_stars:
- $query_col_scale:
- $query_col_link_rating:
- $query_col_atk:
- $query_col_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
Template documentation
