TYPE=VIEW
query=select `jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job_type`.`pk_jtype` AS `pk_jtype`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`job_type`.`tNameShort` AS `tNameShort`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`setup_scheduletype`.`ActionShort` AS `ActionShort` from ((((`jjlourens2`.`job` join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) 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`.`jobType` = 2) or ((`jjlourens2`.`job_schedule`.`jobType` = 3) and (`jjlourens2`.`job_type`.`pk_jtype` = 7))) and (`jjlourens2`.`job_schedule`.`cancelled` <> 1))
md5=449f4e63c4cd3d0f7c06c61682511ad0
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 `setup_insurer`.`insName` AS `insName`,`job_schedule`.`jobType` AS `jobType`,`job`.`jbClaimNo` AS `jbClaimNo`,`job_schedule`.`cancelled` AS `cancelled`,`job_type`.`pk_jtype` AS `pk_jtype`,`job_type`.`tName` AS `tName`,`job_type`.`tNameShort` AS `tNameShort`,`job_schedule`.`jobCat` AS `jobCat`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`setup_scheduletype`.`ActionName` AS `ActionName`,`setup_scheduletype`.`ActionShort` AS `ActionShort` from ((((`job` join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`))) where (((`job_schedule`.`jobType` = 2) or ((`job_schedule`.`jobType` = 3) and (`job_type`.`pk_jtype` = 7))) and (`job_schedule`.`cancelled` <> 1))