|
||||||
select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r inner join reviews_description rd on r.reviews_id = rd.reviews_id left outer join products p on p.products_id = r.products_id and p.products_status = '1' left outer join products_description pd on p.products_id = pd.products_id and pd.language_id = '5' where length(rd.reviews_text) > 15 and rd.languages_id = '5' and r.reviews_id != order by r.reviews_id desc limit 10 [TEP STOP] |