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, 995, 1867, 7009, 7014, 7016, 10857, 10858, 10859, 10860, 10862, 10863, 10113, 10117, 10118, 10121, 10123, 10127, 10175, 10182, 966, 967, 968)) 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,995,1867,7009,7014,7016,10857,10858,10859,10860,10862,10863,10113,10117,10118,10121,10123,10127,10175,10182,966,967,968)
-
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-741-1BK
Model: 741-BK
Condition: New-In-Box
-
SKU: DOM-742-1BK
Model: 742-6BK
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-710-05B
Model: 710-05B
Condition: New-In-Box
-
SKU: DOM-710-053
Model: 710-05S
Condition: New-In-Box
-
SKU: DOM-710-05D
Model: 710-05D
Condition: New-In-Box
-
SKU: DOM-710-05A
Model: 710-05A
Condition: New-In-Box
-
SKU: DOM-704-217
Model: 704-217
Condition: New-In-Box
-
SKU: DOM-704-220
Model: 704-220
Condition: New-In-Box
-
SKU: DOM-710-502
Model: 710-502
Condition: New-In-Box
-
SKU: DOM-700-53B
Model: 700-53B
Condition: New-In-Box
-
SKU: DOM-700-53S
Model: 700-53S
Condition: New-In-Box
-
SKU: DOM-706-612
Model: 706-612
Condition: New-In-Box
-
SKU: DOM-710-10D
Model: 710-10B
Condition: New-In-Box
-
SKU: DOM-710-20D
Model: 710-20D
Condition: New-In-Box
-
SKU: DOM-725-310
Model: 725-310
Condition: New-In-Box
-
SKU: DOM-745-1TN
Model: 745-1TAN
Condition: New-In-Box
-
SKU: DOM-722-11B
Model: 722-11B
Condition: New-In-Box
-
SKU: DOM-722-15B
Model: 722-15B
Condition: New-In-Box
-
SKU: DOM-722-19B
Model: 722-19B
Condition: New-In-Box