[contractdashboard.git] / displaySON.gexf.php
--- a/displaySON.gexf.php
+++ b/displaySON.gexf.php
@@ -51,7 +51,7 @@
         <nodes>' . PHP_EOL;
 
 $query = '
-SELECT "supplierABN", min("supplierName") AS "supplierName", contractnotice."SONID", count(*), sum(value) AS value 
+SELECT "supplierABN", text_mode("supplierName") AS "supplierName", contractnotice."SONID", count(*), sum(value) AS value 
 FROM contractnotice 
 WHERE "childCN" IS NULL 
 AND extract(year from "publishDate") = \'2016\'