Difference between revisions of "User:Fimbulvetr/Sandbox 4"

From A3! Wiki
Line 1: Line 1:
{| class="wikitable a3table sortable"
 
|-
 
! Link Skill
 
! Characters
 
! Description
 
! Bonus
 
|- style="height: 3em;"
 
 
{{#cargo_query:
 
{{#cargo_query:
tables=Link_Skill
+
table=Cards
|fields=linkname,troupe,chara1,chara2,chara3,chara4,description,attribute,bonus
+
|fields=rarity,cardname
|where="Sakuya Sakuma" IN(chara1,chara2,chara3,chara4)
+
|where=Cards.character LIKE "Yuki%" AND Cards.rarity LIKE "N"
|format=template
+
|format=ul
|template=Link Skill/Row
 
|named args=yes
 
|order by=bonus DESC
 
 
}}
 
}}
|}
 

Revision as of 14:13, 13 October 2017

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

Query: SELECT `rarity` AS `rarity`,`cardname` AS `cardname` FROM `mw_cargo__Cards` WHERE `mw_cargo__Cards`.`character` LIKE "Yuki%" AND `mw_cargo__Cards`.`rarity` LIKE "N" ORDER BY `rarity`, `cardname` LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'mw_cargo__Cards.character' in 'WHERE' (localhost)