Customer Reviews

1054 - Unknown column 'r.reviews_id' in 'on clause'

select r.reviews_id, r.customers_name, r.reviews_rating, p.products_id, p.products_image, ri.reviews_image, pd.products_name from reviews r, reviews_description rd left join reviews_images ri on r.reviews_id = ri.reviews_id and ri.reviews_status = '1', products p left join products_to_categories cc on p.products_id =cc.products_id, products_description pd where cc.categories_id = 28 and p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by ri.reviews_status desc limit 5

[TEP STOP]