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 (624511, 622080, 603649, 603648, 597051, 584193, 584189, 572781, 572777, 572774, 565674, 545834, 370783, 370788, 377332, 377339, 377990, 377991, 381976, 397996, 328528, 329671, 341241, 341264, 341348, 341382, 341887, 342897, 351560, 356399)) 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,624511,622080,603649,603648,597051,584193,584189,572781,572777,572774,565674,545834,370783,370788,377332,377339,377990,377991,381976,397996,328528,329671,341241,341264,341348,341382,341887,342897,351560,356399)
-
Your Choice Of: Canon, Fujifilm, Nikon, Olympus/Panasonic, Sony
SKU: DOX-X3
Model: DOX2216, DOX2217, DOX2218, DOX2219, DOX2220
Condition: New-In-Box
-
Your Choice Of: Canon, Nikon, Sony, Fujifilm, Olympus/Panasonic
SKU: DOX-V1PRO
Model: DOX2221, DOX2222, DOX2223, DOX2224, DOX2225
Condition: New-In-Box
-
SKU: DOX-2226
Model: DOX2226
Condition: New-In-Box
-
SKU: DOX-2227
Model: DOX2227
Condition: New-In-Box
-
SKU: DOX-2193
Model: LUXCADET
Condition: New-In-Box
-
SKU: DOX-1811
Model: GMC-U6
Condition: New-In-Box
-
SKU: DOX-1871
Model: GM7S
Condition: New-In-Box
-
SKU: DOX-1556
Model: HC55
Condition: New-In-Box
-
SKU: DOX-1408
Model: BDR-S55
Condition: New-In-Box
-
SKU: DOX-1409
Model: BDR-W55
Condition: New-In-Box
-
SKU: DOX-1302
Model: BDR-W420
Condition: New-In-Box
-
SKU: DOX-1392
Model: DOX1392
Condition: New-In-Box
-
SKU: DOX-1288
Model: SN-04
Condition: New-In-Box
-
SKU: DOX-1287
Model: BD08
Condition: New-In-Box
-
SKU: DOX-1559
Model: 1559
Condition: New-In-Box
-
SKU: DOX-1558
Model: TL30-K2
Condition: New-In-Box
-
SKU: DOX-1436A
Model: SS-65
Condition: New-In-Box
-
SKU: DOX-1437A
Model: SS-85
Condition: New-In-Box
-
Sizes: 70cm, 90cm, 120cm
SKU: DOX-QR-P
Model: QR-P120, QR-P90, QR-P70
Condition: New-In-Box
-
SKU: DOX1610
Model: AR-R KIT
Condition: New-In-Box
-
SKU: DOX-1398
Model: DOX1398
Condition: New-In-Box
-
SKU: DOX-1444
Model: DOX1444
Condition: New-In-Box
-
SKU: DOX-TT350
Model: TT350C, TT350F, TT350N, TT350O, TT350S
Condition: New-In-Box
-
Your Choice Of: Standard Flash Shoe, Sony Multi Interface Shoe
SKU: DOX-TT600
Model: TT600, TT600S
Condition: New-In-Box
-
Your Choice Of: Canon, Fujifilm, Nikon, Olympus/Panasonic, Sony
SKU: DOX-V1 FLASH
Model: DOX1227, DOX1228, DOX1229, DOX1230, DOX1231
Condition: New-In-Box
-
Your Choice Of: Canon, Fuji, Nikon, Olympus, Sony
SKU: DOX-VING V860II
Model: V860IIF, V860IIC, V860IIN, V860IIO, V860IIS
Condition: New-In-Box
-
SKU: DOX-1346
Model: VC26
Condition: New-In-Box
-
SKU: DOX-1445
Model: WB300P
Condition: New-In-Box
-
SKU: DOX-1484
Model: ML60
Condition: New-In-Box
-
Your Choice Of: Canon, Nikon, Fuji, Sony, Olympus, Pentax
SKU: DOX-XPRO TTL
Model: XPRO-F, XPRO-C, XPRO-N, XPRO-O, XPRO-P, XPRO-S
Condition: New-In-Box