--- a/lib/graphs.inc.php
+++ b/lib/graphs.inc.php
@@ -229,7 +229,7 @@
     includeFlot();
 
     $topX = 20;
-    $query = 'SELECT SUM(value) as val, mode("supplierName") "supplierName" FROM contractnotice WHERE ' .$yearQ . ' extract ("YEAR" from "contractStart") >= :startYear AND "childCN" is null AND "agencyName" like :agency
+    $query = 'SELECT SUM(value) as val, text_mode("supplierName") "supplierName" FROM contractnotice WHERE ' .$yearQ . ' extract ("YEAR" from "contractStart") >= :startYear AND "childCN" is null AND "agencyName" like :agency
 GROUP BY lower("supplierName") ORDER BY val DESC limit '.$topX;
     $query = $conn->prepare($query);
     $query->bindParam(":startYear", $startYear);
@@ -244,7 +244,7 @@
     }
 
 
-    $query = 'SELECT sum(a.val) as value, count(1) as count from (SELECT SUM(value) as val, mode("supplierName") FROM contractnotice WHERE ' .$yearQ . '(extract ("YEAR" from "contractStart") >= :startYear) AND "childCN" is null and "agencyName" like :agency
+    $query = 'SELECT sum(a.val) as value, count(1) as count from (SELECT SUM(value) as val, text_mode("supplierName") FROM contractnotice WHERE ' .$yearQ . '(extract ("YEAR" from "contractStart") >= :startYear) AND "childCN" is null and "agencyName" like :agency
 GROUP BY lower("supplierName") ORDER BY val DESC LIMIT 184467440 OFFSET '.$topX.') as a';
     $query = $conn->prepare($query);
     $query->bindParam(":startYear", $startYear);
@@ -516,7 +516,7 @@
     $values = Array();
 
 
-    $query = 'SELECT SUM("value") as value, mode("supplierName") as supplierName, (
+    $query = 'SELECT SUM("value") as value, text_mode("supplierName") as supplierName, (
  case when "supplierABN" != 0 THEN "supplierABN"::text ELSE "supplierName" END) as supplierID 
 FROM contractnotice
 WHERE ' .$yearQ . ' "childCN" is null