--- a/heuristics/runHeuristics.php
+++ b/heuristics/runHeuristics.php
@@ -1,5 +1,8 @@
 <?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)