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