| SELECT min( `publishDate` ) AS w, week( `publishDate` ) AS wk, count( 1 ) | SELECT min( `publishDate` ) AS w, week( `publishDate` ) AS wk, count( 1 ) |
| FROM `contractnotice` | FROM `contractnotice` |
| WHERE YEAR( `publishDate` ) =2009 | WHERE YEAR( `publishDate` ) =2009 |
| GROUP BY wk | GROUP BY wk |
| ORDER BY w | ORDER BY w |
| LIMIT 0 , 30 | LIMIT 0 , 30 |