TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`jbRefVal` AS `jbRefVal`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`clientdetails`.`fk_postal` AS `fk_postal`,`jjlourens2`.`clientdetails`.`clTel1` AS `clTel1`,`jjlourens2`.`clientdetails`.`clTel2` AS `clTel2`,`jjlourens2`.`clientdetails`.`clTel3` AS `clTel3`,`jjlourens2`.`clientdetails`.`clPostalcd` AS `clPostalcd`,`jjlourens2`.`job`.`fk_other_ref` AS `fk_other_ref`,`jjlourens2`.`setup_other_ref`.`pk_other_ref` AS `pk_other_ref`,`jjlourens2`.`setup_other_ref`.`ref_name` AS `ref_name`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`job`.`fk_user` AS `fk_user`,`jjlourens2`.`job`.`insContact` AS `insContact`,`jjlourens2`.`job`.`insTel` AS `insTel`,`jjlourens2`.`job`.`insEmail` AS `insEmail`,`jjlourens2`.`job`.`insFax` AS `insFax`,`jjlourens2`.`job`.`excessVal` AS `excessVal`,`jjlourens2`.`job`.`fkInspection` AS `fkInspection`,`jjlourens2`.`job`.`fkLeakDetection` AS `fkLeakDetection`,`jjlourens2`.`job`.`fkJobDone` AS `fkJobDone`,`jjlourens2`.`job`.`fkInsApproval` AS `fkInsApproval`,`jjlourens2`.`job`.`fkExcessDelay` AS `fkExcessDelay`,`jjlourens2`.`job`.`fkInvoiced` AS `fkInvoiced`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`clientdetails`.`clNotes` AS `clNotes`,`jjlourens2`.`clientdetails`.`clEmail` AS `clEmail`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_postal_codes`.`pk_postal` AS `pk_postal`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`fkReportSent` AS `fkReportSent`,`jjlourens2`.`job`.`fkExcessGet` AS `fkExcessGet`,`jjlourens2`.`job`.`fkquote` AS `fkquote`,`jjlourens2`.`job`.`fkproofpay` AS `fkproofpay`,`jjlourens2`.`job`.`fkInvoice1` AS `fkInvoice1`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`jjlourens2`.`job`.`fkReportFinal` AS `fkReportFinal`,`setup_userfin`.`userName` AS `finusername`,`setup_userfin`.`pk_user` AS `pkfinuser`,`jjlourens2`.`job`.`fkbluecard` AS `fkbluecard`,`jjlourens2`.`job`.`fkCloseFile` AS `fkCloseFile`,`jjlourens2`.`job`.`isActive` AS `isActive`,`jjlourens2`.`job`.`jobActive` AS `jobActive`,`jjlourens2`.`job`.`limitVal` AS `limitVal` from ((((((`jjlourens2`.`job` join `jjlourens2`.`clientdetails`) join `jjlourens2`.`setup_other_ref`) join `jjlourens2`.`setup_insurer`) join `jjlourens2`.`setup_postal_codes` on((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `jjlourens2`.`clientdetails`.`fk_postal`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`userInCharge`))) join `jjlourens2`.`setup_user` `setup_userfin` on((`setup_userfin`.`pk_user` = `jjlourens2`.`job`.`finuInCharge`))) where ((`jjlourens2`.`job`.`fk_client` = `jjlourens2`.`clientdetails`.`pk_client`) and (`jjlourens2`.`job`.`fk_other_ref` = `jjlourens2`.`setup_other_ref`.`pk_other_ref`) and (`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))
md5=a9f6f4a5006738d337b3cf61d6def337
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`,`job`.`jbdate` AS `jbdate`,`job`.`fk_client` AS `fk_client`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`jbRefVal` AS `jbRefVal`,`clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`clientdetails`.`clPostal` AS `clPostal`,`clientdetails`.`fk_postal` AS `fk_postal`,`clientdetails`.`clTel1` AS `clTel1`,`clientdetails`.`clTel2` AS `clTel2`,`clientdetails`.`clTel3` AS `clTel3`,`clientdetails`.`clPostalcd` AS `clPostalcd`,`job`.`fk_other_ref` AS `fk_other_ref`,`setup_other_ref`.`pk_other_ref` AS `pk_other_ref`,`setup_other_ref`.`ref_name` AS `ref_name`,`job`.`fk_insurer` AS `fk_insurer`,`job`.`fk_user` AS `fk_user`,`job`.`insContact` AS `insContact`,`job`.`insTel` AS `insTel`,`job`.`insEmail` AS `insEmail`,`job`.`insFax` AS `insFax`,`job`.`excessVal` AS `excessVal`,`job`.`fkInspection` AS `fkInspection`,`job`.`fkLeakDetection` AS `fkLeakDetection`,`job`.`fkJobDone` AS `fkJobDone`,`job`.`fkInsApproval` AS `fkInsApproval`,`job`.`fkExcessDelay` AS `fkExcessDelay`,`job`.`fkInvoiced` AS `fkInvoiced`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`clientdetails`.`clNotes` AS `clNotes`,`clientdetails`.`clEmail` AS `clEmail`,`job`.`userInCharge` AS `userInCharge`,`setup_postal_codes`.`pk_postal` AS `pk_postal`,`setup_postal_codes`.`suburb` AS `suburb`,`setup_user`.`pk_user` AS `pk_user`,`setup_user`.`userName` AS `userName`,`job`.`fkReportSent` AS `fkReportSent`,`job`.`fkExcessGet` AS `fkExcessGet`,`job`.`fkquote` AS `fkquote`,`job`.`fkproofpay` AS `fkproofpay`,`job`.`fkInvoice1` AS `fkInvoice1`,`job`.`finuInCharge` AS `finuInCharge`,`job`.`fkReportFinal` AS `fkReportFinal`,`setup_userfin`.`userName` AS `finusername`,`setup_userfin`.`pk_user` AS `pkfinuser`,`job`.`fkbluecard` AS `fkbluecard`,`job`.`fkCloseFile` AS `fkCloseFile`,`job`.`isActive` AS `isActive`,`job`.`jobActive` AS `jobActive`,`job`.`limitVal` AS `limitVal` from ((((((`job` join `clientdetails`) join `setup_other_ref`) join `setup_insurer`) join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `clientdetails`.`fk_postal`))) join `setup_user` on((`setup_user`.`pk_user` = `job`.`userInCharge`))) join `setup_user` `setup_userfin` on((`setup_userfin`.`pk_user` = `job`.`finuInCharge`))) where ((`job`.`fk_client` = `clientdetails`.`pk_client`) and (`job`.`fk_other_ref` = `setup_other_ref`.`pk_other_ref`) and (`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))