You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND g.active = '1' GROUP BY `s`.`good_id` ' at line 33