TYPE=VIEW query=select `jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo` from ((((`jjlourens2`.`setup_insurer` join `jjlourens2`.`job` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) where ((`jjlourens2`.`job_schedule`.`jobDone` = 2) and (`jjlourens2`.`job_schedule`.`sheduleDate` between _utf8\'2014-01-01\' and _utf8\'2014-12-31\') and (`jjlourens2`.`setup_insurer`.`insName` = _utf8\'Outsurance\') and (`jjlourens2`.`job_type`.`tName` like _utf8\'Resultant %\') and (`jjlourens2`.`setup_scheduletype`.`ActionName` = _latin1\'Inspection\')) group by `jjlourens2`.`job`.`jbClaimNo` order by `jjlourens2`.`job_schedule`.`sheduleDate` md5=5e839c15fb1c7121eaf2b0bd3bd556ac updatable=0 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=3 timestamp=2015-05-12 21:35:33 create-version=1 source=SELECT \njob_schedule.sheduleDate AS sheduleDate, \nsetup_insurer.insName AS insName, \njob_type.tName AS tName, \nsetup_scheduleType.ActionName AS ActionName, \njob_schedule.jobDone AS jobDone, \njob.jbClaimNo \nFROM \n ( \n ( \n ( \n ( \n `setup_insurer` \n JOIN `job` ON( \n ( \n `setup_insurer`.`pk_insurer` = `job`.`fk_insurer` \n ) \n ) \n ) \n JOIN `job_schedule` ON( \n ( \n `job`.`pk_job` = `job_schedule`.`fk_job` \n ) \n ) \n ) \n JOIN `job_type` ON( \n ( \n `job_type`.`pk_jtype` = `job_schedule`.`jobCat` \n ) \n ) \n ) \n JOIN `setup_scheduletype` ON( \n ( \n `setup_scheduletype`.`pkaction` = `job_schedule`.`jobType` \n ) \n ) \n ) \nWHERE \n ( \n (`job_schedule`.`jobDone` = 2) \n AND( \n `job_schedule`.`sheduleDate` BETWEEN _utf8 \'2014-01-01\' \n AND _utf8 \'2014-12-31\' \n ) \n AND( \n `setup_insurer`.`insName` = _utf8 \'Outsurance\' AND tName LIKE \'Resultant %\' and ActionName =\'Inspection\' \n ) \n ) \nGROUP BY jbClaimNo \nORDER BY \n `job_schedule`.`sheduleDate`