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`,`view_schedule`.`fk_plumberType` AS `fk_plumberType`,`view_schedule`.`typeName` AS `typeName`,`view_schedule`.`rank` AS `rank`,`view_schedule`.`specifictime` AS `specifictime` 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=5dc628a8bf6358b22e8bef9965442786
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-24 00:12:02
create-version=1
source=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\'- \',`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`,`setup_postal_codes`.`suburb` AS `suburb`,`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`,`view_schedule`.`fk_plumberType` AS `fk_plumberType`,`view_schedule`.`typeName` AS `typeName`,`view_schedule`.`rank` AS `rank`,`view_schedule`.`specifictime` AS `specifictime` from (`view_schedule` join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `view_schedule`.`fk_postal`))) where (`view_schedule`.`cancelled` <> 1)