SELECT * FROM cashmiles2015 WHERE shiftdate >= '2015-01-01' AND shiftdate <=  '2015-12-31' and cstatus='0' AND tstatus LIKE '0' group by webcode