Difference between revisions of "User:Sanhard/Sandbox"

From Artifact: The Dota Card Game Wiki
Jump to: navigation, search
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

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

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 Function: CargoSQLQuery::run Error: 1054 Unknown column 'color desc' in 'order clause' (geo-db-i-master.query.consul.)