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 (615053, 615028, 615020, 605460, 605457, 605456, 605453, 605447, 605446, 605442, 605434, 605431, 565379, 565378, 565352, 565351, 565350, 565349, 545796, 545794, 545792, 545790, 545787, 3536, 3542, 15766, 15771, 15778, 381205, 381210)) 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,615053,615028,615020,605460,605457,605456,605453,605447,605446,605442,605434,605431,565379,565378,565352,565351,565350,565349,545796,545794,545792,545790,545787,3536,3542,15766,15771,15778,381205,381210)
-
Your Choice Of: 0.5 f-stop, 1 f-stop, 1.5 f-stop
SKU: PRF-1X4 DIFFUSER KIT
Model: 201609, 2016012, 201615
Condition: New-In-Box
-
Your Choice Of: 0.5 f-stop, 1 f-stop, 1.5 f-stop
SKU: PRF-SOFTBOX 2X3 DIFFUSER KIT
Model: 201608, 201611, 201614
Condition: New-In-Box
-
Your Choice Of: 0.5 f-stop, 1 f-stop, 1.5 f-stop
SKU: PRF- 3 OCTA DIFFUSER KIT
Model: 201607, 201610, 201613
Condition: New-In-Box
-
SKU: PRF-201606
Model: 201606
Condition: New-In-Box
-
SKU: PRF-201603
Model: 201603
Condition: New-In-Box
-
SKU: PRF-201503
Model: 201503
Condition: New-In-Box
-
SKU: PRF-201605
Model: 201605
Condition: New-In-Box
-
SKU: PRF-201602
Model: 201602
Condition: New-In-Box
-
SKU: PRF-201502
Model: 201502
Condition: New-In-Box
-
SKU: PRF-201604
Model: 201604
Condition: New-In-Box
-
SKU: PRF-201601
Model: 201601
Condition: New-In-Box
-
SKU: PRF-201501
Model: 201501
Condition: New-In-Box
-
SKU: PRF-101712
Model: 101712
Condition: New-In-Box
-
SKU: PRF-101711
Model: 101711
Condition: New-In-Box
-
SKU: PRF-101709
Model: 101709
Condition: New-In-Box
-
SKU: PRF-101708
Model: 101708
Condition: New-In-Box
-
SKU: PRF-101703
Model: 101703
Condition: New-In-Box
-
SKU: PRF-101702
Model: 101702
Condition: New-In-Box
-
SKU: PRF-101317
Model: 101317
Condition: New-In-Box
-
SKU: PRF-340220
Model: 340220
Condition: New-In-Box
-
SKU: PRF-340219
Model: 340219
Condition: New-In-Box
-
SKU: PRF-101310
Model: 101310
Condition: New-In-Box
-
SKU: PRF-101312
Model: 101312
Condition: New-In-Box
-
SKU: PRF-100608
Model: 100608 (505-507)
Condition: New-In-Box
-
SKU: PRF-100624
Model: 100624 (505-504)
Condition: New-In-Box
-
SKU: PRF-100509
Model: 100509
Condition: New-In-Box
-
SKU: PRF-254623
Model: 254623
Condition: New-In-Box
-
SKU: PRF-254630
Model: 254630
Condition: New-In-Box
-
SKU: PRF-101233
Model: 101233
Condition: New-In-Box
-
SKU: PRF-101232
Model: 101232
Condition: New-In-Box