17 Items

per page
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF(at_price_desc.value_id > 0, at_price_desc.value, at_price_desc_default.value) AS `price_desc` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=19913 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')) INNER JOIN `search_tmp_603b192873be33_53275996` AS `search_result` ON e.entity_id = search_result.entity_id 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 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc_default` ON (`at_price_desc_default`.`row_id` = `e`.`row_id`) AND (`at_price_desc_default`.`attribute_id` = '887') AND `at_price_desc_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc` ON (`at_price_desc`.`row_id` = `e`.`row_id`) AND (`at_price_desc`.`attribute_id` = '887') AND (`at_price_desc`.`store_id` = 1) WHERE (e.created_in '1614297600') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 36
  1. Tharsis XC Stem, Alloy, -17deg

    PRO Tharsis XC Stem, Alloy, -17deg

    £104.99
     
  2. Sale
    Women's Turnix Saddle

    PRO Women's Turnix Saddle

    £149.99 £79.99 (Save 47%)
     
  3. Sale
    Turnix Carbon Rail Saddle, Regular Fit

    PRO Turnix Carbon Rail Saddle, Regular Fit

    £149.99 £65.62 (Save 56%)
     
  4. Sale
    Tharsis XC stem, 3d forged aluminium, 1-1/8

    PRO Tharsis XC stem, 3d forged aluminium, 1-1/8

    £99.99 £59.99 (Save 40%)
     
  5. Sale
    Falcon Women's Saddle

    PRO Falcon Women's Saddle

    Was £99.99 From £49.99 (Save 50%)
     
  6. Sale
    Tharsis Trail Stem, Alloy

    PRO Tharsis Trail Stem, Alloy

    £104.99 £45.93 (Save 56%)
     
  7. Sale
    Turnix Hollow Rail Saddle, Regular Fit

    PRO Turnix Hollow Rail Saddle, Regular Fit

    £99.99 £43.75 (Save 56%)
     
  8. Sale
    Griffon Hollow Rail Saddle, Regular Fit

    PRO Griffon Hollow Rail Saddle, Regular Fit

    £99.99 £43.75 (Save 56%)
     
  9. Sale
    Falcon Hollow Rail Saddle, Regular Fit

    PRO Falcon Hollow Rail Saddle, Regular Fit

    £99.99 £43.75 (Save 56%)
     
  10. Sale
    H-Type Handlebar, Alloy

    PRO H-Type Handlebar, Alloy

    £39.99 £19.99 (Save 50%)
     
  11. Performance Seatpost Clamp

    PRO Performance Seatpost Clamp

  12. Best Seller
    Sport Control Tape

    PRO Sport Control Tape

  13. Classic Comfort Tape

    PRO Classic Comfort Tape

  14. Sale
    Race Slide On Grips

    PRO Race Slide On Grips

    Was £19.99 From £9.99 (Save 50%)