47 items found

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=18639 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_603c94913f6ea8_65318508` 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. Corsa Speed Tubular

    Vittoria Corsa Speed Tubular

  2. New
    Pista Speed Tubular

    Vittoria Pista Speed Tubular

  3. Corsa Tubular

    Vittoria Corsa Tubular

  4. New
    Corsa Control Tubular

    Vittoria Corsa Control Tubular

  5. Rubino Pro Iv Tubular

    Vittoria Rubino Pro Iv Tubular

  6. Corsa Speed Tyres

    Vittoria Corsa Speed Tyres

  7. Sale
    Campione Tubular Tyre

    Maxxis Campione Tubular Tyre

    Was £129.99 From £61.99 (Save 52%)
     
  8. New
    Corsa Control Tyres

    Vittoria Corsa Control Tyres

    From £59.99
     
  9. Best Seller
    Corsa Tyres

    Vittoria Corsa Tyres

    From £59.99
     
  10. High Road Tubeless Tyre

    Maxxis High Road Tubeless Tyre

    From £54.99
     
  11. Grand Prix 4 Season Tyre

    Continental Grand Prix 4 Season Tyre

    £59.95
    Out of stock
  12. High Road SL Tyre

    Maxxis High Road SL Tyre

  13. Rubino Pro IV Speed Tyres

    Vittoria Rubino Pro IV Speed Tyres

  14. High Road Tyre

    Maxxis High Road Tyre

    From £44.99
     
  15. Sale
    Campione TT-Tubular Tyre

    Maxxis Campione TT-Tubular Tyre

    £99.99 £44.99 (Save 55%)
     
  16. Sale
    Relix Tubular Tyre

    Maxxis Relix Tubular Tyre

    Was £79.99 From £43.99 (Save 45%)
     
  17. Sale
    Grand Prix Attack and Force Tyre

    Continental Grand Prix Attack and Force Tyre

    Was £59.95 From £41.75 (Save 30%)
     
  18. Re-Fuse Tyre

    Maxxis Re-Fuse Tyre

    From £39.99
     
  19. New
    Rubino Pro IV Tyres

    Vittoria Rubino Pro IV Tyres

    From £39.99
     
  20. Rubino Pro IV Endurance Tyres

    Vittoria Rubino Pro IV Endurance Tyres

    £39.99
    Out of stock
  21. New
    Rubino Pro IV Control Tyres

    Vittoria Rubino Pro IV Control Tyres

    £39.99
    Out of stock
  22. Gator Hardshell DuraSkin Tyre

    Continental Gator Hardshell DuraSkin Tyre

    From £39.95
    Out of stock
  23. Dolomites Tyre

    Maxxis Dolomites Tyre

  24. Best Seller
    Zaffiro Pro Home Trainer Tyres

    Vittoria Zaffiro Pro Home Trainer Tyres

  25. New
    Rally Tubular

    Vittoria Rally Tubular

  26. Juniores Tubular

    Vittoria Juniores Tubular

    £26.99
    Out of stock
Page