SELECT product_price, product_id, product_title, product_details_page_url, (product_amazon_uk_total_reviews + product_amazon_com_total_reviews) as reviews_eng, (product_amazon_de_total_reviews + product_amazon_fr_total_reviews) as reviews_de_fr, (select count(*) from az_review where az_review.product_id=az_product.product_id) as total_reviews, (select count(*) from az_review where az_review.product_id=az_product.product_id and review_type > 0) as total_reviews_0, (select count(*) from az_review where az_review.product_id=az_product.product_id and review_type > 4) as total_reviews_5, (select count(*) from az_review where az_review.product_id=az_product.product_id and review_type > 9) as total_reviews_10, (select category_name from az_category, az_rel_product_category where az_category.category_id = az_rel_product_category.category_id and rel_product_category_is_primary = 1 and az_rel_product_category.product_id = az_product.product_id) as categoria from az_product where product_amazon_uk_total_reviews + product_amazon_com_total_reviews + product_amazon_de_total_reviews + product_amazon_fr_total_reviews > 0 and product_id in (select az_review.product_id from az_review) order by product_price desc