--- a/displaySON.php +++ b/displaySON.php @@ -85,7 +85,7 @@ } echo "
"; - $query = 'SELECT min("supplierABN"), text_mode("supplierName") AS "supplierName", count(*), sum(value) AS value, + $query = 'SELECT min("supplierABN") "supplierABN", text_mode("supplierName") AS "supplierName", count(*), sum(value) AS value, (CASE WHEN "supplierABN" != 0 THEN "supplierABN"::TEXT ELSE lower("supplierName") END) AS "supplierID" FROM contractnotice WHERE ' . $yearQ . ' "childCN" IS NULL AND "SONID" = :SONID GROUP BY "supplierID"