SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `_inv`.`stock_status`, IFNULL(_inv.stock_status,0) AS `in_stock`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `jd_catalog_product_entity` AS `e`
INNER JOIN `jd_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
LEFT JOIN `jd_cataloginventory_stock_status` AS `_inv` ON _inv.product_id = e.entity_id
LEFT JOIN `jd_review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `jd_review_entity` AS `review_entity` WHERE (entity_code = 'product'))
LEFT JOIN `jd_cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (NULL) ORDER BY `in_stock` DESC
We can't find products matching the selection.
B2B SOLUTIONS
Are you looking for B2B Solutions?
Chat now with our sales agent to learn about corporate deals or share your details and we will get in touch.
Validate your login
Sign In
Create New Account