--- a/exportData.csv.php +++ b/exportData.csv.php @@ -10,7 +10,9 @@ foreach ($unspscresult->fetchAll() as $row) { $unspsc[$row['UNSPSC']] = $row['Title']; } - +/*SELECT count(*), extract("week" from "publishDate") as week,extract("year" from "publishDate") as year +FROM contractnotice +where "childCN" is null group by week, year order by year, week*/ $query = $conn->prepare(' SELECT "CNID",contractnotice."agencyName",agency_nametoabn.abn as "agencyABN", EXTRACT(EPOCH FROM "publishDate") as "publishDate",