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 )