Template:StoreTable: Difference between revisions

Revision as of 11:20, 13 March 2022

Item	Habitation			Colony			Research			Military			Mining		Uncraftable
Item	Price (mk)	Min stock		Price (mk)	Min stock		Price (mk)	Min stock		Price (mk)	Min stock		Price (mk)	Min Stock 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 'IS NULL ORDER BY `_pageName` LIMIT 100' at line 1 Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`identifier` AS `identifier`,`name` AS `name`,`baseprice` AS `baseprice`,`unbuyable` AS `unbuyable`,`outpostmultiplier` AS `outpostmultiplier`,`outpostminavailable` AS `outpostminavailable`,`outpostsold` AS `outpostsold`,`citymultiplier` AS `citymultiplier`,`cityminavailable` AS `cityminavailable`,`citysold` AS `citysold`,`researchmultiplier` AS `researchmultiplier`,`researchminavailable` AS `researchminavailable`,`researchsold` AS `researchsold`,`militarymultiplier` AS `militarymultiplier`,`militaryminavailable` AS `militaryminavailable`,`militarysold` AS `militarysold`,`minemultiplier` AS `minemultiplier`,`mineminavailable` AS `mineminavailable`,`minesold` AS `minesold`,`fabricator` AS `fabricator` FROM `cargo__Items` WHERE baseprice IS NOT NULL AND baseprice > 0 AND unbuyable = "0" OR IS NULL ORDER BY `_pageName` LIMIT 100	Uncraftable

@@ Line 16: / Line 16: @@
 tables = Items
 | fields = identifier, name, baseprice, unbuyable, outpostmultiplier, outpostminavailable, outpostsold, citymultiplier, cityminavailable, citysold, researchmultiplier, researchminavailable, researchsold, militarymultiplier, militaryminavailable, militarysold, minemultiplier, mineminavailable, minesold, fabricator
-| where = baseprice NOT NULL AND baseprice > 0 AND unbuyable = "0" OR unbuyable IS NULL
+| where = baseprice IS NOT NULL AND baseprice > 0 AND unbuyable = "0" OR IS NULL
 | format = template
 | template = Store table/row