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 (592566, 580330, 580327, 580326, 470668, 470669, 470670, 325016, 325017, 325018, 341537, 341554, 341559, 265876, 265881, 282804, 110786, 110787, 130692, 390101, 390102, 390103, 341532, 265875, 282801, 282802, 289885, 308910, 186854)) 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,592566,580330,580327,580326,470668,470669,470670,325016,325017,325018,341537,341554,341559,265876,265881,282804,110786,110787,130692,390101,390102,390103,341532,265875,282801,282802,289885,308910,186854)
-
SKU: NIK-13602
Model: 13602
Condition: New-In-Box
-
SKU: NIK-70022
Model: 1772
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70021
Model: 1763
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70020
Model: 1761
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-01737
Model: 1737
Condition: New-In-Box
-
SKU: NIK-01749
Model: 1749
Condition: New-In-Box
-
SKU: NIK-01743
Model: 1743
Condition: New-In-Box
-
SKU: NIK-69990
Model: 1649
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-69992
Model: 1641
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-69994
Model: 1642
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70005
Model: 1663
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-70102
Model: 1633
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70104
Model: 1632
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-11081VN50
Model: 26532
Condition: New-In-Box
-
SKU: NIK-10259
Model: 1581
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-10260
Model: 1582
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: NIK-10196
Model: 1585
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-70109
Model: 1673
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70108
Model: 1671
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70110
Model: 1675
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70004
Model: 1659
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-70100
Model: 1634
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-101841
Model: 1618
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-10185
Model: 1619
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-10139
Model: 1624
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: NIK-70106
Model: 13552
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: NIK-11081VP
Model: 26522
Condition: New-In-Box