--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -12,7 +12,7 @@
 include_header("Procurement Methods");
 $query = 'SELECT SUM(value) as value, "procurementMethod"
 FROM contractnotice
-WHERE "childCN" is null
+WHERE ' . $yearQ. " ". $standardQ .'
 GROUP BY "procurementMethod"';
 
     $query = $conn->prepare($query);