No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
+ | {{#cargo_query: |
||
− | + | |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" |
+ | |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