A Database Error Occurred
Error Number: 1064
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 products_items.id ORDER BY products_items.sort_order DESC' at line 5
SELECT products_items_description.*,products_items.*,products_description.url_key as url FROM products_items_description JOIN products_items USING (id) JOIN products_description ON products_description.id=products_items.cat_id AND products_items_description.id= GROUP BY products_items.id ORDER BY products_items.sort_order DESC