Query : |
SELECT p.*,i.image FROM tbl_products as p
LEFT JOIN (SELECT * FROM tbl_product_image GROUP BY id ORDER BY id DESC) as i ON (p.id = i.product)
LEFT JOIN tbl_categories as c ON (p.category = c.id)
WHERE p.isactive = 'y' AND p.id = 12 GROUP BY p.id LIMIT 1 |