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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e`
INNER JOIN `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 `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1
LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0
LEFT JOIN `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 `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id
LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (565897, 565895, 565894, 565893, 565891, 565890, 565888, 545441, 7009, 7014, 7016, 995, 1867, 77752, 77753, 6985, 6986, 6987, 6989, 6990, 6991, 6994, 6995, 6996, 7004, 7017, 7028, 7030, 7033, 7036)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,565897,565895,565894,565893,565891,565890,565888,545441,7009,7014,7016,995,1867,77752,77753,6985,6986,6987,6989,6990,6991,6994,6995,6996,7004,7017,7028,7030,7033,7036)
-
SKU: DOM-700-02A
Model: 700-02A
Condition: New-In-Box
-
SKU: DOM-700-80A
Model: 700-80A
Condition: New-In-Box
-
SKU: DOM-700-52S
Model: 700-52S
Condition: New-In-Box
-
SKU: DOM-700-52B
Model: 700-52B
Condition: New-In-Box
-
SKU: DOM-700-52A
Model: 700-52A
Condition: New-In-Box
-
SKU: DOM-700-30D
Model: 700-30D
Condition: New-In-Box
-
SKU: DOM-701-02A
Model: 701-02A
Condition: New-In-Box
-
Sizes: Small, Medium, Large, X-Large, XX-Large
SKU: DOM-VEST-SAND
Model: VEST-SAND-SM, VEST-SAND-MD, VEST-SAND-LG, VEST-SAND-XL, VEST-SAND-XXL
Condition: New-In-Box
-
SKU: DOM-700-02B
Model: 700-02B
Condition: New-In-Box
-
SKU: DOM-700-30B
Model: 700-30B
Condition: New-In-Box
-
SKU: DOM-700-40B
Model: 700-40B
Condition: New-In-Box
-
SKU: DOM-741-1BK
Model: 741-BK
Condition: New-In-Box
-
SKU: DOM-742-1BK
Model: 742-6BK
Condition: New-In-Box
-
SKU: DOM-GPINSERT-D5
Model: GPINSERT-D5
Condition: New-In-Box
-
SKU: DOM-J-CHRON-RM
Model: J-CHRON-RM
Condition: New-In-Box
-
SKU: DOM-722-11G
Model: 722-11G
Condition: New-In-Box
-
SKU: DOM-722-11R
Model: 722-11R
Condition: New-In-Box
-
SKU: DOM-722-11Y
Model: 722-11Y
Condition: New-In-Box
-
SKU: DOM-722-15G
Model: 722-15G
Condition: New-In-Box
-
SKU: DOM-722-15R
Model: 722-15R
Condition: New-In-Box
-
SKU: DOM-722-15Y
Model: 722-15Y
Condition: New-In-Box
-
SKU: DOM-722-19R
Model: 722-19R
Condition: New-In-Box
-
SKU: DOM-722-19G
Model: 722-19G
Condition: New-In-Box
-
SKU: DOM-722-19Y
Model: 722-19Y
Condition: New-In-Box
-
SKU: DOM-700-10B
Model: 700-10B
Condition: New-In-Box
-
SKU: DOM-700-40A
Model: 700-40A
Condition: New-In-Box
-
SKU: DOM-700-60B
Model: 700-60B
Condition: New-In-Box
-
SKU: DOM-700-70B
Model: 700-70B
Condition: New-In-Box
-
SKU: DOM-700-00A
Model: 700-00A
Condition: New-In-Box
-
SKU: DOM-701-82D
Model: 701-82D
Condition: New-In-Box