select avg(rating) as rating from product_review pr inner join product_review_rating prr on prr.review_id=pr.review_id where (pr.products_id="7584" or (pr.categories_id in (0,) and pr.manufacturers_id in (0,0) and (pr.categories_id > "0" or pr.manufacturers_id > "0")) or pr.unique_identifiers like "%0%")and pr.approved="1"
[TEP STOP]