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`.`sheduleDate` between _utf8\'2013-05-01\' and _utf8\'2013-06-01\') order by `jjlourens2`.`job_schedule`.`sheduleDate`
md5=cadf2d2d7b7ee44265ec08fad631a153
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-06-28 00:31:48
create-version=1
source=SELECT
\njob_schedule.sheduleDate,
\nsetup_insurer.insName AS insName,
\njob_type.tName,
\nsetup_scheduleType.ActionName
\nFROM
\n(((setup_insurer
\nJOIN job ON ((setup_insurer.pk_insurer = job.fk_insurer)))
\nJOIN job_schedule ON ((job.pk_job = job_schedule.fk_job))))
\nINNER JOIN job_type ON job_type.pk_jtype = job_schedule.jobCat
\nINNER JOIN setup_scheduleType ON setup_scheduleType.pkaction = job_schedule.jobType
\nWHERE  sheduleDate BETWEEN \'2013-05-01\' AND \'2013-06-01\'
\nORDER BY sheduleDate ASC