Error: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 ptrp.products_id_related' at line 18

---

SELECT ptrp.products_id_related , p.products_image AS child_img , pd.products_name AS child_product_name , p.products_is_child , pp.parents_id , pp.parents_name , pp.parents_image FROM products_to_related_products AS ptrp JOIN products_description AS pd ON pd.products_id = ptrp.products_id_related JOIN products AS p ON p.products_id = pd.products_id LEFT JOIN products_parents AS pp ON pp.parents_id=p.parents_id WHERE GROUP BY ptrp.products_id_related