31 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_6097842b16cca9_71444348` 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. Overdrive Excel Tyre

    Maxxis Overdrive Excel Tyre

  2. New
    Randonneur Tech Tyres

    Vittoria Randonneur Tech Tyres

  3. Grifter Urban Tyre

    Maxxis Grifter Urban Tyre

  4. Best Seller
    E-Randonneur Tyres

    Vittoria E-Randonneur Tyres

  5. DTH Urban Tyre

    Maxxis DTH Urban Tyre

  6. New
    Revolution Tech Tyres

    Vittoria Revolution Tech Tyres

  7. Overdrive Maxx Tyre

    Maxxis Overdrive Maxx Tyre

  8. New
    Urbano Tyres

    Vittoria Urbano Tyres

  9. Adventure Tech Tyres

    Vittoria Adventure Tech Tyres

  10. Best Seller
    Mileater tyre with puncture breaker and reflective, black

    Nutrak Mileater tyre with puncture breaker and reflective, black

  11. New
    Zaffiro Pro V Tyres

    Vittoria Zaffiro Pro V Tyres

  12. Best Seller
    Commuter tyre

    Nutrak Commuter tyre

  13. MTB Slick tyre skinwall black

    Nutrak MTB Slick tyre skinwall black

    From £20.99
  14. New
    Evolution II Tyres

    Vittoria Evolution II Tyres

    Out of stock
  15. New
    Roadster Tyres

    Vittoria Roadster Tyres

  16. Best Seller
    Traditional tyre

    Nutrak Traditional tyre

    From £18.99
  17. New
    Terreno Zero Tyres

    Vittoria Terreno Zero Tyres

    From £17.99
  18. New
    Randonneur Tyres

    Vittoria Randonneur Tyres

    From £16.99
  19. Best Seller
    Street Tyre Black for Strollers

    Nutrak Street Tyre Black for Strollers

    From £14.99
  20. New
    Zaffiro V Tyres

    Vittoria Zaffiro V Tyres

  21. New
    Zaffiro IV Tyres

    Vittoria Zaffiro IV Tyres