Template:DeconstructionTableQueryDisplay
USAGE: {{DeconstructionTableQueryDisplay|energy=Blacksmith}}, where Blacksmith is the energy name.
TODO: Make the energy you look for bold BUG: Iron tools for some reason dont get ordered properly
| Image | Name | Level | Energies
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{{energy}}}, "", ""), component, IF(component={{{energy}}}, "", ""), ' (',' at line 1
Function: CargoSQLQuery::run Query: SELECT `id` AS `id`,`name` AS `name`,`level` AS `level`,GROUP_CONCAT(CONCAT(IF(component={{{energy}}}, "", ""), component, IF(component={{{energy}}}, "", ""), ' (', min_amount,'-', max_amount, ')')) AS `components` FROM `cargo__DeconstructionTable` GROUP BY id, name, level HAVING components like '%Blacksmith%' ORDER BY `level` LIMIT 600 |
|---|