TYPE=VIEW
query=select `jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`job`.`fkInvoiced` AS `fkInvoiced`,`jjlourens2`.`job`.`fkInvoice1` AS `fkInvoice1`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`setup_user`.`userName` AS `userName` from ((`jjlourens2`.`job` join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_user` on((`jjlourens2`.`setup_user`.`pk_user` = `jjlourens2`.`job`.`finuInCharge`))) where ((`jjlourens2`.`job`.`fkInvoiced` = _utf8\'0\') or (`jjlourens2`.`job`.`fkInvoice1` = _utf8\'0\'))
md5=8631e0d3087f0a15d6d7447f842224ec
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-24 00:12:02
create-version=1
source=select `job`.`jbdate` AS `jbdate`,`job`.`fk_insurer` AS `fk_insurer`,`job`.`finuInCharge` AS `finuInCharge`,`setup_insurer`.`insName` AS `insName`,`setup_insurer`.`pk_insurer` AS `pk_insurer`,`job`.`fkInvoiced` AS `fkInvoiced`,`job`.`fkInvoice1` AS `fkInvoice1`,`job`.`jbClaimNo` AS `jbClaimNo`,`setup_user`.`userName` AS `userName` from ((`job` join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_user` on((`setup_user`.`pk_user` = `job`.`finuInCharge`))) where ((`job`.`fkInvoiced` = _utf8\'0\') or (`job`.`fkInvoice1` = _utf8\'0\'))