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 (631512, 592910, 592877, 592660, 592467, 589797, 586351, 584761, 574227, 574224, 572077, 572076, 572061, 572006, 12145, 4006, 390186, 452075, 454181, 454182, 478320, 366958, 366962, 367474, 367478, 367479, 367482, 367486, 422910, 273671)) 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,631512,592910,592877,592660,592467,589797,586351,584761,574227,574224,572077,572076,572061,572006,12145,4006,390186,452075,454181,454182,478320,366958,366962,367474,367478,367479,367482,367486,422910,273671)
-
[Black, Silver, Khaki, Burgundy, Olive]
SKU: KOD-MULTI-PURPOSE STRAP
Model: RK0401, RK0402, RK0403, RK0404, RK0405, RK0406
Condition: New-In-Box
-
Your Choice Of: 35mm, 120
SKU: KOD-PORTRA 800
Model: 1451855, 8127946
Condition: New-In-Box
-
Your Choice Of: 35mm, 120
SKU: KOD-TRI-X 400
Model: 1590652, 1153659, 1153659-1
Condition: New-In-Box
-
Your Choice Of: 24 Exposures, 36 Exposures
SKU: KOD-T-MAX 400
Model: 8947947, 8521114
Condition: New-In-Box
-
Your Choice Of: 35mm, 120
SKU: KOD-PORTRA 160
Model: 8120529, 1808674, 6031959-1, 6031959
Condition: New-In-Box
-
[Blue, Light Gray, Khaki, Black]
Sizes: Medium, Large
SKU: KOD-CAMERA WRAP
Model: RK0201, RK0202, RK0203, RK0204, RK0205, RK0206, RK0207, RK0208
Condition: New-In-Box
-
Your Choice Of: 1 Roll, 5 Rolls
SKU: KOD- GOLD 200 120
Model: 1075597
Condition: New-In-Box
-
SKU: KOD-11024A
Model: 1880806
Condition: New-In-Box
-
SKU: KOD-T-MAX 100 120
Model: 8572273, 8572273S
Condition: New-In-Box
-
Your Choice Of: 24 Exposures, 36 Exposures
SKU: KOD-T-MAX 100
Model: 8532848, 8292443
Condition: New-In-Box
-
SKU: KOD-6031470
Model: 6031470
Condition: New-In-Box
-
SKU: KOD-1075597S
Model: 1075597S
Condition: New-In-Box
-
SKU: KOD-13050
Model: 143876
Condition: New-In-Box
-
SKU: KOD-11025
Model: 1884576
Condition: New-In-Box
-
SKU: KOD-20310
Model: 8209827
Condition: New-In-Box
-
SKU: KOD-51023
Model: KOD-55MM FLD
Condition: New-In-Box
-
SKU: RDIS-BATT 7019
Model: 7019
Condition: New-In-Box
-
SKU: KOD-1006899
Model: 1006899
Condition: New-In-Box
-
SKU: KOD-11006
Model: 1587484
Condition: New-In-Box
-
SKU: KOD-11062A
Model: 1710516
Condition: New-In-Box
-
SKU: KOD-11072S
Model: P40036
Condition: New-In-Box
-
SKU: KOD-GOLD20035MM
Model: 6033955, 6033997, 6034003
Condition: New-In-Box
-
SKU: KOD-ULTRA MAX 400 35MM
Model: 6034029, 6034060, 1024389, 6030478, 6034037, 6034052
Condition: New-In-Box
-
SKU: RDIS-BATT 7014
Model: 7014
Condition: New-In-Box
-
SKU: RDIS-BATT 7020
Model: 7020
Condition: New-In-Box
-
SKU: RDIS-BATT 7021
Model: 7021
Condition: New-In-Box
-
SKU: RDIS-BATT 7011
Model: 7011
Condition: New-In-Box
-
SKU: RDIS-BATT 7012
Model: 7012
Condition: New-In-Box
-
SKU: KOD-1074418
Model: 1074418
Condition: New-In-Box
-
SKU: KOD-8004707
Model: 8004707
Condition: New-In-Box