TYPE=VIEW
query=select `jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`job`.`fkJobDone` AS `fkJobDone`,`jjlourens2`.`job`.`fkInsApproval` AS `fkInsApproval`,`jjlourens2`.`job`.`fkExcessDelay` AS `fkExcessDelay`,`jjlourens2`.`job`.`fkExcessGet` AS `fkExcessGet`,`jjlourens2`.`job`.`fkLeakDetection` AS `fkLeakDetection`,`jjlourens2`.`job`.`fkInspection` AS `fkInspection`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`fkquote` AS `fkquote`,`jjlourens2`.`job`.`fkproofpay` AS `fkproofpay`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`fkCloseFile` AS `fkCloseFile`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`finDelay` AS `finDelay`,`jjlourens2`.`job`.`finDelayDate` AS `finDelayDate` from ((((((`jjlourens2`.`job` join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`finuInCharge`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) where (((`jjlourens2`.`job`.`fkExcessGet` = _utf8\'0\') or (`jjlourens2`.`job`.`fkInvoice1` = _utf8\'0\') or (`jjlourens2`.`job`.`fkInvoiced` = _utf8\'0\') or (`jjlourens2`.`job`.`fkReportFinal` = _utf8\'0\') or (`jjlourens2`.`job`.`fkbluecard` = _utf8\'0\')) and (`jjlourens2`.`job`.`fkInspection` = _utf8\'1\') and (`jjlourens2`.`job`.`fkLeakDetection` = _utf8\'1\') and (`jjlourens2`.`job`.`fkquote` = _utf8\'1\') and (`jjlourens2`.`job`.`fkInsApproval` = _utf8\'1\') and (`jjlourens2`.`job`.`fkExcessDelay` = _utf8\'1\') and (`jjlourens2`.`job`.`fkJobDone` = _utf8\'1\') and (`jjlourens2`.`job`.`fkReportSent` = _utf8\'1\') and (`jjlourens2`.`job`.`fkproofpay` = _utf8\'1\') and (`jjlourens2`.`job`.`fkCloseFile` = 1)) group by `jjlourens2`.`job`.`pk_job`
md5=67cb54c6d5064039a602e49d5324cff9
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-08-21 15:40:18
create-version=1
source=SELECT
\nclientDetails.clName AS clName,
\nclientDetails.clSurname AS clSurname,
\njob.fkJobDone AS fkJobDone,
\njob.fkInsApproval AS fkInsApproval,
\njob.fkExcessDelay AS fkExcessDelay,
\njob.fkExcessGet AS fkExcessGet,
\njob.fkLeakDetection AS fkLeakDetection,
\njob.fkInspection AS fkInspection,
\njob.jbClaimNo AS jbClaimNo,
\nsetup_insurer.insName AS insName,
\njob.fkquote AS fkquote,
\njob.fkproofpay AS fkproofpay,
\njob.finuInCharge AS finuInCharge,
\njob_schedule.sheduleDate AS sheduleDate,
\njob_schedule.jobType AS jobType,
\njob_schedule.jobCat AS jobCat,
\njob_schedule.jobDone AS jobDone,
\njob_type.tName AS tName,
\nsetup_scheduleType.ActionName AS ActionName,
\nsetup_user.userName AS userName,
\njob.fkCloseFile AS fkCloseFile,
\njob.pk_job AS pk_job,
\njob.finDelay,
\njob.finDelayDate
\nfrom ((((((`job` join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_user` on((`setup_user`.`pk_user` = `job`.`finuInCharge`))) join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`)))
\nwhere (((`job`.`fkExcessGet` = _utf8\'0\') or (`job`.`fkInvoice1` = _utf8\'0\') or (`job`.`fkInvoiced` = _utf8\'0\') or (`job`.`fkReportFinal` = _utf8\'0\') or (`job`.`fkbluecard` = _utf8\'0\')) and (`job`.`fkInspection` = _utf8\'1\') and (`job`.`fkLeakDetection` = _utf8\'1\') and (`job`.`fkquote` = _utf8\'1\') and (`job`.`fkInsApproval` = _utf8\'1\') and (`job`.`fkExcessDelay` = _utf8\'1\') and (`job`.`fkJobDone` = _utf8\'1\') and (`job`.`fkReportSent` = _utf8\'1\') and (`job`.`fkproofpay` = _utf8\'1\') and (`job`.`fkCloseFile` = 1))
\ngroup by `job`.`pk_job`