TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_schedule`.`timeStart` AS `timeStart`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job_schedule`.`fk_plumber` AS `fk_plumber`,`jjlourens2`.`setup_plumber`.`pk_plumber` AS `pk_plumber`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`setup_plumber`.`ptel` AS `ptel`,`jjlourens2`.`job_schedule`.`snooze` AS `snooze`,`jjlourens2`.`setup_scheduletype`.`pkaction` AS `pkaction`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName` from ((((`jjlourens2`.`job` join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`setup_plumber` on((`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`)))
md5=8cb7b6bf83b01babee91e06a0ea6803e
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`,`clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`userInCharge` AS `userInCharge`,`job`.`fk_client` AS `fk_client`,`job_schedule`.`pk_schedule` AS `pk_schedule`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`cancelled` AS `cancelled`,`job_schedule`.`jobDone` AS `jobDone`,`job_schedule`.`timeStart` AS `timeStart`,`job_schedule`.`jobType` AS `jobType`,`job_schedule`.`fk_plumber` AS `fk_plumber`,`setup_plumber`.`pk_plumber` AS `pk_plumber`,`setup_plumber`.`pname` AS `pname`,`setup_plumber`.`ptel` AS `ptel`,`job_schedule`.`snooze` AS `snooze`,`setup_scheduletype`.`pkaction` AS `pkaction`,`setup_scheduletype`.`ActionName` AS `ActionName` from ((((`job` join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`)))