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\'2017-04-01\' and _utf8\'2017-04-30\') and (`jjlourens2`.`setup_insurer`.`insName` like _utf8\'%santam%\')) order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=a347f8e30f0aba1149b454b878a4ab84
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2017-11-07 08:49:24
create-version=1
source=select `job_schedule`.`sheduleDate` AS `sheduleDate`,`setup_insurer`.`insName` AS `insName`,`job_type`.`tName` AS `tName`,`setup_scheduletype`.`ActionName` AS `ActionName`,`job_schedule`.`jobDone` AS `jobDone`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`fk_user` AS `fk_user` from ((((`setup_insurer` join `job` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`))) where ((`job_schedule`.`jobDone` = 2) and (`job_schedule`.`sheduleDate` between _utf8\'2017-04-01\' and _utf8\'2017-04-30\') and (`setup_insurer`.`insName` like _utf8\'%santam%\')) order by `job_schedule`.`sheduleDate`