36 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_609a3453c14d61_12265986` 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 '1617663541') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 30
  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

    £69.99
    Out of stock
  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. High Road Tubeless Tyre

    Maxxis High Road Tubeless Tyre

    From £54.99
     
  10. Best Seller
    Corsa Tyres

    Vittoria Corsa Tyres

    From £59.99
     
  11. High Road SL Tyre

    Maxxis High Road SL Tyre

  12. Rubino Pro IV Speed Tyres

    Vittoria Rubino Pro IV Speed Tyres

  13. Sale
    Campione TT-Tubular Tyre

    Maxxis Campione TT-Tubular Tyre

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

    Maxxis Relix Tubular Tyre

    Was £79.99 From £43.99 (Save 45%)
     
  15. Rubino Pro IV Endurance Tyres

    Vittoria Rubino Pro IV Endurance Tyres

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

    Vittoria Rubino Pro IV Control Tyres

    £39.99
    Out of stock
  17. Re-Fuse Tyre

    Maxxis Re-Fuse Tyre

    From £39.99
     
  18. New
    Rubino Pro IV Tyres

    Vittoria Rubino Pro IV Tyres

    From £39.99
     
  19. Best Seller
    Zaffiro Pro Home Trainer Tyres

    Vittoria Zaffiro Pro Home Trainer Tyres

  20. Juniores Tubular

    Vittoria Juniores Tubular

    £26.99
    Out of stock
  21. Rally Tubular

    Vittoria Rally Tubular

  22. Sale
    Padrone Tubeless Tyre

    Maxxis Padrone Tubeless Tyre

    Was £49.99 From £24.99 (Save 50%)
     
  23. New
    Zaffiro Pro V Tyres

    Vittoria Zaffiro Pro V Tyres

  24. Rubino IV Tyres

    Vittoria Rubino IV Tyres

    £21.99
    Out of stock
Page