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 (494820, 494917, 502249, 513227, 59413, 59414, 68293, 18465, 21382, 25469, 25481, 79489, 79490, 79491, 79492, 85478, 104636, 104637, 104638, 108287, 108309, 118420, 156099, 191972, 15979, 16230, 16231, 16232, 16934, 16935)) 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,494820,494917,502249,513227,59413,59414,68293,18465,21382,25469,25481,79489,79490,79491,79492,85478,104636,104637,104638,108287,108309,118420,156099,191972,15979,16230,16231,16232,16934,16935)
-
SKU: SIG-24MM F/1.4 DGDN A
Model: 405969, 405965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-24MM F2 DGDN C
Model: 403969, 403965
Condition: New-In-Box
Mount Types: L Mount, Sony E
-
SKU: SIG-00096
Model: 585975
Condition: New-In-Box
Mount Type: Fujifilm X-Mount
-
SKU: SIG-00269S
Model: 732965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-00374CKC
Model: ZB954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00374NKC
Model: ZB955
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-00801
Model: AM5900
Condition: New-In-Box
-
SKU: SIG-00444C
Model: 870101
Condition: New-In-Box
-
SKU: SIG-02700
Model: AL1900
Condition: New-In-Box
-
SKU: SIG-0000014
Model: C83900
Condition: New-In-Box
-
SKU: SIG-01181
Model: AFJ9C0
Condition: New-In-Box
-
SKU: SIG-00318C
Model: 321954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00318N
Model: 321954
Condition: New-In-Box
Mount Types: Canon EOS (EF), Nikon F (FX)
-
SKU: SIG-00395C
Model: 185954
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00395N
Model: 185954
Condition: New-In-Box
Mount Type: Nikon F (FX)
-
SKU: SIG-01090
Model: LH1220-01
Condition: New-In-Box
-
SKU: SIG-00136CONTC
Model: 885101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00136CONTN
Model: 885306
Condition: New-In-Box
Mount Type: Nikon F (DX)
-
SKU: SIG-00136CONTS
Model: 885205
Condition: New-In-Box
Mount Type: Sony/Minolta A
-
SKU: SIG-00085
Model: 210966
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00241
Model: 693966
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-01116
Model: AFE9BO
Condition: New-In-Box
-
SKU: SIG-01037B
Model: LH730-02
Condition: New-In-Box
-
SKU: SIG-01055
Model: LH876-04
Condition: New-In-Box
-
SKU: SIG-00268N
Model: 350965
Condition: New-In-Box
Mount Type: Sony E
-
SKU: SIG-01037
Model: LH715-01
Condition: New-In-Box
-
SKU: SIG-00996
Model: FC-72
Condition: New-In-Box
-
SKU: SIG-00950
Model: CA483-72
Condition: New-In-Box
-
SKU: SIG-00171A
Model: 635101
Condition: New-In-Box
Mount Type: Canon EOS (EF)
-
SKU: SIG-00172
Model: 635306
Condition: New-In-Box
Mount Type: Canon EOS (EF)
