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 (597456, 596502, 590981, 16605, 16613, 16914, 10707, 2358, 2360, 10613, 10635, 10637, 10673, 10674, 10678, 10679, 10691, 10695, 10705, 1202, 1203, 1209, 1226, 1258, 1261, 19694, 96935, 111350, 118434, 118435)) 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,597456,596502,590981,16605,16613,16914,10707,2358,2360,10613,10635,10637,10673,10674,10678,10679,10691,10695,10705,1202,1203,1209,1226,1258,1261,19694,96935,111350,118434,118435)
-
[Photo Black, Matte Black, Light Black, Light Light Black, Cyan, Light Cyan. Vivid Magenta, Vivid Light Magenta, Yellow]
SKU: EPS-UC HD 700ML
Model: T55K100, T55K200, T55K300, T55K400, T55K500, T55K600, T55K700,T55K800, T55K900
Condition: New-In-Box
-
[Photo Black, Matte Black, Light Black, Light Light Black, Photo Cyan, Light Cyan, Vivid Magenta, Vivid Light Magenta, Yellow, Orange, Green]
SKU: EPS-UC HD 350ML
Model: T54X100, T54X200, T54X300, T54X400, T54X500, T54X600, T54X700, T54X800, T54X900, T54XA00, T54XB00
Condition: New-In-Box
-
SKU: EPS-10015
Model: B11B237201
Condition: New-In-Box
-
SKU: EPS-30094
Model: S041914
Condition: New-In-Box
-
SKU: EPS-36074
Model: S041853
Condition: New-In-Box
-
SKU: EPS-36327
Model: S041598
Condition: New-In-Box
-
SKU: EPS-36322
Model: S041595
Condition: New-In-Box
-
SKU: EPS-20160
Model: T096120
Condition: New-In-Box
-
SKU: EPS-20162
Model: T096320
Condition: New-In-Box
-
SKU: EPS-30082
Model: S041062
Condition: New-In-Box
-
SKU: EPS-30110
Model: S041405
Condition: New-In-Box
-
SKU: EPS-30112
Model: S041406
Condition: New-In-Box
-
SKU: EPS-36010
Model: S041742
Condition: New-In-Box
-
SKU: EPS-36012
Model: S041638
Condition: New-In-Box
-
SKU: EPS-36032
Model: S042150
Condition: New-In-Box
-
SKU: EPS-36034
Model: S042151
Condition: New-In-Box
-
SKU: EPS-36106
Model: S042083
Condition: New-In-Box
-
SKU: EPS-36140
Model: S041385
Condition: New-In-Box
-
SKU: EPS-36280
Model: S045234
Condition: New-In-Box
-
SKU: EPS-20163
Model: T096420
Condition: New-In-Box
-
SKU: EPS-20164
Model: T096520
Condition: New-In-Box
-
SKU: EPS-24015
Model: T580600
Condition: New-In-Box
-
SKU: EPS-24100
Model: T614800
Condition: New-In-Box
-
SKU: EPS-36110
Model: S041390
Condition: New-In-Box
-
SKU: EPS-36304
Model: S042003
Condition: New-In-Box
-
SKU: EPS-18044
Model: B11B224201
Condition: New-In-Box
-
SKU: EPS-26303
Model: T913400
Condition: New-In-Box
-
SKU: EPS-16090
Model: T699700
Condition: New-In-Box
-
SKU: EPS-25601
Model: T800100
Condition: New-In-Box
-
SKU: EPS-25602
Model: T800200
Condition: New-In-Box