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 (622397, 575435, 2997, 2998, 3151, 1644, 180298, 180299, 180300, 180301, 180337, 180338, 180340, 180341, 180342, 180343, 180345, 180346, 180347, 180349, 180350, 434092, 434146, 12834, 13901, 13903, 7715, 7719, 7907, 7956)) 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,622397,575435,2997,2998,3151,1644,180298,180299,180300,180301,180337,180338,180340,180341,180342,180343,180345,180346,180347,180349,180350,434092,434146,12834,13901,13903,7715,7719,7907,7956)
-
Sizes: 58mm, 67mm, 77mm, 82mm
SKU: HOY-PRO ND 100000
Model: XPD-58ND100000, XPD-67ND100000, XPD-77ND100000, XPD-82ND100000
Condition: New-In-Box
-
SKU: HOY-09501
Model: XEVA-95PROTEC
Condition: New-In-Box
-
SKU: HOY-00213A
Model: A-58ND4X-GB
Condition: New-In-Box
-
SKU: HOY-00214A
Model: A-58ND8X-GB
Condition: New-In-Box
-
SKU: HOY-00305A
Model: A-62ND8X-GB
Condition: New-In-Box
-
SKU: HOY-00150A
Model: A-52ND8X-GB
Condition: New-In-Box
-
SKU: HOY-04305
Model: A-NXTPL43UV
Condition: New-In-Box
-
SKU: HOY-04306
Model: A-NXTPL43CRPL
Condition: New-In-Box
-
SKU: HOY-04609
Model: A-NXTPL46UV
Condition: New-In-Box
-
SKU: HOY-04610
Model: A-NXTPL46CRPL
Condition: New-In-Box
-
SKU: HOY-04915
Model: A-NXTPL49CRPL
Condition: New-In-Box
-
SKU: HOY-05215
Model: A-NXTPLUV
Condition: New-In-Box
-
SKU: HOY-05514
Model: A-NXTPL55UV
Condition: New-In-Box
-
SKU: HOY-05515
Model: A-NXTPL55CRPL
Condition: New-In-Box
-
SKU: HOY-05816
Model: A-NXTPL58UV
Condition: New-In-Box
-
SKU: HOY-05817
Model: A-NXTPL58CRPL
Condition: New-In-Box
-
SKU: HOY-06216
Model: A-NXTPL62CRPL
Condition: New-In-Box
-
SKU: HOY-06717
Model: A-NXTPLCRPL
Condition: New-In-Box
-
SKU: HOY-07217
Model: A-NXTPL72UV
Condition: New-In-Box
-
SKU: HOY-07716
Model: A-NXTPL77UV
Condition: New-In-Box
-
SKU: HOY-07717
Model: A-NXTPLCRPL
Condition: New-In-Box
-
Sizes: 49mm, 52mm, 55mm, 58mm, 62mm, 67mm, 72mm, 77mm, 82mm
SKU: HOY-ALPHA II CRPL
Model: C-ALPII49CRPL, C-ALPII52CRPL, C-ALPII55CRPL, C-ALPII58CRPL, C-ALPII62CRPL, C-ALPII67CRPL, C-ALPII72CRPL, C-ALPII77CRPL, C-ALPII82CRPL
Condition: New-In-Box
-
Sizes: 49mm, 52mm, 55mm, 58mm, 62mm, 67mm, 72mm, 77mm, 82mm
SKU: HOY-ALPHA II PROTECTOR
Model: C-ALPII49PROT, C-ALPII52PROT, C-ALPII55PROT, C-ALPII58PROT, C-ALPII62PROT, C-ALPII67PROT, C-ALPII72PROT, C-ALPII77PROT, C-ALPII82PROT
Condition: New-In-Box
-
SKU: HOY-00467T
Model: XD-77STAR4
Condition: New-In-Box
-
SKU: HOY-00088G
Model: A-49ND400
Condition: New-In-Box
-
SKU: HOY-00362E
Model: A-67ND400
Condition: New-In-Box
-
SKU: HOY-00214G
Model: XD58ND16
Condition: New-In-Box
-
SKU: HOY-00467G
Model: XD77ND16
Condition: New-In-Box
-
SKU: HOY-00109
Model: G-52UV
Condition: New-In-Box
-
SKU: HOY-00298G
Model: S-62FOGAB-GB
Condition: New-In-Box