TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule`,`jjlourens2`.`job_schedule`.`fk_job` AS `fk_job`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job_schedule`.`capDate` AS `capDate`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo` from ((((`jjlourens2`.`job_schedule` join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`userInCharge`)))
md5=bd9079c9f82b0aa7688160b34efe7ab5
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`.`pk_job` AS `pk_job`,`clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`fk_client` AS `fk_client`,`job_schedule`.`pk_schedule` AS `pk_schedule`,`job_schedule`.`fk_job` AS `fk_job`,`job_schedule`.`jobType` AS `jobType`,`job_schedule`.`capDate` AS `capDate`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`job`.`fk_insurer` AS `fk_insurer`,`job_schedule`.`jobDone` AS `jobDone`,`job_schedule`.`cancelled` AS `cancelled`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job`.`userInCharge` AS `userInCharge`,`setup_user`.`pk_user` AS `pk_user`,`setup_user`.`userName` AS `userName`,`job`.`jbClaimNo` AS `jbClaimNo` from ((((`job_schedule` join `job` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_user` on((`setup_user`.`pk_user` = `job`.`userInCharge`)))