Could not execute query [Native Error: ERROR: date/time field value out of range: "0 00:00:00"
LINE 7: AND fsd.download_date BETWEEN '0 00:00:00' AND '0 23:59:59.9...
^
HINT: Perhaps you need a different "datestyle" setting.] [User Info: SELECT COUNT(*) as downloads, frsp.package_name
FROM filesystem_download fsd, filesystem fs, frs_release frsr, frs_package frsp
WHERE fsd.filesystem_id = fs.filesystem_id
AND fs.section = 'frsrelease'
AND fs.ref_id = frsr.frs_release_id
AND frsr.frs_package_id = frsp.frs_package_id
AND fsd.download_date BETWEEN '0 00:00:00' AND '0 23:59:59.999'
AND frsp.project_id = 72
GROUP BY frsp.frs_package_id, frsp.package_name
ORDER BY downloads DESC]
