--- a/heuristics/runHeuristics.php
+++ b/heuristics/runHeuristics.php
@@ -1,12 +1,10 @@
 <?php
 include_once("heuristics.inc.php");
-$query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID
-FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName";
 
-$query = "SELECT *, agency.abn as agencyABN, IF(supplierABN != '',supplierABN,supplierName) as supplierID
-FROM contractnotice JOIN agency ON contractnotice.agencyName=agency.agencyName
-WHERE  DATE(importDate) = (select * from (SELECT DATE(importDate) 
-FROM contractnotice ORDER BY importDate DESC limit 1) alias)";
+$query = 'SELECT *, agency.abn as "agencyABN", case when "supplierABN" != 0 then "supplierABN"::text else "supplierName" end as "supplierID"
+FROM contractnotice JOIN agency ON contractnotice."agencyName"=agency."agencyName"
+WHERE  DATE("importDate") = (select * from (SELECT DATE("importDate") 
+FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) limit 10';
     $query = $conn->prepare($query);
     $query->execute();
     databaseError($conn->errorInfo());