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`