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`.`jobgo` = _utf8\'Yes\') and (`jjlourens2`.`job_solar_survey`.`eskomdocs` = _utf8\'Yes\') and (`jjlourens2`.`job_solar_survey`.`eskomrebate` = _utf8\'No\'))
md5=5a61a04a67c74a68353cf8514cca8dcb
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2013-11-26 01:09:23
create-version=1
source=select `job`.`jbClaimNo` AS `jbClaimNo`,`job_solar_survey`.`jobgo` AS `jobgo`,`job_solar_survey`.`eskomdocs` AS `eskomdocs`,`job_solar_survey`.`eskomrebate` AS `eskomrebate`,`job_solar_survey`.`datecap` AS `datecap` from (`job_solar_survey` join `job` on((`job`.`pk_job` = `job_solar_survey`.`fk_job`))) where ((`job_solar_survey`.`jobgo` = \'Yes\') and (`job_solar_survey`.`eskomdocs` = \'Yes\') and (`job_solar_survey`.`eskomrebate` = \'No\'))