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`