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 (463909, 468520, 485054, 485056, 485057, 339487, 339488, 342543, 403502, 403506, 403507, 403550, 423486, 485060, 485061, 514463, 514464, 514467, 522041, 262654, 262672, 270868, 309897, 309911, 309913, 224815, 225192, 233887, 52769, 67188)) 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,463909,468520,485054,485056,485057,339487,339488,342543,403502,403506,403507,403550,423486,485060,485061,514463,514464,514467,522041,262654,262672,270868,309897,309911,309913,224815,225192,233887,52769,67188)
-
SKU: PRF-901250
Model: 901250
Condition: New-In-Box
-
Your Choice Of: Non-TTL, Canon, Nikon, Fujifilm, Sony, Leica
SKU: PRF-CONNECT PRO
Model: 901320, 901321, 901322, 901323, 901324, 901325
Condition: New-In-Box
-
SKU: PRF-101305
Model: 101305
Condition: New-In-Box
-
SKU: PRF-101306
Model: 101306
Condition: New-In-Box
-
SKU: PRF-101307
Model: 101307
Condition: New-In-Box
-
Profoto
A10
USD $1,095.00
Your Choice Of: Canon, Nikon, Sony, Fujifilm
SKU: PRF- A10
Model: 901230-US, 901231-US, 901232-US, 901233-US
Condition: New-In-Box
-
Your Choice Of: Canon, Nikon, Sony, Fujifilm
SKU: PRF- OFF CAMERA KIT A10
Model: 901240-US, 901241-US, 901242-US, 901243-US
Condition: New-In-Box
-
SKU: PRF-101130
Model: 101130
Condition: New-In-Box
-
SKU: PRF-901193
Model: 901193
Condition: New-In-Box
-
Profoto
B10X
USD $1,795.00
SKU: PRF-901192
Model: 901192
Condition: New-In-Box
-
SKU: PRF-901195
Model: 901195
Condition: New-In-Box
-
SKU: PRF-901194
Model: 901194
Condition: New-In-Box
-
SKU: PRF-101304
Model: 101304
Condition: New-In-Box
-
SKU: PRF-101315
Model: 101315
Condition: New-In-Box
-
SKU: PRF-101316
Model: 101316
Condition: New-In-Box
-
SKU: PRF-101321
Model: 101321
Condition: New-In-Box
-
SKU: PRF-101308
Model: 101308
Condition: New-In-Box
-
SKU: PRF-101319
Model: 101319
Condition: New-In-Box
-
Your Choice Of: Canon, Sony, Nikon, Fuji, Olympus
SKU: Connect
Model: 901310, 901312, 901314, 901316, 901318
Condition: New-In-Box
-
SKU: PRF-101230
Model: 101230
Condition: New-In-Box
-
SKU: PRF-101021
Model: 101021
Condition: New-In-Box
-
SKU: PRF-901304
Model: 901304
Condition: New-In-Box
-
SKU: PRF-101127
Model: 101127
Condition: New-In-Box
-
SKU: PRF-101121
Model: 101121
Condition: New-In-Box
-
SKU: PRF-101123
Model: 101123
Condition: New-In-Box
-
SKU: PRF-100977
Model: 100977
Condition: New-In-Box
-
SKU: PRF-100979
Model: 100979
Condition: New-In-Box
-
SKU: PRF-100498
Model: 100498
Condition: New-In-Box
-
SKU: PRF-101220
Model: 101220
Condition: New-In-Box
-
SKU: PRF-100974
Model: 100974
Condition: New-In-Box