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`,`plumResponse`.`pk_plumber` AS `pkPlumberResponsile`,`plumResponse`.`pname` AS `PlumberResponsible` 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`))) join `jjlourens2`.`setup_plumber` `plumResponse` on((`plumResponse`.`pk_plumber` = `jjlourens2`.`job_comebacks`.`fk_responsible`)))
md5=87a9d53ae59127ebc736658e46764017
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2012-09-19 09:30:27
create-version=1
source=SELECT
\nsetup_ComeBackFault.fault_description AS fault_description,
\nsetup_ComeBackResponsible.ResponsibleDescription AS ResponsibleDescription,
\njob_comebacks.pk_comeback AS pk_comeback,
\njob_comebacks.fk_job AS fk_job,
\njob_comebacks.InspectionDate AS InspectionDate,
\njob_comebacks.fk_plumber AS fk_plumber,
\njob_comebacks.isfixed AS isfixed,
\njob_comebacks.DateEdit AS DateEdit,
\njob_comebacks.fkUserEdit AS fkUserEdit,
\njob_comebacks.rndm AS rndm,
\njob_comebacks.faultref AS faultref,
\njob_comebacks.faultnote AS faultnote,
\njob_comebacks.fk_responsible AS fk_responsible,
\njob.pk_job AS pk_job,
\njob.jbClaimNo AS jbClaimNo,
\nclientDetails.clSurname AS clSurname,
\nclientDetails.clName AS clName,
\nsetup_plumber.pname AS pname,
\njob.fk_insurer AS fk_insurer,
\nsetup_insurer.pk_insurer AS pk_insurer,
\nsetup_insurer.insName AS insName,
\njob_comebacks.fk_fault AS fk_fault,
\nplumResponse.pk_plumber AS pkPlumberResponsile,
\nplumResponse.pname AS PlumberResponsible
\nFROM
\n((((((job_comebacks
\nJOIN setup_ComeBackFault ON ((setup_ComeBackFault.pk_fault = job_comebacks.fk_fault)))
\nJOIN setup_ComeBackResponsible ON ((setup_ComeBackResponsible.pk_responsible = job_comebacks.fk_responsible)))
\nJOIN job ON ((job.pk_job = job_comebacks.fk_job)))
\nJOIN clientDetails ON ((clientDetails.pk_client = job.fk_client)))
\nJOIN setup_plumber ON ((setup_plumber.pk_plumber = job_comebacks.fk_plumber)))
\nJOIN setup_insurer ON ((setup_insurer.pk_insurer = job.fk_insurer)))
\nINNER JOIN setup_plumber AS plumResponse ON plumResponse.pk_plumber = job_comebacks.fk_responsible