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, 602109, 596891, 596890, 596889, 596888, 596887, 596886, 596885, 588422, 588403, 573365, 565661, 564557, 564556, 564555, 564554, 564549, 555234, 549001, 546142, 546110, 540996, 540994, 540990, 540989, 540988)) 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,602109,596891,596890,596889,596888,596887,596886,596885,588422,588403,573365,565661,564557,564556,564555,564554,564549,555234,549001,546142,546110,540996,540994,540990,540989,540988)
-
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-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-04662
Model: 4662
Condition: New-In-Box
-
SKU: WES-04664
Model: 4664
Condition: New-In-Box
-
SKU: WES-04660
Model: 4660
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-4739
Model: 4739
Condition: New-In-Box
-
SKU: WES-9908HD
Model: 9908HD
Condition: New-In-Box
-
SKU: WES-0816
Model: 816
Condition: New-In-Box
-
SKU: WES-0815K
Model: 815K
Condition: New-In-Box
-
SKU: WES-2840
Model: 2840
Condition: New-In-Box