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` 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`))) where (((`jjlourens2`.`job_schedule`.`jobType` = 2) or (`jjlourens2`.`job_schedule`.`jobType` = 3)) and (`jjlourens2`.`job_schedule`.`cancelled` <> 1))
md5=807eb67b54b3e040c867e36a47a82ec0
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2012-03-02 23:11:04
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` 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`))) where (((`job_schedule`.`jobType` = 2) or (`job_schedule`.`jobType` = 3)) and (`job_schedule`.`cancelled` <> 1))