select pd.products_name, r.reviews_id, left(rd.reviews_text, 1000) as reviews_text,
r.reviews_rating, r.date_added, r.customers_name,r.products_id,rd.reviews_reply,rd.reviews_images,rd.reviews_video,rd.hair_length,rd.hair_color,rd.hair_density
from reviews r, reviews_description rd
,products p , products_description pd where r.reviews_id = rd.reviews_id and p.products_id = r.products_id and p.products_id = pd.products_id and p.products_status = 1
and rd.languages_id = '1' and rd.reviews_images != '' and r.status = '1' order by r.date_added desc