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
SELECT `review_id`, `review_text`, `review_esp_text`, `review_title`, `review_esp_title`, `product_id`, `review_type`FROM (`az_review`)WHERE `review_id` = '9053'
SELECT `review_id`, `product_id`, `review_title`, `review_esp_title`, `review_type`, `review_domain`, `review_index`FROM (`az_review`)WHERE `product_id` = '1'ORDER BY `review_type` desc, `review_domain` asc, `review_index` asc