Template:Commerce form query
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND Weight <> '0' AND Weight <> ORDER BY `_pageData`.`_pageID`,`GeneralDa...' at line 1
Function: CargoSQLQuery::run Query: SELECT `_pageData`.`_pageID` AS `cargo_backlink_page_id__pageData`,`GeneralData`.`_pageID` AS `cargo_backlink_page_id_GeneralData`,`GeneralData`.`_pageName` AS `Item`,POWER(Commerce,1)/Weight AS `Value per Pound`,`Commerce` AS `Commerce`,`Weight` AS `Weight` FROM `GeneralData` LEFT OUTER JOIN `_pageData` ON ((`GeneralData`.`_pageName`=`_pageData`.`_pageName`)) WHERE AND Weight <> '0' AND Weight <> ORDER BY `_pageData`.`_pageID`,`GeneralData`.`_pageID`,`GeneralData`.`_pageName`,POWER(Commerce,1)/Weight,`Commerce` LIMIT 100