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-01-01\' and _utf8\'2013-02-01\') and (`reports_jobs_per_insurer`.`ActionName` = _latin1\'Inspection\')) group by `reports_jobs_per_insurer`.`insName`
md5=58334531703f5f737e2976d9ab616ad0
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=12
timestamp=2013-07-18 16:37:38
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-01-01\'
\n			AND _utf8 \'2013-02-01\'
\n		)
\n		AND(
\n			`reports_jobs_per_insurer`.`ActionName` = _latin1 \'Inspection\'
\n		)
\n	)
\nGROUP BY
\n	`reports_jobs_per_insurer`.`insName`