103 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=18631 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_6082d524749b40_38161097` 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. Raze Tyre

    Maxxis Raze Tyre

    From £42.99
     
  2. Minion DHF 3C Maxx Terra DD TR Tyre

    Maxxis Minion DHF 3C Maxx Terra DD TR Tyre

    From £79.99
     
  3. Minion DHR II 3C DD TR Tyre

    Maxxis Minion DHR II 3C DD TR Tyre

    From £74.99
     
  4. Minion DHF 3C Maxx Terra EXO+ TR Tyre

    Maxxis Minion DHF 3C Maxx Terra EXO+ TR Tyre

  5. Assegai DH Tyre

    Maxxis Assegai DH Tyre

  6. Shorty Gen 2 Tyre

    Maxxis Shorty Gen 2 Tyre

    From £64.99
     
  7. Dissector DH Tyre

    Maxxis Dissector DH Tyre

  8. Minion DHR II DH 3C Maxx Grip Tyre

    Maxxis Minion DHR II DH 3C Maxx Grip Tyre

  9. Ardent Race 3C Maxx Speed EXO Folding Tyre

    Maxxis Ardent Race 3C Maxx Speed EXO Folding Tyre

  10. Minion DHF DH 3C Maxx Grip Tyre

    Maxxis Minion DHF DH 3C Maxx Grip Tyre

    From £69.99
     
  11. Forekaster Tyre

    Maxxis Forekaster Tyre

    From £58.99
     
  12. Minion DHR Plus II 3C Maxx Terra EXO TR Tyre

    Maxxis Minion DHR Plus II 3C Maxx Terra EXO TR Tyre

    Was £64.99 From £64.99
     
  13. Rekon 3C Folding Tyre

    Maxxis Rekon 3C Folding Tyre

    From £64.99
     
  14. Minion DHF Plus 3C Maxx Terra EXO TR Tyre

    Maxxis Minion DHF Plus 3C Maxx Terra EXO TR Tyre

    From £64.99
     
  15. Sale
    Assegai Trail Tyre

    Maxxis Assegai Trail Tyre

    Was £49.99 From £49.99
     
  16. Sale
    Campione Tubular Tyre

    Maxxis Campione Tubular Tyre

    Was £129.99 From £61.99 (Save 52%)
     
  17. Best Seller
    Minion DHR II 3C Maxx Terra EXO+ TR Tyre

    Maxxis Minion DHR II 3C Maxx Terra EXO+ TR Tyre

    From £61.99
     
  18. Minion DHR Plus II Dual Compound EXO TR Tyre

    Maxxis Minion DHR Plus II Dual Compound EXO TR Tyre

    £59.99
    Out of stock
  19. Minion DHR II DH Single Compound Tyre

    Maxxis Minion DHR II DH Single Compound Tyre

  20. Minion FBF Dual Compound Tyre

    Maxxis Minion FBF Dual Compound Tyre

    From £59.99
     
  21. Minion DHF DH Super Tacky Tyre

    Maxxis Minion DHF DH Super Tacky Tyre

  22. Shorty DH Tyre

    Maxxis Shorty DH Tyre

    From £59.99
     
  23. Best Seller
    Minion DHF WT 3C Maxx Grip TR Tyre

    Maxxis Minion DHF WT 3C Maxx Grip TR Tyre

    From £59.99
     
  24. Ikon+ Plus Tyre

    Maxxis Ikon+ Plus Tyre

    Was £69.99 From £69.99
    Out of stock
  25. Minion DHF DH Single Compound Tyre

    Maxxis Minion DHF DH Single Compound Tyre

  26. High Roller II DH Tyre

    Maxxis High Roller II DH Tyre

    Was £59.99 From £59.99
     
  27. Minion DHF 3C Maxx Terra EXO Tyre

    Maxxis Minion DHF 3C Maxx Terra EXO Tyre

    From £59.99
     
  28. High Road Tubeless Tyre

    Maxxis High Road Tubeless Tyre

    From £54.99
     
  29. Shorty Tyre

    Maxxis Shorty Tyre

    Was £59.99 From £59.99
     
Page