1052 - Column 'products_id' in from clause is ambiguous
select distinct p.products_id, p.products_model, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price, m.manufacturers_name, avg(r.reviews_rating) as avg_rating from products p left join manufacturers m using(manufacturers_id) left join reviews r on r.products_id = p.products_id left join products_to_categories p2c using(products_id) left join categories c using(categories_id) left join featured f on p.products_id = f.products_id left join specials s on p.products_id = s.products_id where c.parent_id = '849' and p.products_status = '1' and f.status = '1' group by p.products_id order by rand() DESC limit 14