TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job_notes`.`pk_notes` AS `pk_notes`,`jjlourens2`.`job_notes`.`noteUser` AS `noteUser`,`jjlourens2`.`job_notes`.`dateCap` AS `dateCap`,`jjlourens2`.`job_notes`.`Note` AS `Note`,`jjlourens2`.`job_notes`.`noteHide` AS `noteHide`,`jjlourens2`.`job_notes`.`fk_job` AS `fk_job`,`jjlourens2`.`job_notes`.`UserEdit` AS `UserEdit`,`jjlourens2`.`job_notes`.`EditDate` AS `EditDate`,`jjlourens2`.`job_notes`.`followUpDate` AS `followUpDate`,`jjlourens2`.`job_notes`.`noteType` AS `noteType`,`jjlourens2`.`job_notes`.`completeNote` AS `completeNote`,`jjlourens2`.`job_notes`.`complete` AS `complete`,`jjlourens2`.`setup_notetype`.`pk_appType` AS `pk_appType`,`jjlourens2`.`setup_notetype`.`typeName` AS `typeName`,`user2`.`pk_user` AS `pk_user`,`user2`.`userName` AS `userName`,`jjlourens2`.`job_notes`.`completeDate` AS `completeDate`,`jjlourens2`.`job_notes`.`completeUser` AS `completeUser`,`jjlourens2`.`setup_user`.`pk_user` AS `pk_user2`,`jjlourens2`.`setup_user`.`userName` AS `userName2`,`jjlourens2`.`clientdetails`.`clTel1` AS `clTel1`,`jjlourens2`.`clientdetails`.`clTel2` AS `clTel2`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`clientdetails`.`clPostalcd` AS `clPostalcd`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`job`.`jbRefVal` AS `jbRefVal`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`setup_other_ref`.`pk_other_ref` AS `pk_other_ref`,`jjlourens2`.`setup_other_ref`.`ref_name` AS `ref_name`,`jjlourens2`.`job`.`excessVal` AS `excessVal`,`jjlourens2`.`job_notes`.`followtime` AS `followtime`,`jjlourens2`.`job_notes`.`noteFor` AS `noteFor`,`uNotefor`.`pk_user` AS `pkNotefor`,`uNotefor`.`userName` AS `userNotefor`,`jjlourens2`.`job_notes`.`tracknote` AS `tracknote`,`jjlourens2`.`clientdetails`.`clEmail` AS `clEmail` from ((((((((`jjlourens2`.`job` join `jjlourens2`.`job_notes` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_notes`.`fk_job`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_notetype` on((`jjlourens2`.`setup_notetype`.`pk_appType` = `jjlourens2`.`job_notes`.`noteType`))) join `jjlourens2`.`setup_user` `user2` on((`user2`.`pk_user` = `jjlourens2`.`job_notes`.`noteUser`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job_notes`.`completeUser`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_other_ref` on((`jjlourens2`.`setup_other_ref`.`pk_other_ref` = `jjlourens2`.`job`.`fk_other_ref`))) join `jjlourens2`.`setup_user` `uNotefor` on((`uNotefor`.`pk_user` = `jjlourens2`.`job_notes`.`noteFor`)))
md5=4314bbcb07f36872783bebe8d35cbcaa
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`,`clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`fk_client` AS `fk_client`,`job_notes`.`pk_notes` AS `pk_notes`,`job_notes`.`noteUser` AS `noteUser`,`job_notes`.`dateCap` AS `dateCap`,`job_notes`.`Note` AS `Note`,`job_notes`.`noteHide` AS `noteHide`,`job_notes`.`fk_job` AS `fk_job`,`job_notes`.`UserEdit` AS `UserEdit`,`job_notes`.`EditDate` AS `EditDate`,`job_notes`.`followUpDate` AS `followUpDate`,`job_notes`.`noteType` AS `noteType`,`job_notes`.`completeNote` AS `completeNote`,`job_notes`.`complete` AS `complete`,`setup_notetype`.`pk_appType` AS `pk_appType`,`setup_notetype`.`typeName` AS `typeName`,`user2`.`pk_user` AS `pk_user`,`user2`.`userName` AS `userName`,`job_notes`.`completeDate` AS `completeDate`,`job_notes`.`completeUser` AS `completeUser`,`setup_user`.`pk_user` AS `pk_user2`,`setup_user`.`userName` AS `userName2`,`clientdetails`.`clTel1` AS `clTel1`,`clientdetails`.`clTel2` AS `clTel2`,`clientdetails`.`clPostal` AS `clPostal`,`clientdetails`.`clPostalcd` AS `clPostalcd`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`job`.`fk_insurer` AS `fk_insurer`,`job`.`jbRefVal` AS `jbRefVal`,`job`.`jbClaimNo` AS `jbClaimNo`,`setup_other_ref`.`pk_other_ref` AS `pk_other_ref`,`setup_other_ref`.`ref_name` AS `ref_name`,`job`.`excessVal` AS `excessVal`,`job_notes`.`followtime` AS `followtime`,`job_notes`.`noteFor` AS `noteFor`,`uNotefor`.`pk_user` AS `pkNotefor`,`uNotefor`.`userName` AS `userNotefor`,`job_notes`.`tracknote` AS `tracknote`,`clientdetails`.`clEmail` AS `clEmail` from ((((((((`job` join `job_notes` on((`job`.`pk_job` = `job_notes`.`fk_job`))) join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_notetype` on((`setup_notetype`.`pk_appType` = `job_notes`.`noteType`))) join `setup_user` `user2` on((`user2`.`pk_user` = `job_notes`.`noteUser`))) join `setup_user` on((`setup_user`.`pk_user` = `job_notes`.`completeUser`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_other_ref` on((`setup_other_ref`.`pk_other_ref` = `job`.`fk_other_ref`))) join `setup_user` `uNotefor` on((`uNotefor`.`pk_user` = `job_notes`.`noteFor`)))