--- a/heuristics/runHeuristics.php
+++ b/heuristics/runHeuristics.php
@@ -1,10 +1,13 @@
 <?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)";
-$result = mysql_query($query);
+$result = mysql_query($lastimportquery);
 if (!$result) echo mysql_error().$query;
 while ($cn = mysql_fetch_array($result, MYSQL_BOTH)) {
 	//get each new CN from latest update