Find the right look with our range of cycling tops for road or MTB, for men, women, and kids, short or long sleeved. You’ll find the perfect women’s cycling tops and men’s cycling tops in our great selection of jerseys for all weathers and any conditions here.
Find the right look with our range of cycling tops for road or MTB, for men, women, and kids, short or long sleeved. You’ll find the perfect women’s cycling tops and men’s cycling tops in our great selection of jerseys for all weathers and any conditions here.
193 items found
per page
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`.`stock_status` AS `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.website_id = '1' AND price_index.customer_group_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'))
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE ((e.entity_id IN (480707, 474894, 483242, 471062, 478417, 471059, 480557, 483236, 458034, 458595, 445740, 478420, 469822, 478423, 469819, 471368, 477486, 485648, 480632, 458286, 477471, 501724, 479270, 480683, 480626, 480629, 480686, 480644, 464721, 471365))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,480707,474894,483242,471062,478417,471059,480557,483236,458034,458595,445740,478420,469822,478423,469819,471368,477486,485648,480632,458286,477471,501724,479270,480683,480626,480629,480686,480644,464721,471365)
