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 (3596, 3603, 3605, 5718, 5723, 522831, 522854, 523629, 523907, 523976, 523997, 247413, 280782, 210167, 3592, 3601, 3602, 5704, 5710, 5715, 5717, 524116, 267576)) 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,3596,3603,3605,5718,5723,522831,522854,523629,523907,523976,523997,247413,280782,210167,3592,3601,3602,5704,5710,5715,5717,524116,267576)
-
SKU: PRI-00057
Model: PF357B425
Condition: New-In-Box
-
SKU: PRI-00091
Model: 57-4P25
Condition: New-In-Box
-
SKU: PRI-00099
Model: 810-2P25
Condition: New-In-Box
-
SKU: PRI-00079
Model: 46-6P25
Condition: New-In-Box
-
SKU: PRI-00110
Model: ALB-S ALBUM
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack
SKU: PRI-120-3HB
Model: 120-3HB-25, 120-3HB-100
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack
SKU: PRI-120-4B
Model: 120-4B25, 120-4B100
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack
SKU: PRI-2x2-20B
Model: 2X2-20B25, 2X2-20B100
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack
SKU: PRI-2x2-20H
Model: 2X2-20H25, 2X2-20H100
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack
SKU: PRI-35-6HB
Model: 35-6HB25, 35-6HB100
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack, 1000 Pack
SKU: 35-7B Negative Pages
Model: 35-7B25, 35-7B100, 35-7B1000
Condition: New-In-Box
-
SKU: PRI-00109
Model: PF13196PR
Condition: New-In-Box
-
SKU: PRI-00148T
Model: PFVUE200
Condition: New-In-Box
-
SKU: PRI-00144
Model: PFF12050
Condition: New-In-Box
-
SKU: PRI-00035
Model: 2X2-20HB25
Condition: New-In-Box
-
SKU: PRI-00088
Model: 55-4M25
Condition: New-In-Box
-
SKU: PRI-00089
Model: 57-2B100
Condition: New-In-Box
-
SKU: PRI-00017
Model: 225-12HB100
Condition: New-In-Box
-
SKU: PRI-00041
Model: 35-10P25
Condition: New-In-Box
-
SKU: PRI-00065
Model: 35-8P500
Condition: New-In-Box
-
SKU: PRI-00072
Model: 46-4M25
Condition: New-In-Box
-
Sizes: 25 Pack, 100 Pack
SKU: PRI-45-4B
Model: 45-4B25, 45-4B100
Condition: New-In-Box
-
SKU: PRI-00120
Model: PFFB1620
Condition: New-In-Box