SELECT substring(date,6,2) as month, region as province, right(date,2) as day, count(right(date,2)) as c, nc_list.sciName as sn, nc_list.comName
From nc_records
LEFT JOIN nc_list on nc_list.checklist_number=nc_records.checklist_number
where nc_records.checklist_number='659.20' and substring(date,6,2)>'00'
group by month,region,day
order by month<br>Error #1053: Server shutdown in progress