language:
Deutsch (de_DE)
English (en_US)
Español (es_ES)
Français (fr_FR)
Italiano (it_IT)
日本語 (ja_JP)
Русский (ru_RU)
Türkçe (tr_TR)
中文简体 (zh_CN)
projects
/
contractdashboard.git
/ blame
commit
author
committer
file
search:
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
plain
|
HEAD
| blame
Add currency sorting
[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