TYPE=VIEW
query=select `view_schedule`.`sheduleDate` AS `sheduleDate`,`view_schedule`.`pname` AS `pname`,`view_schedule`.`jbClaimNo` AS `jbClaimNo`,`view_schedule`.`insName` AS `insName`,`view_schedule`.`tName` AS `tName`,`view_schedule`.`ActionName` AS `ActionName`,`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=ef8d1d55945d83b43813a915f8a43af5
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2013-05-08 14:18:33
create-version=1
source=SELECT
\nview_schedule.sheduleDate,
\nview_schedule.pname,
\nview_schedule.jbClaimNo,
\nview_schedule.insName,
\nview_schedule.tName,
\nview_schedule.ActionName,
\nview_schedule.cancelled,
\nview_schedule.jobDone
\n
\nFROM
\nview_schedule
\nWHERE 
\ncancelled <> 1 AND
\njobDone = 2 AND
\nsheduleDate > \'2013/01/01\'