Difference between revisions of "Template:Card query"

From Yugipedia
Jump to: navigation, search
(try replacing {{!}} in Pendulum Scale link with a literal pipe character)
(temporary force results sorting)
Line 124: Line 124:
  
 
-->{{ #vardefine: $query_limit | {{ #if: {{{limit|}}} | {{ #iferror: {{ #expr: {{{limit}}} }} || {{{limit}}} }} }}
 
-->{{ #vardefine: $query_limit | {{ #if: {{{limit|}}} | {{ #iferror: {{ #expr: {{{limit}}} }} || {{{limit}}} }} }}
−
}}{{ #vardefine: $query_sort  | {{{sort|}}}
+
}}{{ #vardefine: $query_sort  | {{{sort|#}}}
 
}}{{ #vardefine: $query_order  | {{{order|}}}
 
}}{{ #vardefine: $query_order  | {{{order|}}}
 
}}{{ #vardefine: $query_count  | {{ #ask: {{ #var: $query_medium_query }}{{ #var: $query_card_type_query }}{{ #var: $query_query }} | format=count }}
 
}}{{ #vardefine: $query_count  | {{ #ask: {{ #var: $query_medium_query }}{{ #var: $query_card_type_query }}{{ #var: $query_query }} | format=count }}

Revision as of 23:54, 16 October 2018

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
SQL Explain
IDselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEt0ALLsmw_iw,smw_iw_25181047Using where; Using filesort
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:
  • $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<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>
Retrieved from "https://yugipedia.com/index.php?title=Template:Card_query&oldid=3964770"