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/07/01\') and (`reports_jobs_per_plumber_detail`.`sheduleDate` < _utf8\'2013/07/15\') 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%\')) and (not((`reports_jobs_per_plumber_detail`.`jobname` like _utf8\'%Finish Job%\'))) and (not((`reports_jobs_per_plumber_detail`.`jobname` like _utf8\'%Photos%\')))) group by `reports_jobs_per_plumber_detail`.`jobname`
md5=c126be070054b0f394083ed9882e3954
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=12
timestamp=2013-07-18 16:08:31
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
\n	(
\n		(
\n			`reports_jobs_per_plumber_detail`.`sheduleDate` > _utf8 \'2013/07/01\'
\n		)
\n		AND(
\n			`reports_jobs_per_plumber_detail`.`sheduleDate` < _utf8 \'2013/07/15\'
\n		)
\n		AND(
\n			(
\n				`reports_jobs_per_plumber_detail`.`jobname` LIKE _utf8 \'%Inspection%\'
\n			)
\n			OR(
\n				`reports_jobs_per_plumber_detail`.`jobname` LIKE _utf8 \'%Job%\'
\n			)
\n			OR(
\n				`reports_jobs_per_plumber_detail`.`jobname` LIKE _utf8 \'%Audit%\'
\n			)
\n			OR(
\n				`reports_jobs_per_plumber_detail`.`jobname` LIKE _utf8 \'%Comeback%\'
\n			)
\n		)
\n		AND(
\n			NOT(
\n				(
\n					`reports_jobs_per_plumber_detail`.`jobname` LIKE _utf8 \'%Finish Job%\'
\n				)
\n			)
\n		)
\n		AND(
\n			NOT(
\n				(
\n					`reports_jobs_per_plumber_detail`.`jobname` LIKE _utf8 \'%Photos%\'
\n				)
\n			)
\n		)
\n	)
\nGROUP BY
\n	`reports_jobs_per_plumber_detail`.`jobname`