TYPE=VIEW query=select `reports_jobs_per_insurer`.`insName` AS `insName`,count(`reports_jobs_per_insurer`.`insName`) AS `InspectionCount` from `jjlourens2`.`reports_jobs_per_insurer` where ((`reports_jobs_per_insurer`.`sheduleDate` between _utf8\'2013-07-01\' and _utf8\'2013-07-25\') and (`reports_jobs_per_insurer`.`ActionName` = _latin1\'Inspection\')) group by `reports_jobs_per_insurer`.`insName` order by `reports_jobs_per_insurer`.`insName` md5=4872456677093a152ba4f02ef373125a updatable=0 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=2 timestamp=2013-07-24 22:58:54 create-version=1 source=SELECT \n `reports_jobs_per_insurer`.`insName` AS `insName`, \n count( \n `reports_jobs_per_insurer`.`insName` \n )AS `InspectionCount` \nFROM \n `reports_jobs_per_insurer` \nWHERE \n ( \n ( \n `reports_jobs_per_insurer`.`sheduleDate` BETWEEN _utf8 \'2013-07-01\' \n AND _utf8 \'2013-07-25\' \n ) \n AND( \n `reports_jobs_per_insurer`.`ActionName` = _latin1 \'Inspection\' \n ) \n ) \nGROUP BY \n `reports_jobs_per_insurer`.`insName` \nORDER BY \n `reports_jobs_per_insurer`.`insName`