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, 545796, 545794, 545792, 545790, 545787, 262654, 262672, 193502, 194567, 194568, 200605, 130779, 191063, 191101, 224815, 225192, 270868, 309897)) 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,545796,545794,545792,545790,545787,262654,262672,193502,194567,194568,200605,130779,191063,191101,224815,225192,270868,309897)
-
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-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-101230
Model: 101230
Condition: New-In-Box
-
SKU: PRF-101021
Model: 101021
Condition: New-In-Box
-
SKU: PRF-100398
Model: 100398
Condition: New-In-Box
-
SKU: PRF-100440
Model: 100440
Condition: New-In-Box
-
SKU: PRF-100441
Model: 100441
Condition: New-In-Box
-
SKU: PRF-254715
Model: 254715
Condition: New-In-Box
-
SKU: PRF-101209
Model: 101209
Condition: New-In-Box
-
SKU: PRF-101227
Model: 101227
Condition: New-In-Box
-
SKU: PRF-101205
Model: 101205
Condition: New-In-Box
-
SKU: PRF-100977
Model: 100977
Condition: New-In-Box
-
SKU: PRF-100979
Model: 100979
Condition: New-In-Box
-
SKU: PRF-901304
Model: 901304
Condition: New-In-Box
-
SKU: PRF-101127
Model: 101127
Condition: New-In-Box