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 (624442, 583759, 574555, 571018, 567973, 547117, 163397, 122565, 6499, 6500, 377729, 468045, 481353, 482708, 338622, 350353, 351532, 357021, 357035, 410001, 410008, 267564, 267565, 314131, 226685, 490072, 492814, 494297, 62500, 17777)) 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,624442,583759,574555,571018,567973,547117,163397,122565,6499,6500,377729,468045,481353,482708,338622,350353,351532,357021,357035,410001,410008,267564,267565,314131,226685,490072,492814,494297,62500,17777)
-
SKU: PRE-TAN-00218
Model: AFA063Z700
Condition: Preorder
Mount Type: Nikon Z
-
SKU: TAN-00479
Model: AFA057Z-700
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: TAN-00102
Model: A068
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00389
Model: AFA065S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-03050Z
Model: AFA058Z-700
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: TAN-00033
Model: AFB060X-700
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: TAN-00905
Model: A034TM
Condition: New-In-Box
-
SKU: TAN-00844P
Model: HB016
Condition: New-In-Box
-
SKU: TAN-00807
Model: flc82
Condition: New-In-Box
-
SKU: TAN-00808
Model: FLC86
Condition: New-In-Box
-
SKU: TAN-00032
Model: AFB060S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00111
Model: AFB070X-700
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: TAN-00297
Model: A067
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-03051
Model: A047
Condition: New-In-Box
Mount Type: Nikon Z
-
SKU: TAN-00432
Model: AFA047S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00110
Model: AFB070S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-18-400 3.5-6.3 DI II
Model: AFB028C-700, AFB028N-700
Condition: New-In-Box
Mount Types: Canon EOS (EF-S), Nikon F (DX)
-
SKU: 100706
Model: AFA025C-700, AFA025N-700
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: 77049
Model: AFA022C-700, AFA022N-700
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: TAN-03050
Model: AFA058S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00214
Model: AFA063S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00051S
Model: AFF051S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00053S
Model: AFF053S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00294
Model: AFA071S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00079S
Model: AFA046S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00714
Model: A062
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-18-300MM F/3.5-6.3
Model: AFB061S-700, AFB061X-700
Condition: New-In-Box
Available For: Sony E, Fujifilm X
-
SKU: TAN-AF150-500 F/5-6.7
Model: AFA057S700, AFA057F700
Condition: New-In-Box
Mount Types: Fujifilm X-Mount, Sony E
-
SKU: TAN-00128C
Model: AFB018C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: TAN-00131
Model: AFB011EM-700
Condition: New-In-Box
Mount Type: Canon EOS (M)