1 2 3 4 5 6 7
SELECT min( `publishDate` ) AS w, week( `publishDate` ) AS wk, count( 1 ) FROM `contractnotice` WHERE YEAR( `publishDate` ) =2009 GROUP BY wk ORDER BY w LIMIT 0 , 30