SELECT r.review_id, r.image, r.author, r.rating,r.rating_new, r.text,r.reviewimg,r.product_id,r.order_id, r.date_added,r.occasiontype,r.shipping_city FROM agl_review r WHERE r.product_type='Plants' AND r.status ='1' and r.rating IN (4,5) group by r.text ORDER BY r.review_id DESC LIMIT 10