Template:NationPageShipCount: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{#cargo_query: tables=MAINBelle |fields=MAINBelle.FK_ShipType=Ship Type, COUNT(*)=Count |where=TXT_NationName = {{{1}}} |group by=MAINBelle.FK_ShipType |order by=MAINBelle.FK_ShipType ASC }}") |
m (Protected "Template:NationPageShipCount": Prevent editing of templates ([Edit=Allow only administrators] (indefinite) [Move=Allow only administrators] (indefinite))) |
Revision as of 11:17, 2 July 2023
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 '{{1}}} GROUP BY `mwofb3_cargo__MAINBelle`.`FK_ShipType` ORDER BY `mwofb3_cargo_' at line 1
Function: CargoSQLQuery::run Query: SELECT `mwofb3_cargo__MAINBelle`.`FK_ShipType` AS `Ship Type`,COUNT(*) AS `Count` FROM `mwofb3_cargo__MAINBelle` WHERE TXT_NationName = {{{1}}} GROUP BY `mwofb3_cargo__MAINBelle`.`FK_ShipType` ORDER BY `mwofb3_cargo__MAINBelle`.`FK_ShipType` LIMIT 100