TYPE=VIEW
query=select `jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`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`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`fkReportSent` AS `fkReportSent`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`fkExcessGet` AS `fkExcessGet`,`jjlourens2`.`job`.`fkquote` AS `fkquote`,`jjlourens2`.`job`.`fkproofpay` AS `fkproofpay`,`jjlourens2`.`job`.`fkInvoice1` AS `fkInvoice1`,`jjlourens2`.`job`.`fkReportFinal` AS `fkReportFinal`,`jjlourens2`.`job`.`fkbluecard` AS `fkbluecard`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`setup_user2`.`pk_user` AS `pkuser2`,`setup_user2`.`userName` AS `finUsername`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job`.`fkCloseFile` AS `fkCloseFile`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate` from ((((`jjlourens2`.`job` join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`userInCharge`))) join `jjlourens2`.`setup_user` `setup_user2` on((`setup_user2`.`pk_user` = `jjlourens2`.`job`.`finuInCharge`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`)))
md5=d77bc6137431897674b773102ac453d4
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 `clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`pk_job` AS `pk_job`,`job`.`jbdate` AS `jbdate`,`job`.`fkInspection` AS `fkInspection`,`job`.`fkLeakDetection` AS `fkLeakDetection`,`job`.`fkJobDone` AS `fkJobDone`,`job`.`fkInsApproval` AS `fkInsApproval`,`job`.`fkExcessDelay` AS `fkExcessDelay`,`job`.`fkInvoiced` AS `fkInvoiced`,`job`.`userInCharge` AS `userInCharge`,`setup_user`.`pk_user` AS `pk_user`,`setup_user`.`userName` AS `userName`,`job`.`fkReportSent` AS `fkReportSent`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`fkExcessGet` AS `fkExcessGet`,`job`.`fkquote` AS `fkquote`,`job`.`fkproofpay` AS `fkproofpay`,`job`.`fkInvoice1` AS `fkInvoice1`,`job`.`fkReportFinal` AS `fkReportFinal`,`job`.`fkbluecard` AS `fkbluecard`,`job`.`finuInCharge` AS `finuInCharge`,`setup_user2`.`pk_user` AS `pkuser2`,`setup_user2`.`userName` AS `finUsername`,`job_schedule`.`jobCat` AS `jobCat`,`job`.`fkCloseFile` AS `fkCloseFile`,`job_schedule`.`sheduleDate` AS `sheduleDate` from ((((`job` join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_user` on((`setup_user`.`pk_user` = `job`.`userInCharge`))) join `setup_user` `setup_user2` on((`setup_user2`.`pk_user` = `job`.`finuInCharge`))) join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`)))