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` 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) order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=c22d583a130843346e959b6872cad089
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-24 00:12:02
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` 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) order by `job_schedule`.`sheduleDate`