41 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=18635 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_60409c9b480d79_26732798` 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 30
  1. Sale

    Continental TOP CONTACT Tyre

    Was £59.95 From £44.75 (Save 25%)
  2. CONTACT Plus Reflex Tyre

    Continental CONTACT Plus Reflex Tyre

    Was £39.95 From £39.95
    Out of stock
  3. Overdrive Excel Tyre

    Maxxis Overdrive Excel Tyre

  4. Sale
    E Contact Tyre

    Continental E Contact Tyre

    £34.95 £29.99 (Save 14%)
    Out of stock
  5. Best Seller
    E-Randonneur Tyres

    Vittoria E-Randonneur Tyres

  6. New
    Revolution Tech Tyres

    Vittoria Revolution Tech Tyres

  7. Overdrive Maxx Tyre

    Maxxis Overdrive Maxx Tyre

  8. Grifter Urban Tyre

    Maxxis Grifter Urban Tyre

  9. New
    Randonneur Tech Tyres

    Vittoria Randonneur Tech Tyres

  10. Adventure Tech Tyres

    Vittoria Adventure Tech Tyres

  11. New
    Urbano Tyres

    Vittoria Urbano Tyres

  12. Mileater tyre with puncture breaker and reflective, black

    Nutrak Mileater tyre with puncture breaker and reflective, black

  13. New
    Zaffiro Pro V Tyres

    Vittoria Zaffiro Pro V Tyres

  14. DTH Urban Tyre

    Maxxis DTH Urban Tyre

    Out of stock
  15. Traffic Tyre

    Continental Traffic Tyre

    Out of stock
  16. Best Seller
    Commuter tyre

    Nutrak Commuter tyre

  17. Road tyre

    Nutrak Road tyre

  18. New
    Roadster Tyres

    Vittoria Roadster Tyres

  19. New
    Evolution II Tyres

    Vittoria Evolution II Tyres

  20. Town and Country tyre

    Continental Town and Country tyre

    Out of stock
  21. Sale
    Retro Ride tyre

    Continental Retro Ride tyre

    Was £19.95 From £15.99 (Save 20%)
    Out of stock
  22. Best Seller
    Traditional tyre

    Nutrak Traditional tyre

    From £18.99
  23. MTB Slick tyre skinwall black

    Nutrak MTB Slick tyre skinwall black

    From £18.99