Add standing offers
[contractdashboard.git] / displayConsultancies.php
blob:a/displayConsultancies.php -> blob:b/displayConsultancies.php
--- a/displayConsultancies.php
+++ b/displayConsultancies.php
@@ -12,7 +12,7 @@
 include_header("Consultancies");
 $query = '
 SELECT SUM(value) as value, count(*), min("supplierName"), unnest(string_to_array("consultancyReason",\';\')) reason
-FROM contractnotice where "consultancy" = \'Yes\'
+FROM contractnotice where ' .$yearQ . ' "consultancy" = \'Yes\' and "childCN" is null
 GROUP BY "supplierABN",reason order by value desc
  ';