TYPE=VIEW
query=select `view_cal_stats`.`tName` AS `tName`,count(`view_cal_stats`.`tName`) AS `typetotal`,`view_cal_stats`.`sheduleDate` AS `sheduleDate`,`view_cal_stats`.`jobType` AS `jobType` from `jjlourens2`.`view_cal_stats` group by `view_cal_stats`.`sheduleDate`,`view_cal_stats`.`tName` order by `view_cal_stats`.`sheduleDate`
md5=79a8b60b8e9a5efc703f72a8280999c0
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-24 00:12:02
create-version=1
source=select `view_cal_stats`.`tName` AS `tName`,count(`view_cal_stats`.`tName`) AS `typetotal`,`view_cal_stats`.`sheduleDate` AS `sheduleDate`,`view_cal_stats`.`jobType` AS `jobType` from `view_cal_stats` group by `view_cal_stats`.`sheduleDate`,`view_cal_stats`.`tName` order by `view_cal_stats`.`sheduleDate`