TYPE=VIEW
query=select `jjlourens2`.`job_quote`.`pk_quote` AS `pk_quote`,`jjlourens2`.`job_quote`.`fk_job` AS `fk_job`,`jjlourens2`.`job_quoteitem`.`pk_quoteItem` AS `pk_quoteItem`,`jjlourens2`.`job_quoteitem`.`fk_quote` AS `fk_quote`,`jjlourens2`.`job_quoteitem`.`price` AS `price`,`jjlourens2`.`job_quote`.`addDate` AS `addDate`,`jjlourens2`.`job_quoteitem`.`quantity` AS `quantity`,`jjlourens2`.`job_quoteitem`.`qdescription` AS `qdescription`,`jjlourens2`.`job_quote`.`Description1` AS `Description1` from (`jjlourens2`.`job_quote` join `jjlourens2`.`job_quoteitem` on((`jjlourens2`.`job_quote`.`pk_quote` = `jjlourens2`.`job_quoteitem`.`fk_quote`))) group by `jjlourens2`.`job_quote`.`pk_quote`,`jjlourens2`.`job_quote`.`fk_job`,`jjlourens2`.`job_quote`.`Description1`,`jjlourens2`.`job_quoteitem`.`pk_quoteItem`,`jjlourens2`.`job_quoteitem`.`fk_quote`,`jjlourens2`.`job_quoteitem`.`qdescription`,`jjlourens2`.`job_quoteitem`.`delete`,`jjlourens2`.`job_quote`.`addDate`,`jjlourens2`.`job_quoteitem`.`price`
md5=304195714101989340e0319612430290
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-09-18 14:18:17
create-version=1
source=select `job_quote`.`pk_quote` AS `pk_quote`,`job_quote`.`fk_job` AS `fk_job`,`job_quoteitem`.`pk_quoteItem` AS `pk_quoteItem`,`job_quoteitem`.`fk_quote` AS `fk_quote`,`job_quoteitem`.`price` AS `price`,`job_quote`.`addDate` AS `addDate`,`job_quoteitem`.`quantity` AS `quantity`,`job_quoteitem`.`qdescription` AS `qdescription`,`job_quote`.`Description1` AS `Description1` from (`job_quote` join `job_quoteitem` on((`job_quote`.`pk_quote` = `job_quoteitem`.`fk_quote`))) group by `job_quote`.`pk_quote`,`job_quote`.`fk_job`,`job_quote`.`Description1`,`job_quoteitem`.`pk_quoteItem`,`job_quoteitem`.`fk_quote`,`job_quoteitem`.`qdescription`,`job_quoteitem`.`delete`,`job_quote`.`addDate`,`job_quoteitem`.`price`