TYPE=VIEW
query=select `jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`job_type`.`pk_jtype` AS `tid`,`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\'2017-12-01\' and _utf8\'2018-01-31\') and ((`jjlourens2`.`job_type`.`pk_jtype` = 4) or (`jjlourens2`.`job_type`.`pk_jtype` = 17))) order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=dc6d8790f5c277eb315e299e347ca58c
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=6
timestamp=2018-02-05 08:33:48
create-version=1
source=SELECT
\n	`job_schedule`.`sheduleDate` AS `sheduleDate`,
\n	`setup_insurer`.`insName` AS `insName`,
\n	`job_type`.`tName` AS `tName`,
\n	`job_type`.`pk_jtype` AS `tid`,
\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 \'2017-12-01\'
\n			AND _utf8 \'2018-01-31\'
\n		)
\n	AND (`job_type`.`pk_jtype`=4 OR `job_type`.`pk_jtype`=17)
\n	)
\nORDER BY
\n	`job_schedule`.`sheduleDate`