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)