Enhanced Search

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'group by `pb`.`id` order by `pb`.`brand` asc' at line 1

SQL:
select `pb`.`id`,`pb`.`brand` from `mcf_pbrand` as `pb` inner join `mcf_product` as `p` on `pb`.`id` = `p`.`bid` inner join `mcf_productc` as `pc` on `p`.`id` = `pc`.`pid` and `pc`.`scid`= group by `pb`.`id` order by `pb`.`brand` asc