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 (627592, 624590, 622391, 614067, 614054, 613876, 612610, 612580, 595090, 594978, 592877, 587426, 578894, 577940, 577937, 577935, 577932, 577930, 572005, 562435, 558714, 557747, 557741, 549647, 549644, 549626, 549613, 548288, 8894, 46953)) 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,627592,624590,622391,614067,614054,613876,612610,612580,595090,594978,592877,587426,578894,577940,577937,577935,577932,577930,572005,562435,558714,557747,557741,549647,549644,549626,549613,548288,8894,46953)
-
SKU: SIG-10-18 2.8 DC DN
Model: 207975, 207965, 207969
Condition: New-In-Box
Mount Types: Fujifilm X-Mount, L Mount, Sony E
-
[Black, Brown]
SKU: FUJ-INSTAX MINI EVO CASE
Model: 600022440, 600023339
Condition: New-In-Box
-
SKU: FUJ-10029
Model: 16823507
Condition: New-In-Box
-
[Black, Silver]
SKU: FUJ-LENS HOOD ADAP X10
Model: 16421309, 16144523
Condition: New-In-Box
-
[Black, Silver]
SKU: FUJ-TCL-X100 II
Model: 16534742, 16534730
Condition: New-In-Box
-
SKU: FUJ-32270
Model: 16652609
Condition: New-In-Box
-
SKU: FUJ-31159
Model: 16821822
Condition: New-In-Box
-
SKU: FUJ-31158
Model: 16821913
Condition: New-In-Box
-
Your Choice Of: 35mm, 120
SKU: FUJ-NEOPAN 100
Model: 16648282, 16648294
Condition: New-In-Box
-
Your Choice Of: 35mm, 120
SKU: FUJ-VELVIA 50
Model: 16329161, 16329185, 16329185-1
Condition: New-In-Box
-
Your Choice Of: 35mm, 120
SKU: KOD-TRI-X 400
Model: 1590652, 1153659, 1153659-1
Condition: New-In-Box
-
[White, Blue, Pink]
SKU: FUJ-MINI LINK 2
Model: 16767155, 16767246, 16767208
Condition: New-In-Box
-
SKU: FUJ-10003
Model: 600016111
Condition: New-In-Box
-
SKU: FUJ-31457
Model: 600023620
Condition: New-In-Box
Mount Type: Fujifilm GFX
-
SKU: FUJ-31454G
Model: 600023613
Condition: New-In-Box
Mount Type: Fujifilm GFX
-
SKU: PRE-FUJ-31449G
Model: 600023617
Condition: Preorder
Mount Type: Fujifilm GFX
-
SKU: FUJ-28060
Model: 16805490
Condition: New-In-Box
-
SKU: FUJ-28014
Model: 600023590
Condition: New-In-Box
Mount Type: Fujifilm GFX
-
SKU: FUJ-12055
Model: 16326028
Condition: New-In-Box
-
[Midnight Green, White]
SKU: FUJ-INSTAX SQUARE LINK
Model: 16785547, 16785559
Condition: New-In-Box
-
SKU: FUJ-11002C
Model: 16576532
Condition: New-In-Box
-
SKU: FUJ-12003
Model: 16802814
Condition: New-In-Box
-
SKU: FUJ-12001B
Model: 16812534
Condition: New-In-Box
-
SKU: FUJ-31246
Model: 16782038
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: FUJ-31244
Model: 16781852
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: FUJ-31301A
Model: 16797760
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: FUJ-31245
Model: 16781943
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
[Blossom Pink, Pastel Blue, Mint Green, Clay White, Lilac Purple]
SKU: FUJ-INSTAX MINI 12
Model: 16806286, 16806274, 16806262, 16806248, 16806250
Condition: New-In-Box
-
SKU: FUJ-32210
Model: AR-X100
Condition: New-In-Box
-
SKU: FUJ-31392
Model: 6046
Condition: New-In-Box
Mount Type: Fujifilm X-Mount