Difference between revisions of "Template:Card query"
Dinoguy1000 (talk | contribs) (support Cross Duel monsters sometimes having both Level and Rank) |
Dinoguy1000 (talk | contribs) (extra_column(2) support for unhiding Attribute/Type columns) |
||
| Line 167: | Line 167: | ||
| {{ #vardefine: $cq_col_primary_type | ?Primary type | | {{ #vardefine: $cq_col_primary_type | ?Primary type | ||
}}{{ #vardefine: $cq_col_secondary_type | {{ #ifeq: {{ #ask: {{ #var: $cq_full_query }} [[Secondary type::+]] | format=count }} | 0 || {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}secondary type:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}secondary type::^ }} | ?Secondary type | {{ #ifeq: {{{extra_column}}} | Secondary type | ?Secondary type }} }} | ?Secondary type }} }} | }}{{ #vardefine: $cq_col_secondary_type | {{ #ifeq: {{ #ask: {{ #var: $cq_full_query }} [[Secondary type::+]] | format=count }} | 0 || {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}secondary type:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}secondary type::^ }} | ?Secondary type | {{ #ifeq: {{{extra_column}}} | Secondary type | ?Secondary type }} }} | ?Secondary type }} }} | ||
| − | }}{{ #vardefine: $cq_col_attribute | {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}attribute:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}attribute::^ }} | ?Attribute = [[Attribute]] }} | ?Attribute = [[Attribute]] }} | + | }}{{ #vardefine: $cq_col_attribute | {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}attribute:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}attribute::^ }} | ?Attribute = [[Attribute]] | {{ #ifeq: {{{extra_column}}} | Attribute | ?Attribute = [[Attribute]] }} }} | ?Attribute = [[Attribute]] }} |
| − | }}{{ #vardefine: $cq_col_type | {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}type:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}type::^ }} | ?Type = [[Type]] }} | ?Type = [[Type]] }} | + | }}{{ #vardefine: $cq_col_type | {{ #if: {{ #pos: {{ #var: $cq_query_lc }} | {{!((}}type:: }} | {{ #if: {{ #pos: {{ #var: $cq_query_normalized }} | {{!((}}type::^ }} | ?Type = [[Type]] | {{ #ifeq: {{{extra_column2}}} | Type | ?Type = [[Type]] }} }} | ?Type = [[Type]] }} |
}}<!-- | }}<!-- | ||
* if the query doesn't do anything special regarding Level, Rank, monster (sub)type, or medium, display "Level/Rank" | * if the query doesn't do anything special regarding Level, Rank, monster (sub)type, or medium, display "Level/Rank" | ||
| Line 256: | Line 256: | ||
}} | }} | ||
}} | }} | ||
| − | }}{{ #vardefine: $cq_col_extra | {{ #if: {{{extra_column|}}} | {{ #switch: {{{extra_column}}} | Secondary type | Property = | #default= ?{{{extra_column}}} }} }} | + | }}{{ #vardefine: $cq_col_extra | {{ #if: {{{extra_column|}}} | {{ #switch: {{{extra_column}}} | Secondary type | Attribute | Property = | #default= ?{{{extra_column}}} }} }} |
| − | }}{{ #vardefine: $cq_col_extra_2 | {{ #if: {{{extra_column2|}}} | ?{{{extra_column2}}} }} | + | }}{{ #vardefine: $cq_col_extra_2 | {{ #if: {{{extra_column2|}}} | {{ #ifeq: {{{extra_column2}}} | Type || ?{{{extra_column2}}} }} }} |
}}<!-- | }}<!-- | ||
Latest revision as of 18:41, 15 May 2024
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
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 | 73128 | 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:2Query-Depth:1
Errors and Warnings
None| Showing first 50 results, of 45042 total ¦ Show next 50 results ¦ Show first [20 · 50 · 100 · 250 · 500] results (all links open a new page) |
#askquery ($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:
45042 - $cq_nonmonster_count:
22416 - $cq_spell_count:
13116 - $cq_trap_count:
8886 - $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: 45042
Template documentation
