TYPE=VIEW
query=select `jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`fk_plumber` AS `fk_plumber`,`jjlourens2`.`job_schedule`.`snooze` AS `snooze`,`jjlourens2`.`job_schedule`.`snoozeTime` AS `snoozeTime`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb` from ((((`jjlourens2`.`job_schedule` join `jjlourens2`.`setup_plumber` on((`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`))) join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_postal_codes` on((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `jjlourens2`.`clientdetails`.`fk_postal`))) where `jjlourens2`.`job_schedule`.`snoozeTime` in (select max(`jjlourens2`.`job_schedule`.`snoozeTime`) AS `max(``job_schedule``.``snoozeTime``)` from `jjlourens2`.`job_schedule` where (`jjlourens2`.`job_schedule`.`snooze` = 1) group by `jjlourens2`.`job_schedule`.`sheduleDate`,`jjlourens2`.`job_schedule`.`fk_plumber`)
md5=3abb1f811cc632c5317de4754cf73fad
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_schedule`.`pk_schedule` AS `pk_schedule`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`fk_plumber` AS `fk_plumber`,`job_schedule`.`snooze` AS `snooze`,`job_schedule`.`snoozeTime` AS `snoozeTime`,`setup_plumber`.`pname` AS `pname`,`setup_postal_codes`.`suburb` AS `suburb` from ((((`job_schedule` join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`))) join `job` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `clientdetails`.`fk_postal`))) where `job_schedule`.`snoozeTime` in (select max(`job_schedule`.`snoozeTime`) AS `max(``job_schedule``.``snoozeTime``)` from `job_schedule` where (`job_schedule`.`snooze` = 1) group by `job_schedule`.`sheduleDate`,`job_schedule`.`fk_plumber`)