TYPE=VIEW query=select `jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`fkJobDone` AS `fkJobDone` from ((`jjlourens2`.`setup_insurer` join `jjlourens2`.`job` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) where ((`jjlourens2`.`setup_insurer`.`insName` = _utf8\'Outsurance\') and (`jjlourens2`.`job`.`fkJobDone` = 1) and (`jjlourens2`.`job`.`jbdate` >= _utf8\'2012-01-01\')) group by `jjlourens2`.`job`.`jbClaimNo` order by `jjlourens2`.`job`.`jbdate` md5=61ea0203eff32b59cd11086d0f511140 updatable=0 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=2 timestamp=2012-10-31 13:07:52 create-version=1 source=SELECT \n `setup_insurer`.`insName` AS `insName`, \n `clientdetails`.`clSurname` AS `clSurname`, \n `clientdetails`.`clName` AS `clName`, \n `job`.`jbdate` AS `jbdate`, \n `job`.`jbClaimNo` AS `jbClaimNo`, \n `job`.`fkJobDone` AS `fkJobDone` \nFROM \n ( \n ( \n `setup_insurer` \n JOIN `job` ON( \n ( \n `setup_insurer`.`pk_insurer` = `job`.`fk_insurer` \n ) \n ) \n ) \n JOIN `clientdetails` ON( \n ( \n `clientdetails`.`pk_client` = `job`.`fk_client` \n ) \n ) \n ) \nWHERE insName = \'Outsurance\' AND fkJobDone = 1 AND jbdate >= \'2012-01-01\' \nGROUP BY jbClaimNo \nORDER BY jbdate ASC