TYPE=VIEW
query=select `jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName` from ((((`jjlourens2`.`setup_insurer` join `jjlourens2`.`job` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) where (`jjlourens2`.`job_schedule`.`jobDone` = 1) order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=66e04d5f08aa7e64a272c6d9f7f5a8af
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-07-16 16:48:37
create-version=1
source=SELECT
\n	`job_schedule`.`sheduleDate` AS `sheduleDate`,
\n	`setup_insurer`.`insName` AS `insName`,
\n	`job_type`.`tName` AS `tName`,
\n	`setup_scheduletype`.`ActionName` AS `ActionName`
\nFROM
\n	(
\n		(
\n			(
\n				(
\n					`setup_insurer`
\n					JOIN `job` ON(
\n						(
\n							`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`
\n						)
\n					)
\n				)
\n				JOIN `job_schedule` ON(
\n					(
\n						`job`.`pk_job` = `job_schedule`.`fk_job`
\n					)
\n				)
\n			)
\n			JOIN `job_type` ON(
\n				(
\n					`job_type`.`pk_jtype` = `job_schedule`.`jobCat`
\n				)
\n			)
\n		)
\n		JOIN `setup_scheduletype` ON(
\n			(
\n				`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`
\n			)
\n		)
\n	)
\nWHERE jobDone=1
\nORDER BY
\n	`job_schedule`.`sheduleDate`