TYPE=VIEW
query=select `jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo` from ((((`jjlourens2`.`setup_insurer` join `jjlourens2`.`job` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) where ((`jjlourens2`.`job_schedule`.`jobDone` = 2) and (`jjlourens2`.`job_schedule`.`sheduleDate` between _utf8\'2014-01-01\' and _utf8\'2014-12-31\') and (`jjlourens2`.`setup_insurer`.`insName` = _utf8\'Outsurance\') and (`jjlourens2`.`job_type`.`tName` like _utf8\'Resultant %\') and (`jjlourens2`.`setup_scheduletype`.`ActionName` = _latin1\'Inspection\')) group by `jjlourens2`.`job`.`jbClaimNo` order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=5e839c15fb1c7121eaf2b0bd3bd556ac
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=3
timestamp=2015-05-12 21:35:33
create-version=1
source=SELECT
\njob_schedule.sheduleDate AS sheduleDate,
\nsetup_insurer.insName AS insName,
\njob_type.tName AS tName,
\nsetup_scheduleType.ActionName AS ActionName,
\njob_schedule.jobDone AS jobDone,
\njob.jbClaimNo
\nFROM
\n	(
\n		(
\n			(
\n				(
\n					`setup_insurer`
\n					JOIN `job` ON(
\n						(
\n							`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`
\n						)
\n					)
\n				)
\n				JOIN `job_schedule` ON(
\n					(
\n						`job`.`pk_job` = `job_schedule`.`fk_job`
\n					)
\n				)
\n			)
\n			JOIN `job_type` ON(
\n				(
\n					`job_type`.`pk_jtype` = `job_schedule`.`jobCat`
\n				)
\n			)
\n		)
\n		JOIN `setup_scheduletype` ON(
\n			(
\n				`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`
\n			)
\n		)
\n	)
\nWHERE
\n	(
\n		(`job_schedule`.`jobDone` = 2)
\n		AND(
\n			`job_schedule`.`sheduleDate` BETWEEN _utf8 \'2014-01-01\'
\n			AND _utf8 \'2014-12-31\'
\n		)
\n		AND(
\n			`setup_insurer`.`insName` = _utf8 \'Outsurance\' AND tName LIKE \'Resultant %\' and ActionName =\'Inspection\'
\n		)
\n	)
\nGROUP BY jbClaimNo
\nORDER BY
\n	`job_schedule`.`sheduleDate`