Artifact: The Dota Card Game Wiki
Register
No edit summary
No edit summary
Line 1: Line 1:
  +
{{#cargo_query:
<includeonly> |tables=card_data
+
|tables=card_data
 
|fields=CONCAT(name)=name, CONCAT(image)=image
 
|fields=CONCAT(name)=name, CONCAT(image)=image
|where=type LIKE "{{{type|%%}}}%" AND type NOT LIKE "%%Ability" {{#if: {{{keyword|}}}| AND UPPER(text) LIKE UPPER("%{{{keyword|%%}}} %") OR UPPER(text) LIKE UPPER("%[[{{{keyword|%%}}}]]%") }}
+
|where=type LIKE "{{{type|%%}}}%" AND type NOT LIKE "%%Ability" <!--
  +
-->{{#if: {{{keyword|}}} | AND UPPER(text) LIKE UPPER("%{{{keyword|}}}%") }}<!--
  +
-->{{#if: {{{crosslane|}}} | true | AND is_quick LIKE "True" }}<!--
  +
-->{{#if: {{{subtype|}}} | AND UPPER(subtype) LIKE UPPER("{{{subtype}}}") }}
 
|group by=_pageName
 
|group by=_pageName
 
|order by=color desc,type="Hero" desc,manacost,goldcost,name
 
|order by=color desc,type="Hero" desc,manacost,goldcost,name

Revision as of 23:41, 13 December 2018

Error 1054: Unknown column 'type="Hero"' in 'order clause'

Function: CargoSQLQuery::run Query: SELECT CONCAT(name) AS `name`,CONCAT(image) AS `image` FROM `cargo__card_data` WHERE type LIKE "%%%" AND type NOT LIKE "%%Ability" AND is_quick LIKE "True" GROUP BY `_pageName` ORDER BY `color` DESC,`type="Hero"` DESC,`manacost`,`goldcost`,`name` LIMIT 500