Got error 28 from storage engine
SELECT DISTINCT p.*,i.image FROM am_products p LEFT JOIN am_products_images i ON p.id=i.products_id AND i.id=(SELECT MIN(id) FROM am_products_images WHERE products_id=p.id GROUP BY products_id) WHERE p.pstatus=1 AND p.categories_id=43 ORDER BY p.id DESC LIMIT 0,5