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 (594868, 593789, 591420, 591374, 591371, 591370, 591368, 591367, 591365, 584745, 584697, 584692, 584689, 584684, 584259, 538292, 538291, 83000, 86108, 86109, 144516, 144517, 187978, 482998, 347562, 347604, 347631, 347645, 360329, 416607)) 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,594868,593789,591420,591374,591371,591370,591368,591367,591365,584745,584697,584692,584689,584684,584259,538292,538291,83000,86108,86109,144516,144517,187978,482998,347562,347604,347631,347645,360329,416607)
-
[Charcoal, Sage, Midnight, Red]
SKU: PED-WALLET SLIM
Model: M-WA-AA-CH-1, M-WA-AA-RD-1, M-WA-AA-SG-1, M-WA-AA-MN-1
Condition: New-In-Box
-
[Charcoal, Midnight Blue, Sun Yellow, Redwood]
SKU: PED-WALLET STAND
Model: M-WA-AB-CH-1, M-WA-AB-SN-1, M-WA-AB-MN-1, M-WA-AB-RD-1
Condition: New-In-Box
-
SKU: PED-00708
Model: M-BM-AA-BK-1
Condition: New-In-Box
-
SKU: PED-00780
Model: M-MC-AR-CH-1
Condition: New-In-Box
-
SKU: PED-00771
Model: M-MC-BC-CH-1
Condition: New-In-Box
-
SKU: PED-00770
Model: M-MC-BB-CH-1
Condition: New-In-Box
-
SKU: PED-00755
Model: M-LC-BL-CH-1
Condition: New-In-Box
-
SKU: PED-00750
Model: M-MC-BL-CH-1
Condition: New-In-Box
-
SKU: PED-00745
Model: M-LC-BK-CH-1
Condition: New-In-Box
-
SKU: PED-00740
Model: M-MC-BK-CH-1
Condition: New-In-Box
-
SKU: PED-00705
Model: M-BM-AB-BK-1
Condition: New-In-Box
-
SKU: PED-00704
Model: M-CM-AB-BK-1
Condition: New-In-Box
-
SKU: PED-00703
Model: M-CK-AA-BK-1
Condition: New-In-Box
-
SKU: PED-00702
Model: M-TR-AA-BK-1
Condition: New-In-Box
-
SKU: PED-00700
Model: M-CS-BK-1
Condition: New-In-Box
-
SKU: PED-00158
Model: MC-L-1
Condition: New-In-Box
-
SKU: PED-00157
Model: MC-S-1
Condition: New-In-Box
-
SKU: PED-00178
Model: SH-S-1
Condition: New-In-Box
-
SKU: PED-00178A
Model: SH-M-1
Condition: New-In-Box
-
SKU: PED-00179B
Model: SH-L-1
Condition: New-In-Box
-
SKU: PED-00114
Model: CP-BK-3
Condition: New-In-Box
-
SKU: PED-00115
Model: CP-S-3
Condition: New-In-Box
-
SKU: PED-001394
Model: 4PK-AN-4
Condition: New-In-Box
-
[Black, Bone, Charcoal, Midnight, Sage]
SKU: PED-TECHPOUCH
Model: BTP-BK-1, BTP-SG-1, BTP-CH-2, BTP-BO-2, BTP-MN-2
Condition: New-In-Box
-
[Black, Ash, Charcoal, Midnight Blue]
SKU: PED-EVERYDAY BACKPACK 20L V2
Model: BEDB-20-BK-2, BEDB-20-CH-2, BEDB-20-AS-2, BEDB-20-MN-2
Condition: New-In-Box
-
[Black, Ash]
SKU: PED-EVERYDAY SLING 3L
Model: BEDS-3-BK-2, BEDS-3-AS-2
Condition: New-In-Box
-
[Black, Sage, Midnight, Charcoal, Bone]
SKU: PED-TECH POUCH
Model: BTP-BK-1, BTP-SG-1
Condition: New-In-Box
-
[Black, Ash, Midnight, Sage]
SKU: PED-CUFFWRISTSTRAP
Model: CF-BL-3, CF-AS-3, CF-SG-3, CF-MN-3
Condition: New-In-Box
-
SKU: PED-00175A
Model: PL-S-3
Condition: New-In-Box
-
SKU: PED-SL-SG-3 SLIDE
Model: SL-AS-3, SL-MN-3, SL-BK-3, SL-SG-3
Condition: New-In-Box