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 (592501, 582639, 582613, 582598, 576496, 245269, 245272, 245310, 245311, 245312, 245314, 245353, 245354, 245356, 211014, 139872, 13263, 456389, 456390, 478085, 503183, 503191, 527760, 538888, 377720, 377721, 245268, 245270, 245271, 245355)) 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,592501,582639,582613,582598,576496,245269,245272,245310,245311,245312,245314,245353,245354,245356,211014,139872,13263,456389,456390,478085,503183,503191,527760,538888,377720,377721,245268,245270,245271,245355)
-
SKU: SIR-10093
Model: L10
Condition: New-In-Box
-
SKU: SIR-00007
Model: MA-GK
Condition: New-In-Box
-
SKU: SIR-00006
Model: MA-SC
Condition: New-In-Box
-
SKU: SIR-00053
Model: GT04+GT5
Condition: New-In-Box
-
SKU: SIR-10048
Model: PH10
Condition: New-In-Box
-
SKU: SIR-20022
Model: HA77
Condition: New-In-Box
-
SKU: SIR-20120
Model: VK3K
Condition: New-In-Box
-
SKU: SIR-00046A
Model: A1205Y
Condition: New-In-Box
-
SKU: SIR-00124
Model: W1004
Condition: New-In-Box
-
SKU: SIR-00126
Model: W2004
Condition: New-In-Box
-
SKU: SIR-20500
Model: BL01
Condition: New-In-Box
-
SKU: SIR-00500
Model: SH15
Condition: New-In-Box
-
SKU: SIR-00510
Model: SH25
Condition: New-In-Box
-
SKU: SIR-10084
Model: VS60
Condition: New-In-Box
-
SKU: SIR-00114
Model: W2204
Condition: New-In-Box
-
SKU: SIR-00046
Model: SUA1005Y
Condition: New-In-Box
-
SKU: SIR-00050
Model: BSR P326
Condition: New-In-Box
-
SKU: SIR-00490
Model: SH05
Condition: New-In-Box
-
SKU: SIR-00530
Model: DT06
Condition: New-In-Box
-
SKU: SIR-00513
Model: VPSH15
Condition: New-In-Box
-
SKU: SIR-AR3204
Model: AR-3204
Condition: New-In-Box
-
SKU: SIR-VA5ST224
Model: ST224+VA5
Condition: New-In-Box
-
SKU: SIR-20131
Model: P424FL
Condition: New-In-Box
-
SKU: SIR-00005
Model: MS18
Condition: New-In-Box
-
SKU: SIR-35ADPE
Model: 35ADP-E
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIR-SR35M
Model: SR35-M
Condition: New-In-Box
Mount Types: Canon EOS (EF), Micro Four-Thirds, Nikon Z, Sony E
-
SKU: SIR-20020
Model: VA5
Condition: New-In-Box
-
SKU: SIR-20100
Model: TSH01KX
Condition: New-In-Box
-
SKU: SIR-20102
Model: TSH01KX-1
Condition: New-In-Box
-
SKU: SIR-00520
Model: VHD2204VH10
Condition: New-In-Box