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 (631287, 574555, 547117, 377729, 468045, 481353, 338622, 357021, 490072, 494297, 226685, 6476, 6477, 6479, 6931, 12679, 12680, 4690, 375177, 383893, 62500, 17777, 17778, 18447, 18448, 18468, 19305, 17184, 14978, 14979)) 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,631287,574555,547117,377729,468045,481353,338622,357021,490072,494297,226685,6476,6477,6479,6931,12679,12680,4690,375177,383893,62500,17777,17778,18447,18448,18468,19305,17184,14978,14979)
-
SKU: TAN-00034
Model: B060
Condition: New-In-Box
Mount Type: Canon EOS (RF)
-
SKU: TAN-00102
Model: A068
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00033
Model: AFB060X-700
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
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-00432
Model: AFA047S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: 100706
Model: AFA025C-700, AFA025N-700
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: TAN-00714
Model: A062
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-AF150-500 F/5-6.7
Model: AFA057S700, AFA057F700
Condition: New-In-Box
Mount Types: Fujifilm X-Mount, Sony E
-
SKU: TAN-00079S
Model: AFA046S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00370
Model: AFG005C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF-S)
-
SKU: TAN-00372
Model: AFG005S-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00423
Model: AF017M-700
Condition: New-In-Box
-
SKU: TAN-00093
Model: AF016M-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00129
Model: AFB011700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00130
Model: AFB011S-700
Condition: New-In-Box
Mount Type: Sony E
-
SKU: TAN-00371
Model: AFG005N-700
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: 16319
Model: AFB005NII-700, AFB005C-700
Condition: New-In-Box
Mount Types: Canon EOS (EF-S), Nikon F (DX)
-
SKU: TAN-SP 24-70 2.8 DI G2
Model: AFA032C-700, AFA032N-700
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
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)
-
SKU: TAN-00132
Model: AFB011EMS-700
Condition: New-In-Box
Mount Type: Canon EOS (M)
-
SKU: TAN-00068C
Model: AFA012C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: TAN-00068N
Model: AFA012N-700
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: TAN-00068S
Model: AFA012S-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00397
Model: TAMR AFA009S-700
Condition: New-In-Box
-
SKU: TAN-00074
Model: AFB016S-700
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: TAN-00395
Model: A009C-700
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: TAN-00396
Model: A009N-700
Condition: New-In-Box
Mount Type: Nikon F (FX)