TYPE=VIEW
query=select `jjlourens2`.`setup_comebackfault`.`fault_description` AS `fault_description`,`jjlourens2`.`setup_comebackresponsible`.`ResponsibleDescription` AS `ResponsibleDescription`,`jjlourens2`.`job_comebacks`.`pk_comeback` AS `pk_comeback`,`jjlourens2`.`job_comebacks`.`fk_job` AS `fk_job`,`jjlourens2`.`job_comebacks`.`InspectionDate` AS `InspectionDate`,`jjlourens2`.`job_comebacks`.`fk_plumber` AS `fk_plumber`,`jjlourens2`.`job_comebacks`.`isfixed` AS `isfixed`,`jjlourens2`.`job_comebacks`.`DateEdit` AS `DateEdit`,`jjlourens2`.`job_comebacks`.`fkUserEdit` AS `fkUserEdit`,`jjlourens2`.`job_comebacks`.`rndm` AS `rndm`,`jjlourens2`.`job_comebacks`.`faultref` AS `faultref`,`jjlourens2`.`job_comebacks`.`faultnote` AS `faultnote`,`jjlourens2`.`job_comebacks`.`fk_responsible` AS `fk_responsible`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job_comebacks`.`fk_fault` AS `fk_fault` from ((((((`jjlourens2`.`job_comebacks` join `jjlourens2`.`setup_comebackfault` on((`jjlourens2`.`setup_comebackfault`.`pk_fault` = `jjlourens2`.`job_comebacks`.`fk_fault`))) join `jjlourens2`.`setup_comebackresponsible` on((`jjlourens2`.`setup_comebackresponsible`.`pk_responsible` = `jjlourens2`.`job_comebacks`.`fk_responsible`))) join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_comebacks`.`fk_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_comebacks`.`fk_plumber`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`)))
md5=25effb79941dc3cab9bbd06eeb85e042
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_comebackfault`.`fault_description` AS `fault_description`,`setup_comebackresponsible`.`ResponsibleDescription` AS `ResponsibleDescription`,`job_comebacks`.`pk_comeback` AS `pk_comeback`,`job_comebacks`.`fk_job` AS `fk_job`,`job_comebacks`.`InspectionDate` AS `InspectionDate`,`job_comebacks`.`fk_plumber` AS `fk_plumber`,`job_comebacks`.`isfixed` AS `isfixed`,`job_comebacks`.`DateEdit` AS `DateEdit`,`job_comebacks`.`fkUserEdit` AS `fkUserEdit`,`job_comebacks`.`rndm` AS `rndm`,`job_comebacks`.`faultref` AS `faultref`,`job_comebacks`.`faultnote` AS `faultnote`,`job_comebacks`.`fk_responsible` AS `fk_responsible`,`job`.`pk_job` AS `pk_job`,`job`.`jbClaimNo` AS `jbClaimNo`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`setup_plumber`.`pname` AS `pname`,`job`.`fk_insurer` AS `fk_insurer`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`job_comebacks`.`fk_fault` AS `fk_fault` from ((((((`job_comebacks` join `setup_comebackfault` on((`setup_comebackfault`.`pk_fault` = `job_comebacks`.`fk_fault`))) join `setup_comebackresponsible` on((`setup_comebackresponsible`.`pk_responsible` = `job_comebacks`.`fk_responsible`))) join `job` on((`job`.`pk_job` = `job_comebacks`.`fk_job`))) join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_comebacks`.`fk_plumber`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`)))