TYPE=VIEW
query=select `view_schedule`.`clSurname` AS `clSurname`,`view_schedule`.`sheduleDate` AS `sheduleDate`,`view_schedule`.`pname` AS `pname`,`view_schedule`.`jobDone` AS `jobDone`,`view_schedule`.`cancelled` AS `cancelled`,`view_schedule`.`fk_postal` AS `fk_postal`,`view_schedule`.`jobType` AS `jobType`,`view_schedule`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`setup_postal_codes`.`pk_postal` AS `pk_postal`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb`,`view_schedule`.`fk_plumber` AS `fk_plumber`,`view_schedule`.`snooze` AS `snooze`,`view_schedule`.`pk_job` AS `pk_job`,`view_schedule`.`jobCat` AS `jobCat` from (`jjlourens2`.`view_schedule` join `jjlourens2`.`setup_postal_codes` on((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `view_schedule`.`fk_postal`))) where (`view_schedule`.`jobType` = 1) order by `view_schedule`.`pname`
md5=d65eff3a1d1312e0238cde14d7059255
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-16 14:31:30
create-version=1
source=select `view_schedule`.`clSurname` AS `clSurname`,`view_schedule`.`sheduleDate` AS `sheduleDate`,`view_schedule`.`pname` AS `pname`,`view_schedule`.`jobDone` AS `jobDone`,`view_schedule`.`cancelled` AS `cancelled`,`view_schedule`.`fk_postal` AS `fk_postal`,`view_schedule`.`jobType` AS `jobType`,`view_schedule`.`jbClaimNo` AS `jbClaimNo`,`setup_postal_codes`.`pk_postal` AS `pk_postal`,`setup_postal_codes`.`suburb` AS `suburb`,`view_schedule`.`fk_plumber` AS `fk_plumber`,`view_schedule`.`snooze` AS `snooze`,`view_schedule`.`pk_job` AS `pk_job`,`view_schedule`.`jobCat` AS `jobCat` from (`view_schedule` join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `view_schedule`.`fk_postal`))) where (`view_schedule`.`jobType` = 1) order by `view_schedule`.`pname`