--- a/heuristics/runHeuristics.php
+++ b/heuristics/runHeuristics.php
@@ -1,12 +1,19 @@
 <?php
+if (php_sapi_name() != "cli") {
+    
+include_once ("../lib/common.inc.php");
+auth();
 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
-WHERE  DATE(importDate) = (select * from (SELECT DATE(importDate) 
-FROM contractnotice ORDER BY importDate DESC limit 1) alias)";
-$result = mysql_query($query);
-if (!$result) echo mysql_error().$query;
-while ($cn = mysql_fetch_array($result, MYSQL_BOTH)) {
+
+// agency table missing JOIN agency ON contractnotice."agencyName"
+$query = 'SELECT *, case when "supplierABN" != 0 then "supplierABN"::text else "supplierName" end as "supplierID"
+FROM contractnotice 
+WHERE  DATE("importDate") = (select * from (SELECT DATE("importDate") 
+FROM contractnotice ORDER BY "importDate" DESC limit 1) alias) limit 100';
+    $query = $conn->prepare($query);
+    $query->execute();
+    databaseError($conn->errorInfo());
+foreach ($query->fetchAll() as $cn) {
 	//get each new CN from latest update
 	foreach ($heuristics as $heuristic => $description) {
 		// run all heuristics
@@ -25,5 +32,6 @@
 foreach CN
 
 aggregate CN metrics */
+}
 ?>