Sorry! Query failed:
errorno=1064error=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 'group by p.product_id' at line 1query=select count(s.style) as style_count, count(s.price) as style_price_count, count(m.substyle_id) as substyle_count, count(m.price) as substyle_price_count from products p left join styles s on s.product_id=p.product_id left join style_substyle_map m on m.style_id=s.style_id where p.product_id = group by p.product_id