Difference between revisions of "Template:Card query"
Dinoguy1000 (talk | contribs) (more debugging) |
Dinoguy1000 (talk | contribs) (support Cross Duel monsters sometimes having both Level and Rank) |
||
Line 218: | Line 218: | ||
}} | }} | ||
}} | }} | ||
− | }}{{ #vardefine: $cq_col_level/rank/link | {{ #if: {{ #var: $cq_col_level/rank/link_label }} | + | }}<!-- I'm sure I'll pay for this eventually |
− | + | -->{{ #ifeq: {{{medium}}} | Cross Duel | |
+ | | {{ #if: {{ #var: $cq_level_in_results }} | {{ #vardefine: $cq_col_level | ?Level string = [[Level]] }} | ||
+ | }}{{ #if: {{ #var: $cq_rank_in_results }} | {{ #vardefine: $cq_col_rank | ?Rank string = [[Rank]] }} | ||
+ | }} | ||
+ | | {{ #vardefine: $cq_col_level/rank/link | {{ #if: {{ #var: $cq_col_level/rank/link_label }} | ||
+ | | ?Stars string = {{ #var: $cq_col_level/rank/link_label }} | ||
+ | }} | ||
}} | }} | ||
}}<!-- | }}<!-- | ||
Line 276: | Line 282: | ||
|{{ #var: $cq_col_type }} | |{{ #var: $cq_col_type }} | ||
|{{ #var: $cq_col_level/rank/link }} | |{{ #var: $cq_col_level/rank/link }} | ||
+ | |{{ #var: $cq_col_level }} | ||
+ | |{{ #var: $cq_col_rank }} | ||
|{{ #var: $cq_col_scale }} | |{{ #var: $cq_col_scale }} | ||
|{{ #var: $cq_col_atk }} | |{{ #var: $cq_col_atk }} | ||
Line 309: | Line 317: | ||
{{ #var: $cq_col_type }} | {{ #var: $cq_col_type }} | ||
{{ #var: $cq_col_level/rank/link }} | {{ #var: $cq_col_level/rank/link }} | ||
+ | {{ #var: $cq_col_level }} | ||
+ | {{ #var: $cq_col_rank }} | ||
{{ #var: $cq_col_scale }} | {{ #var: $cq_col_scale }} | ||
{{ #var: $cq_col_atk }} | {{ #var: $cq_col_atk }} | ||
Line 359: | Line 369: | ||
-->{{ #if: {{{debug<includeonly>|</includeonly>}}} | <nowiki/> | -->{{ #if: {{{debug<includeonly>|</includeonly>}}} | <nowiki/> | ||
− | * <code>#ask</code> query: <code>{{ #tag: nowiki | {{ #var: $cq_full_query }} }}</code> | + | * <code>#ask</code> query ($cq_full_query): <code>{{ #tag: nowiki | {{ #var: $cq_full_query }} }}</code> |
* <abbr title="query entered">$cq_query</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_query }} }}</code> | * <abbr title="query entered">$cq_query</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_query }} }}</code> | ||
* <abbr title="lowercased query entered">$cq_query_lc</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_query_lc }} }}</code> | * <abbr title="lowercased query entered">$cq_query_lc</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_query_lc }} }}</code> | ||
Line 385: | Line 395: | ||
* <abbr title="determined label for Stars column">$cq_col_level/rank/link_label</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_level/rank/link_label }} }}</code> | * <abbr title="determined label for Stars column">$cq_col_level/rank/link_label</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_level/rank/link_label }} }}</code> | ||
* <abbr title="for monster cards, enable/disable «?Stars string» column">$cq_col_level/rank/link</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_level/rank/link }} }}</code> | * <abbr title="for monster cards, enable/disable «?Stars string» column">$cq_col_level/rank/link</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_level/rank/link }} }}</code> | ||
+ | * <abbr title="for Cross Duel monster cards, enable/disable «?Level string» column">$cq_col_level</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_level }} }}</code> | ||
+ | * <abbr title="for Cross Duel monster cards, enable/disable «?Rank string» column">$cq_col_rank</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_rank}} }}</code> | ||
* <abbr title="for monster cards, enable/disable «?Pendulum Scale» column">$cq_col_scale</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_scale }} }}</code> | * <abbr title="for monster cards, enable/disable «?Pendulum Scale» column">$cq_col_scale</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_scale }} }}</code> | ||
* <abbr title="for monster cards, enable/disable «?Link Rating» column">$cq_col_link_rating</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_link_rating }} }}</code> | * <abbr title="for monster cards, enable/disable «?Link Rating» column">$cq_col_link_rating</abbr>: <code>{{ #tag: nowiki | {{ #var: $cq_col_link_rating }} }}</code> | ||
Line 416: | Line 428: | ||
}}{{ #vardefine: $cq_col_level_rank_flags | }}{{ #vardefine: $cq_col_level_rank_flags | ||
}}{{ #vardefine: $cq_col_level/rank/link | }}{{ #vardefine: $cq_col_level/rank/link | ||
+ | }}{{ #vardefine: $cq_col_level | ||
+ | }}{{ #vardefine: $cq_col_rank | ||
}}{{ #vardefine: $cq_col_scale | }}{{ #vardefine: $cq_col_scale | ||
}}{{ #vardefine: $cq_col_atk | }}{{ #vardefine: $cq_col_atk |
Revision as of 16:49, 25 January 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 | 71526 | 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
NoneShowing first 50 results, of 44962 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:
44962
- $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: 44962