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\'2019-04-01\' and _utf8\'2019-04-30\') and (`jjlourens2`.`setup_insurer`.`insName` like _utf8\'SAHL%\')) order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=d1ce610322d24760b699b2fd30574004
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=31
timestamp=2019-05-28 11:40:28
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 \'2019-04-01\'
\n			AND _utf8 \'2019-04-30\'
\n		)
\n		AND(
\n			`setup_insurer`.`insName` LIKE _utf8 \'SAHL%\'
\n		)
\n	)
\nORDER BY
\n	`job_schedule`.`sheduleDate`