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 'JOIN products ON prod.prod_id = products.id LEFT JOIN ( ' at line 6
SELECT products.id, product_name, products.slug, categories.slug AS cat_slug, rooms.slug AS room_slug, IF(products.offer_price > 0, products.offer_price, products.price) AS theprice, SUBSTRING(MIN(CONCAT(RPAD(prod_imgs.theorder, 6, ' ' ), prod_imgs.img)), 7) AS img FROM prod_groups LEFT JOIN prod_groups AS prod ON prod.grp_id = prod_groups.grp_id AND prod.prod_id != JOIN products ON prod.prod_id = products.id LEFT JOIN ( SELECT prod_id, MIN( theorder ) AS minorder FROM prod_imgs GROUP BY prod_id ) AS minsel ON products.id = minsel.prod_id LEFT JOIN prod_imgs ON prod_imgs.prod_id = products.id AND prod_imgs.theorder = minsel.minorder JOIN prod_cat_map ON products.id = prod_cat_map.prod_id JOIN categories ON categories.id = prod_cat_map.cat_id JOIN rooms ON room_id = rooms.id WHERE prod_groups.prod_id = GROUP BY products.id ORDER BY product_name LIMIT 8