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 (470684, 337218, 337219, 341532, 341554, 341559, 341590, 341594, 341595, 341601, 341602, 368111, 404533, 406868, 406872, 406873, 406874, 406876, 411652, 411656, 415338, 415683, 415685, 415690, 415768, 415772, 415777, 415795, 415797, 419851)) 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,470684,337218,337219,341532,341554,341559,341590,341594,341595,341601,341602,368111,404533,406868,406872,406873,406874,406876,411652,411656,415338,415683,415685,415690,415768,415772,415777,415795,415797,419851)
-
SKU: NIK-71080
Model: 20112
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70952
Model: 20097
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71022
Model: 20095
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70004
Model: 1659
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70006
Model: 1653
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70007
Model: 1656
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-215591
Model: 27215
Condition: New-In-Box
-
SKU: NIK-233691B
Model: 4239
Condition: New-In-Box
-
SKU: NIK-233691A
Model: 4238
Condition: New-In-Box
-
SKU: NIK-233692A
Model: 4255
Condition: New-In-Box
-
SKU: NIK-233692B
Model: 4256
Condition: New-In-Box
-
SKU: NIK-12870X
Model: 4233
Condition: New-In-Box
-
SKU: NIK-71012
Model: 20102
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-16764
Model: 16764
Condition: New-In-Box
-
SKU: NIK-16766
Model: 16766
Condition: New-In-Box
-
SKU: NIK-16765
Model: 16765
Condition: New-In-Box
-
SKU: NIK-16767
Model: 16767
Condition: New-In-Box
-
SKU: NIK-16768
Model: 16768
Condition: New-In-Box
-
SKU: NIK-70961
Model: 20104
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-12941
Model: 4258
Condition: New-In-Box
-
SKU: NIK-70008
Model: 1669
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71007
Model: 20106
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-73005
Model: 4264
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-71004
Model: 20105
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-21698
Model: 27218
Condition: New-In-Box
-
SKU: NIK-20976
Model: 27219
Condition: New-In-Box
-
SKU: NIK-20817
Model: 27220
Condition: New-In-Box
-
SKU: NIK-12870ZH
Model: 4260
Condition: New-In-Box
-
SKU: NIK-20239
Model: 27223
Condition: New-In-Box
-
SKU: NIK-71088
Model: 20101
Condition: New-In-Box
Mount Type: Nikon Z