SQL USED : SELECT products.*,IF(products.featured_products=1 OR products.popular_product=1 OR products.new_collection=1 OR products.ex_d=1, '1', '0') AS fpc,CONCAT('image/',i1.folder,'/',i1.id,i1.type) as image1 FROM products LEFT JOIN image as i1 on i1.id=products.image_1 WHERE products.visible = 1 and products.del_i=0 AND products.site in (0,2) AND (products.cat_id like '%,22,%') GROUP BY products.sku ORDER BY fpc desc limit 0,12 @ products-listing.php line 376
SQL RESPONCE : Got error 28 from storage engine