TYPE=VIEW
query=select `jjlourens2`.`job_solar_survey`.`id` AS `id`,`jjlourens2`.`job_solar_survey`.`clid` AS `clid`,`jjlourens2`.`job_solar_survey`.`clutility` AS `clutility`,`jjlourens2`.`job_solar_survey`.`problemJob` AS `problemJob`,`jjlourens2`.`job_solar_survey`.`signquote` AS `signquote`,`jjlourens2`.`job_solar_survey`.`proofpay` AS `proofpay`,`jjlourens2`.`job_solar_survey`.`fk_job` AS `fk_job`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`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`.`clid` = _utf8\'Yes\') and (`jjlourens2`.`job_solar_survey`.`clutility` = _utf8\'Yes\') and (`jjlourens2`.`job_solar_survey`.`problemJob` = _utf8\'No\') and (`jjlourens2`.`job_solar_survey`.`proofpay` = _utf8\'Yes\') and (`jjlourens2`.`job_solar_survey`.`jobgo` = _utf8\'No\'))
md5=c838381703504db4c975a295f25ed213
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2013-11-07 00:22:42
create-version=1
source=select `job_solar_survey`.`id` AS `id`,`job_solar_survey`.`clid` AS `clid`,`job_solar_survey`.`clutility` AS `clutility`,`job_solar_survey`.`problemJob` AS `problemJob`,`job_solar_survey`.`signquote` AS `signquote`,`job_solar_survey`.`proofpay` AS `proofpay`,`job_solar_survey`.`fk_job` AS `fk_job`,`job`.`jbClaimNo` AS `jbClaimNo`,`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`.`clid` = \'Yes\') and (`job_solar_survey`.`clutility` = \'Yes\') and (`job_solar_survey`.`problemJob` = \'No\') and (`job_solar_survey`.`proofpay` = \'Yes\') and (`job_solar_survey`.`jobgo` = \'No\'))