TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job_action`.`fk_job` AS `fk_job`,`jjlourens2`.`job_action`.`pkAction` AS `pkAction`,`jjlourens2`.`job_action`.`fkActType` AS `fkActType`,`jjlourens2`.`job_action`.`actNote` AS `actNote`,`jjlourens2`.`job_action`.`actDateCap` AS `actDateCap`,`jjlourens2`.`job_action`.`actDateFor` AS `actDateFor`,`jjlourens2`.`job_action`.`actTimeFor` AS `actTimeFor`,`jjlourens2`.`job_action`.`actUserCap` AS `actUserCap`,`jjlourens2`.`job_action`.`actUserFor` AS `actUserFor`,`jjlourens2`.`job_action`.`actIsDoneSuper` AS `actIsDoneSuper`,`jjlourens2`.`job_action`.`actIsDoneUser` AS `actIsDoneUser`,`jjlourens2`.`job_action`.`actDateUserIsdone` AS `actDateUserIsdone`,`jjlourens2`.`job_action`.`rndm5` AS `rndm5`,`jjlourens2`.`job_action`.`actDateSuperIsdone` AS `actDateSuperIsdone`,`jjlourens2`.`setup_acttype`.`pkactType` AS `pkactType`,`jjlourens2`.`setup_acttype`.`actname` AS `actname`,`usercap1`.`pk_user` AS `capid`,`usercap1`.`userName` AS `capname`,`userfor1`.`userName` AS `forid`,`userfor1`.`pk_user` AS `forname`,`jjlourens2`.`job_action`.`actClerkNote` AS `actClerkNote`,`jjlourens2`.`job_action`.`actSuperNote` AS `actSuperNote`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo` from ((((`jjlourens2`.`job` join `jjlourens2`.`job_action` on((`jjlourens2`.`job_action`.`fk_job` = `jjlourens2`.`job`.`pk_job`))) join `jjlourens2`.`setup_user` `usercap1` on((`usercap1`.`pk_user` = `jjlourens2`.`job_action`.`actUserCap`))) join `jjlourens2`.`setup_acttype` on((`jjlourens2`.`setup_acttype`.`pkactType` = `jjlourens2`.`job_action`.`fkActType`))) join `jjlourens2`.`setup_user` `userfor1` on((`userfor1`.`pk_user` = `jjlourens2`.`job_action`.`actUserFor`)))
md5=b64dcf0ee767474e02836894846b9d6e
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`,`job_action`.`fk_job` AS `fk_job`,`job_action`.`pkAction` AS `pkAction`,`job_action`.`fkActType` AS `fkActType`,`job_action`.`actNote` AS `actNote`,`job_action`.`actDateCap` AS `actDateCap`,`job_action`.`actDateFor` AS `actDateFor`,`job_action`.`actTimeFor` AS `actTimeFor`,`job_action`.`actUserCap` AS `actUserCap`,`job_action`.`actUserFor` AS `actUserFor`,`job_action`.`actIsDoneSuper` AS `actIsDoneSuper`,`job_action`.`actIsDoneUser` AS `actIsDoneUser`,`job_action`.`actDateUserIsdone` AS `actDateUserIsdone`,`job_action`.`rndm5` AS `rndm5`,`job_action`.`actDateSuperIsdone` AS `actDateSuperIsdone`,`setup_acttype`.`pkactType` AS `pkactType`,`setup_acttype`.`actname` AS `actname`,`usercap1`.`pk_user` AS `capid`,`usercap1`.`userName` AS `capname`,`userfor1`.`userName` AS `forid`,`userfor1`.`pk_user` AS `forname`,`job_action`.`actClerkNote` AS `actClerkNote`,`job_action`.`actSuperNote` AS `actSuperNote`,`job`.`jbClaimNo` AS `jbClaimNo` from ((((`job` join `job_action` on((`job_action`.`fk_job` = `job`.`pk_job`))) join `setup_user` `usercap1` on((`usercap1`.`pk_user` = `job_action`.`actUserCap`))) join `setup_acttype` on((`setup_acttype`.`pkactType` = `job_action`.`fkActType`))) join `setup_user` `userfor1` on((`userfor1`.`pk_user` = `job_action`.`actUserFor`)))