projects / contractdashboard.git / blame
search:
summary | shortlog | log | commit | commitdiff | tree
plain | HEAD | blame
Initial Commit
[contractdashboard.git] / admin / recordsperweek.txt
1 SELECT min( `publishDate` ) AS w, week( `publishDate` ) AS wk, count( 1 )
2 FROM `contractnotice`
3 WHERE YEAR( `publishDate` ) =2009
4 GROUP BY wk
5 ORDER BY w
6 LIMIT 0 , 30
7
Unnamed repository; edit this file to name it for gitweb.
GitPHP by Chris Han