TYPE=VIEW query=select `view_schedule`.`sheduleDate` AS `sheduleDate`,`view_schedule`.`jobDone` AS `jobDone`,`view_schedule`.`isActive` AS `isActive`,`view_schedule`.`pk_plumber` AS `pk_plumber`,`view_schedule`.`t1` AS `t1`,concat(`view_schedule`.`jbClaimNo`,_utf8\'- \',`view_schedule`.`tNameShort`,_utf8\' \',convert(`view_schedule`.`ActionShort` using utf8),_utf8\'- \',`jjlourens2`.`setup_postal_codes`.`suburb`,_utf8\'- \',`view_schedule`.`clSurname`) AS `jbinfo`,`view_schedule`.`t2` AS `t2`,`view_schedule`.`t3` AS `t3`,`view_schedule`.`t4` AS `t4`,`view_schedule`.`t5` AS `t5`,`view_schedule`.`t6` AS `t6`,`view_schedule`.`t7` AS `t7`,`view_schedule`.`t8` AS `t8`,`view_schedule`.`cancelled` AS `cancelled`,`view_schedule`.`pname` AS `pname`,`view_schedule`.`t9` AS `t9`,`view_schedule`.`t10` AS `t10`,`view_schedule`.`t11` AS `t11`,`view_schedule`.`t12` AS `t12`,`view_schedule`.`t13` AS `t13`,`view_schedule`.`t14` AS `t14`,`view_schedule`.`t15` AS `t15`,`view_schedule`.`t16` AS `t16`,`view_schedule`.`t17` AS `t17`,`view_schedule`.`t18` AS `t18`,`view_schedule`.`t19` AS `t19`,`view_schedule`.`t20` AS `t20`,`view_schedule`.`t21` AS `t21`,`view_schedule`.`t22` AS `t22`,`view_schedule`.`t23` AS `t23`,`view_schedule`.`t24` AS `t24`,`view_schedule`.`t25` AS `t25`,`view_schedule`.`t26` AS `t26`,`view_schedule`.`t27` AS `t27`,`view_schedule`.`t28` AS `t28`,`view_schedule`.`t29` AS `t29`,`view_schedule`.`t30` AS `t30`,`view_schedule`.`t31` AS `t31`,`view_schedule`.`t32` AS `t32`,`view_schedule`.`t33` AS `t33`,`view_schedule`.`t34` AS `t34`,`view_schedule`.`t0` AS `t0`,`view_schedule`.`snooze` AS `snooze`,`view_schedule`.`pk_schedule` AS `pk_schedule`,`view_schedule`.`jobType` AS `jobType`,`view_schedule`.`fk_postal` AS `fk_postal`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb`,`jjlourens2`.`setup_postal_codes`.`pk_postal` AS `pk_postal`,`view_schedule`.`timeStart` AS `timeStart`,`view_schedule`.`pk_job` AS `pk_job`,`view_schedule`.`ActionName` AS `ActionName`,`view_schedule`.`pkaction` AS `pkaction`,`view_schedule`.`tName` AS `tName`,`view_schedule`.`tNameShort` AS `tNameShort`,`view_schedule`.`ActionShort` AS `ActionShort`,`view_schedule`.`jobCat` AS `jobCat`,`view_schedule`.`plumberRank` AS `plumberRank` from (`jjlourens2`.`view_schedule` join `jjlourens2`.`setup_postal_codes` on((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `view_schedule`.`fk_postal`))) where (`view_schedule`.`cancelled` <> 1) md5=bce73e61e928e938d00c992509b3c8c1 updatable=1 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=2 timestamp=2012-03-22 00:33:51 create-version=1 source=SELECT \nview_schedule.sheduleDate AS sheduleDate, \nview_schedule.jobDone AS jobDone, \nview_schedule.isActive AS isActive, \nview_schedule.pk_plumber AS pk_plumber, \nview_schedule.t1 AS t1, \nconcat(`view_schedule`.`jbClaimNo`,_utf8\'- \',`view_schedule`.`tNameShort`,_utf8\' \',convert(`view_schedule`.`ActionShort` using utf8),_utf8\'- \',`setup_postal_codes`.`suburb`,_utf8\'- \',`view_schedule`.`clSurname`) AS jbinfo, \nview_schedule.t2 AS t2, \nview_schedule.t3 AS t3, \nview_schedule.t4 AS t4, \nview_schedule.t5 AS t5, \nview_schedule.t6 AS t6, \nview_schedule.t7 AS t7, \nview_schedule.t8 AS t8, \nview_schedule.cancelled AS cancelled, \nview_schedule.pname AS pname, \nview_schedule.t9 AS t9, \nview_schedule.t10 AS t10, \nview_schedule.t11 AS t11, \nview_schedule.t12 AS t12, \nview_schedule.t13 AS t13, \nview_schedule.t14 AS t14, \nview_schedule.t15 AS t15, \nview_schedule.t16 AS t16, \nview_schedule.t17 AS t17, \nview_schedule.t18 AS t18, \nview_schedule.t19 AS t19, \nview_schedule.t20 AS t20, \nview_schedule.t21 AS t21, \nview_schedule.t22 AS t22, \nview_schedule.t23 AS t23, \nview_schedule.t24 AS t24, \nview_schedule.t25 AS t25, \nview_schedule.t26 AS t26, \nview_schedule.t27 AS t27, \nview_schedule.t28 AS t28, \nview_schedule.t29 AS t29, \nview_schedule.t30 AS t30, \nview_schedule.t31 AS t31, \nview_schedule.t32 AS t32, \nview_schedule.t33 AS t33, \nview_schedule.t34 AS t34, \nview_schedule.t0 AS t0, \nview_schedule.snooze AS snooze, \nview_schedule.pk_schedule AS pk_schedule, \nview_schedule.jobType AS jobType, \nview_schedule.fk_postal AS fk_postal, \nsetup_postal_codes.suburb AS suburb, \nsetup_postal_codes.pk_postal AS pk_postal, \nview_schedule.timeStart AS timeStart, \nview_schedule.pk_job AS pk_job, \nview_schedule.ActionName AS ActionName, \nview_schedule.pkaction AS pkaction, \nview_schedule.tName AS tName, \nview_schedule.tNameShort AS tNameShort, \nview_schedule.ActionShort AS ActionShort, \nview_schedule.jobCat AS jobCat, \nview_schedule.plumberRank \nfrom (`view_schedule` join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `view_schedule`.`fk_postal`))) \nwhere (`view_schedule`.`cancelled` <> 1)