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`,`jjlourens2`.`job`.`finDelay` AS `finDelay`,`jjlourens2`.`job`.`finDelayDate` AS `finDelayDate` 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=0496aebe435f2125714de63b82c541a0
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-08-21 15:01:51
create-version=1
source=SELECT
\njob.pk_job AS pk_job,
\njob.jbdate AS jbdate,
\njob.fk_client AS fk_client,
\njob.jbClaimNo AS jbClaimNo,
\njob.jbRefVal AS jbRefVal,
\nclientDetails.pk_client AS pk_client,
\nclientDetails.clSurname AS clSurname,
\nclientDetails.clName AS clName,
\nclientDetails.clPostal AS clPostal,
\nclientDetails.fk_postal AS fk_postal,
\nclientDetails.clTel1 AS clTel1,
\nclientDetails.clTel2 AS clTel2,
\nclientDetails.clTel3 AS clTel3,
\nclientDetails.clPostalcd AS clPostalcd,
\njob.fk_other_ref AS fk_other_ref,
\nsetup_other_ref.pk_other_ref AS pk_other_ref,
\nsetup_other_ref.ref_name AS ref_name,
\njob.fk_insurer AS fk_insurer,
\njob.fk_user AS fk_user,
\njob.insContact AS insContact,
\njob.insTel AS insTel,
\njob.insEmail AS insEmail,
\njob.insFax AS insFax,
\njob.excessVal AS excessVal,
\njob.fkInspection AS fkInspection,
\njob.fkLeakDetection AS fkLeakDetection,
\njob.fkJobDone AS fkJobDone,
\njob.fkInsApproval AS fkInsApproval,
\njob.fkExcessDelay AS fkExcessDelay,
\njob.fkInvoiced AS fkInvoiced,
\nsetup_insurer.pk_insurer AS pk_insurer,
\nsetup_insurer.insName AS insName,
\nclientDetails.clNotes AS clNotes,
\nclientDetails.clEmail AS clEmail,
\njob.userInCharge AS userInCharge,
\nsetup_postal_codes.pk_postal AS pk_postal,
\nsetup_postal_codes.suburb AS suburb,
\nsetup_user.pk_user AS pk_user,
\nsetup_user.userName AS userName,
\njob.fkReportSent AS fkReportSent,
\njob.fkExcessGet AS fkExcessGet,
\njob.fkquote AS fkquote,
\njob.fkproofpay AS fkproofpay,
\njob.fkInvoice1 AS fkInvoice1,
\njob.finuInCharge AS finuInCharge,
\njob.fkReportFinal AS fkReportFinal,
\nsetup_userfin.userName AS finusername,
\nsetup_userfin.pk_user AS pkfinuser,
\njob.fkbluecard AS fkbluecard,
\njob.fkCloseFile AS fkCloseFile,
\njob.isActive AS isActive,
\njob.jobActive AS jobActive,
\njob.limitVal AS limitVal,
\njob.finDelay,
\njob.finDelayDate
\nFROM
\n	(
\n		(
\n			(
\n				(
\n					(
\n						(`job` JOIN `clientdetails`)
\n						JOIN `setup_other_ref`
\n					)
\n					JOIN `setup_insurer`
\n				)
\n				JOIN `setup_postal_codes` ON(
\n					(
\n						`setup_postal_codes`.`pk_postal` = `clientdetails`.`fk_postal`
\n					)
\n				)
\n			)
\n			JOIN `setup_user` ON(
\n				(
\n					`setup_user`.`pk_user` = `job`.`userInCharge`
\n				)
\n			)
\n		)
\n		JOIN `setup_user` `setup_userfin` ON(
\n			(
\n				`setup_userfin`.`pk_user` = `job`.`finuInCharge`
\n			)
\n		)
\n	)
\nWHERE
\n	(
\n		(
\n			`job`.`fk_client` = `clientdetails`.`pk_client`
\n		)
\n		AND(
\n			`job`.`fk_other_ref` = `setup_other_ref`.`pk_other_ref`
\n		)
\n		AND(
\n			`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`
\n		)
\n	)