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`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`capDate` AS `capDate`,`jjlourens2`.`job_schedule`.`capUser` AS `capUser`,`jjlourens2`.`job_schedule`.`fk_plumber` AS `fk_plumber`,`jjlourens2`.`job_schedule`.`jobdescription` AS `jobdescription`,`jjlourens2`.`job_schedule`.`cancellTime` AS `cancellTime`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job_schedule`.`cancelReason` AS `cancelReason`,`jjlourens2`.`job_schedule`.`cancelluser` AS `cancelluser`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job_schedule`.`jobDoneInfo` AS `jobDoneInfo`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_schedule`.`jobDoneUser` AS `jobDoneUser`,`jjlourens2`.`job_schedule`.`jobDoneTime` AS `jobDoneTime`,`jjlourens2`.`job_schedule`.`isActive` AS `isActive`,`jjlourens2`.`job_schedule`.`timeStart` AS `timeStart`,`jjlourens2`.`job_schedule`.`timeFinish` AS `timeFinish`,`jjlourens2`.`job_schedule`.`myrand1` AS `myrand1`,`jjlourens2`.`job_schedule`.`fk_job` AS `fk_job`,`jjlourens2`.`setup_plumber`.`pk_plumber` AS `pk_plumber`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`setup_plumber`.`ptel` AS `ptel`,`jjlourens2`.`clientdetails`.`clTel1` AS `clTel1`,`jjlourens2`.`clientdetails`.`clTel2` AS `clTel2`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`clientdetails`.`clPostalcd` AS `clPostalcd`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`jbRefVal` AS `jbRefVal`,`jjlourens2`.`setup_other_ref`.`pk_other_ref` AS `pk_other_ref`,`jjlourens2`.`setup_other_ref`.`ref_name` AS `ref_name`,`jjlourens2`.`job`.`fk_other_ref` AS `fk_other_ref`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`setup_scheduletype`.`pkaction` AS `pkaction`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`setup_scheduletype`.`ActionShort` AS `ActionShort`,`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` from (((((((`jjlourens2`.`job` join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job_schedule`.`fk_job` = `jjlourens2`.`job`.`pk_job`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_plumber` on((`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`))) join `jjlourens2`.`setup_other_ref` on((`jjlourens2`.`setup_other_ref`.`pk_other_ref` = `jjlourens2`.`job`.`fk_other_ref`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) md5=87b2ff3fa115e1d8557c83fd1d5d12f6 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`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`capDate` AS `capDate`,`job_schedule`.`capUser` AS `capUser`,`job_schedule`.`fk_plumber` AS `fk_plumber`,`job_schedule`.`jobdescription` AS `jobdescription`,`job_schedule`.`cancellTime` AS `cancellTime`,`job_schedule`.`cancelled` AS `cancelled`,`job_schedule`.`cancelReason` AS `cancelReason`,`job_schedule`.`cancelluser` AS `cancelluser`,`job_schedule`.`jobType` AS `jobType`,`job_schedule`.`jobDoneInfo` AS `jobDoneInfo`,`job_schedule`.`jobDone` AS `jobDone`,`job_schedule`.`jobDoneUser` AS `jobDoneUser`,`job_schedule`.`jobDoneTime` AS `jobDoneTime`,`job_schedule`.`isActive` AS `isActive`,`job_schedule`.`timeStart` AS `timeStart`,`job_schedule`.`timeFinish` AS `timeFinish`,`job_schedule`.`myrand1` AS `myrand1`,`job_schedule`.`fk_job` AS `fk_job`,`setup_plumber`.`pk_plumber` AS `pk_plumber`,`setup_plumber`.`pname` AS `pname`,`setup_plumber`.`ptel` AS `ptel`,`clientdetails`.`clTel1` AS `clTel1`,`clientdetails`.`clTel2` AS `clTel2`,`clientdetails`.`clPostal` AS `clPostal`,`clientdetails`.`clPostalcd` AS `clPostalcd`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`jbRefVal` AS `jbRefVal`,`setup_other_ref`.`pk_other_ref` AS `pk_other_ref`,`setup_other_ref`.`ref_name` AS `ref_name`,`job`.`fk_other_ref` AS `fk_other_ref`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`job`.`fk_insurer` AS `fk_insurer`,`setup_scheduletype`.`pkaction` AS `pkaction`,`setup_scheduletype`.`ActionName` AS `ActionName`,`setup_scheduletype`.`ActionShort` AS `ActionShort`,`job_type`.`pk_jtype` AS `pk_jtype`,`job_type`.`tName` AS `tName`,`job_type`.`tNameShort` AS `tNameShort`,`job_schedule`.`jobCat` AS `jobCat` from (((((((`job` join `job_schedule` on((`job_schedule`.`fk_job` = `job`.`pk_job`))) join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`))) join `setup_other_ref` on((`setup_other_ref`.`pk_other_ref` = `job`.`fk_other_ref`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`)))