TYPE=VIEW
query=select `jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job_solar_survey`.`jobgo` AS `jobgo`,`jjlourens2`.`job_solar_survey`.`eskomdocs` AS `eskomdocs`,`jjlourens2`.`job_solar_survey`.`eskomrebate` AS `eskomrebate`,`jjlourens2`.`job_solar_survey`.`datecap` AS `datecap` from (`jjlourens2`.`job_solar_survey` join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_solar_survey`.`fk_job`))) where ((`jjlourens2`.`job_solar_survey`.`eskomdocs` = _utf8\'Yes\') and (`jjlourens2`.`job_solar_survey`.`eskomrebate` = _utf8\'No\'))
md5=1e42d8f1bca7960f57119ff1cb667dec
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-11-26 01:13:38
create-version=1
source=SELECT
\n	`job`.`jbClaimNo` AS `jbClaimNo`,
\n	`job_solar_survey`.`jobgo` AS `jobgo`,
\n	`job_solar_survey`.`eskomdocs` AS `eskomdocs`,
\n	`job_solar_survey`.`eskomrebate` AS `eskomrebate`,
\n	`job_solar_survey`.`datecap` AS `datecap`
\nFROM
\n	(
\n		`job_solar_survey`
\n		JOIN `job` ON(
\n			(
\n				`job`.`pk_job` = `job_solar_survey`.`fk_job`
\n			)
\n		)
\n	)
\nWHERE
\n	(
\n		(
\n			`job_solar_survey`.`eskomdocs` = _utf8 \'Yes\'
\n		)
\n		AND(
\n			`job_solar_survey`.`eskomrebate` = _utf8 \'No\'
\n		)
\n	)