TYPE=VIEW
query=select `reports_jobs_per_plumber_detail`.`jobname` AS `jobname`,count(`reports_jobs_per_plumber_detail`.`jobname`) AS `totaljobs` from `jjlourens2`.`reports_jobs_per_plumber_detail` where ((`reports_jobs_per_plumber_detail`.`sheduleDate` > _utf8\'2013/01/01\') and (`reports_jobs_per_plumber_detail`.`sheduleDate` < _utf8\'2013/01/31\') and ((`reports_jobs_per_plumber_detail`.`jobname` like _utf8\'%Inspection%\') or (`reports_jobs_per_plumber_detail`.`jobname` like _utf8\'%Job%\') or (`reports_jobs_per_plumber_detail`.`jobname` like _utf8\'%Audit%\') or (`reports_jobs_per_plumber_detail`.`jobname` like _utf8\'%Comeback%\'))) group by `reports_jobs_per_plumber_detail`.`jobname`
md5=38dec750618442eea8fa1774b68d90fd
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=10
timestamp=2013-07-18 15:11:53
create-version=1
source=SELECT
\n	`reports_jobs_per_plumber_detail`.`jobname` AS `jobname`,
\n	count(
\n		`reports_jobs_per_plumber_detail`.`jobname`
\n	)AS `totaljobs`
\nFROM
\n	`reports_jobs_per_plumber_detail`
\nWHERE
\nsheduleDate > \'2013/01/01\'AND sheduleDate < \'2013/01/31\'AND 
\n(jobname LIKE \'%Inspection%\' OR  jobname LIKE \'%Job%\' OR jobname LIKE \'%Audit%\' OR jobname LIKE \'%Comeback%\')
\n
\nGROUP BY
\n	`reports_jobs_per_plumber_detail`.`jobname`