32 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 (430475, 420937, 420938, 420940, 420929, 420928, 420924, 420939, 420930, 420920, 477132, 452049, 420926, 476121, 467623, 467611, 465262, 429864, 476115, 476118, 420927, 467620, 452043, 420942, 420931, 429865, 420963, 452046, 467617, 452037))) AND (e.created_in '1626130800') ORDER BY FIELD(e.entity_id,430475,420937,420938,420940,420929,420928,420924,420939,420930,420920,477132,452049,420926,476121,467623,467611,465262,429864,476115,476118,420927,467620,452043,420942,420931,429865,420963,452046,467617,452037)
  1. Gravel Comfort Tape

    PRO Gravel Comfort Tape

  2. Race Comfort Tape

    PRO Race Comfort Tape

    From £26.99
     
  3. Sport Dual Lock Grips

    PRO Sport Dual Lock Grips

    £21.99
    Out of stock
  4. Race Lock On Grips

    PRO Race Lock On Grips

    £21.99
    Out of stock
  5. Sport Control Team Tape

    PRO Sport Control Team Tape

  6. Race Control Tape

    PRO Race Control Tape

    From £19.99
     
  7. Sport Lock On Grips

    PRO Sport Lock On Grips

    £18.99
    Out of stock
  8. Sport Comfort Tape

    PRO Sport Comfort Tape

  9. Best Seller
    Sport Control Tape

    PRO Sport Control Tape

  10. Classic Comfort Tape

    PRO Classic Comfort Tape

  11. Sport Slide On Grips

    PRO Sport Slide On Grips

  12. Handlebar End Plugs

    PRO Handlebar End Plugs

    £9.99
    Out of stock
Page