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`,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=be0dcaf0cd6e80f5d59f34d45cc4683a
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-05-08 17:58:41
create-version=1
source=SELECT
\n	`view_schedule`.`sheduleDate` AS `sheduleDate`,
\n	`view_schedule`.`pname` AS `pname`,
\n	`view_schedule`.`jbClaimNo` AS `jbClaimNo`,
\n	`view_schedule`.`insName` AS `insName`,
\n	CONCAT(tName,ActionName) AS jobname,
\n	`view_schedule`.`cancelled` AS `cancelled`,
\n	`view_schedule`.`jobDone` AS `jobDone`
\nFROM
\n	`view_schedule`
\nWHERE
\n	(
\n		(
\n			`view_schedule`.`cancelled` <> 1
\n		)
\n		AND(
\n			`view_schedule`.`jobDone` = 2
\n		)
\n		AND(
\n			`view_schedule`.`sheduleDate` > _utf8 \'2013/01/01\'
\n		)
\n	)