Отзиви

1060 - Duplicate column name 'products_id'

select count(*) as total from (select r.*, rd.reviews_text as reviews_text, p.products_id, pd.products_name, p.products_image,m.manufacturers_name as brand_name, (select rsd.reviews_text FROM reviews_service_description rsd where rsd.reviews_id=r.reviews_id and rsd.languages_id = '4') as review_service from reviews r, reviews_description rd, products p , manufacturers m , products_description pd where p.manufacturers_id=m.manufacturers_id and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and p.products_id = pd.products_id and pd.language_id = '4' and rd.languages_id = '4' and r.reviews_rating=5 order by r.date_added DESC) as t

[TEP STOP]