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\'2015-01-01\' and _utf8\'2016-01-01\') and (`reports_jobs_per_insurer`.`ActionName` = _latin1\'Inspection\')) group by `reports_jobs_per_insurer`.`insName` order by `reports_jobs_per_insurer`.`insName`
md5=d051b4a99acef09c7047f0e7ae7a60aa
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=5
timestamp=2016-02-05 13:07:33
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 \'2015-01-01\'
\n			AND _utf8 \'2016-01-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`