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`,`jjlourens2`.`job`.`fk_user` AS `fk_user` 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\'2016-01-01\' and _utf8\'2017-01-01\') and (`jjlourens2`.`setup_insurer`.`insName` like _utf8\'santam%\')) or (`jjlourens2`.`setup_insurer`.`insName` like _utf8\'%santam\'))) order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=e353bb71c5931dc8aad96367fb305840
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=4
timestamp=2017-03-08 13:20:02
create-version=1
source=SELECT
\n	`job_schedule`.`sheduleDate` AS `sheduleDate`,
\n	`setup_insurer`.`insName` AS `insName`,
\n	`job_type`.`tName` AS `tName`,
\n	`setup_scheduletype`.`ActionName` AS `ActionName`,
\n	`job_schedule`.`jobDone` AS `jobDone`,
\n	`job`.`jbClaimNo` AS `jbClaimNo`,
\n	`job`.`fk_user` AS `fk_user`
\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 \'2016-01-01\'
\n			AND _utf8 \'2017-01-01\' AND insName Like \'santam%\' OR insName Like \'%santam\'
\n		)
\n	)
\nORDER BY
\n	`job_schedule`.`sheduleDate`