TYPE=VIEW
query=select `view_schedule`.`sheduleDate` AS `sheduleDate`,`view_schedule`.`pname` AS `pname`,`view_schedule`.`jbClaimNo` AS `jbClaimNo`,`view_schedule`.`insName` AS `insName`,concat(`view_schedule`.`tName`,_utf8\' \',convert(`view_schedule`.`ActionName` using utf8)) AS `jobname`,`view_schedule`.`cancelled` AS `cancelled`,`view_schedule`.`jobDone` AS `jobDone` from `jjlourens2`.`view_schedule` where ((`view_schedule`.`cancelled` <> 1) and (`view_schedule`.`jobDone` = 2) and (`view_schedule`.`sheduleDate` > _utf8\'2013/01/01\'))
md5=a782588470d460f1a4f040b2c68c581a
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`.`pname` AS `pname`,`view_schedule`.`jbClaimNo` AS `jbClaimNo`,`view_schedule`.`insName` AS `insName`,concat(`view_schedule`.`tName`,_utf8\' \',convert(`view_schedule`.`ActionName` using utf8)) AS `jobname`,`view_schedule`.`cancelled` AS `cancelled`,`view_schedule`.`jobDone` AS `jobDone` from `view_schedule` where ((`view_schedule`.`cancelled` <> 1) and (`view_schedule`.`jobDone` = 2) and (`view_schedule`.`sheduleDate` > _utf8\'2013/01/01\'))