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, 180298, 180299, 180300, 180301, 180337, 180338, 180340, 180341, 180342, 180343, 180344, 180345, 180346, 180347, 180349, 180350, 2929, 2997, 2998, 3151, 3268, 1644, 1663, 434092, 434146, 180302, 180339, 180348)) 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,180298,180299,180300,180301,180337,180338,180340,180341,180342,180343,180344,180345,180346,180347,180349,180350,2929,2997,2998,3151,3268,1644,1663,434092,434146,180302,180339,180348)
-
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-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-06215
Model: A-NXTPL62UV
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
-
SKU: HOY-00147A
Model: A-52ND2X-GB
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-00466A
Model: A-77ND4X-GB
Condition: New-In-Box
-
SKU: HOY-00150A
Model: A-52ND8X-GB
Condition: New-In-Box
-
SKU: HOY-00199A
Model: A-55ND2X-GB
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-04914
Model: A-NXTPLUV
Condition: New-In-Box
-
SKU: HOY-05216
Model: A-NXTPL52CRPL
Condition: New-In-Box
-
SKU: HOY-07218
Model: A-NXTPL72CRPL
Condition: New-In-Box