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-08-01\') and (`reports_jobs_per_insurer`.`ActionName` = _latin1\'Inspection\')) group by `reports_jobs_per_insurer`.`insName` order by `reports_jobs_per_insurer`.`insName` md5=7ddbe3d1ef46e9183a2df1d93366cac3 updatable=0 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=3 timestamp=2013-08-03 17:27:19 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-08-01\' \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`