Error Found
Error No. : 1055
Error String : Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'i.image' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
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 = 13 GROUP BY p.id LIMIT 1