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 (627614, 618729, 616792, 608698, 602604, 602601, 602600, 602109, 596891, 596890, 596889, 596888, 596886, 588422, 588403, 573365, 565661, 564557, 564556, 564555, 564554, 564549, 555234, 549001, 546142, 546110, 12443, 13803, 13804, 13805)) 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,627614,618729,616792,608698,602604,602601,602600,602109,596891,596890,596889,596888,596886,588422,588403,573365,565661,564557,564556,564555,564554,564549,555234,549001,546142,546110,12443,13803,13804,13805)
-
SKU: WES-7657N
Model: 7657-N
Condition: New-In-Box
-
SKU: WES-00879S
Model: 879S
Condition: New-In-Box
-
SKU: WES-00878
Model: 878
Condition: New-In-Box
-
SKU: WES-0645C
Model: 645C
Condition: New-In-Box
-
SKU: WES-00803
Model: 803
Condition: New-In-Box
-
SKU: WES-00804
Model: 804
Condition: New-In-Box
-
SKU: WES-00810
Model: 810
Condition: New-In-Box
-
SKU: WES-OPTICAL SPOT W 50MM LENS
Model: 4760B-50, 4760P-50
Condition: New-In-Box
Available For: Bowens, Profoto
-
SKU: WES-07145
Model: 7145
Condition: New-In-Box
-
SKU: WES-07146
Model: 7146
Condition: New-In-Box
-
SKU: WES-07144
Model: 7144
Condition: New-In-Box
-
SKU: WES-04663
Model: 4663
Condition: New-In-Box
-
SKU: WES-04664
Model: 4664
Condition: New-In-Box
-
SKU: WES-07351
Model: 7351
Condition: New-In-Box
-
SKU: WES-0631
Model: 631
Condition: New-In-Box
-
SKU: WES-00877
Model: 877
Condition: New-In-Box
-
SKU: WES-00667C
Model: 667C
Condition: New-In-Box
-
SKU: WES-01581
Model: 1581
Condition: New-In-Box
-
SKU: WES-01580
Model: 1580
Condition: New-In-Box
-
SKU: WES-01576
Model: 1576
Condition: New-In-Box
-
SKU: WES-01575
Model: 1575
Condition: New-In-Box
-
SKU: WES-05145
Model: 5145
Condition: New-In-Box
-
SKU: WES-01789
Model: 1789
Condition: New-In-Box
-
SKU: WES-00880S
Model: 880S
Condition: New-In-Box
-
Your Choice Of: Bowens, Elinchrom, Broncolor, Profoto
SKU: WES-OPTICAL SPOT
Model: 4760B, 4760BR, 4760E, 4760P
Condition: New-In-Box
-
[Silver, White]
SKU: WES-DEEP UMBRELLA 24
Model: 5627, 5628
Condition: New-In-Box
-
SKU: WES-02338
Model: 2338
Condition: New-In-Box
-
SKU: WES-02471
Model: 2471
Condition: New-In-Box
-
SKU: WES-02472
Model: 2472
Condition: New-In-Box
-
SKU: WES-02473
Model: 2473
Condition: New-In-Box