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` 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=cea6afad2e514bae831236788d4caf05 updatable=1 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=1 timestamp=2012-03-02 23:11:04 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` 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`