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`