77 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=18637 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_607bff8c35e351_41610041` 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. Minion DHF 3C Maxx Terra DD TR Tyre

    Maxxis Minion DHF 3C Maxx Terra DD TR Tyre

    From £79.99
     
  2. Minion DHF 3C Maxx Terra EXO+ TR Tyre

    Maxxis Minion DHF 3C Maxx Terra EXO+ TR Tyre

  3. Dissector DH Tyre

    Maxxis Dissector DH Tyre

  4. Best Seller
    Minion DHF WT 3C Maxx Grip TR Tyre

    Maxxis Minion DHF WT 3C Maxx Grip TR Tyre

    From £59.99
     
  5. Assegai DH Tyre

    Maxxis Assegai DH Tyre

  6. Minion DHR II 3C DD TR Tyre

    Maxxis Minion DHR II 3C DD TR Tyre

    From £74.99
     
  7. 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
     
  8. Minion DHR II DH 3C Maxx Grip Tyre

    Maxxis Minion DHR II DH 3C Maxx Grip Tyre

  9. Minion DHF DH 3C Maxx Grip Tyre

    Maxxis Minion DHF DH 3C Maxx Grip Tyre

    From £69.99
     
  10. Ardent Race 3C Maxx Speed EXO Folding Tyre

    Maxxis Ardent Race 3C Maxx Speed EXO Folding Tyre

  11. Rekon 3C Folding Tyre

    Maxxis Rekon 3C Folding Tyre

    From £64.99
     
  12. Shorty Gen 2 Tyre

    Maxxis Shorty Gen 2 Tyre

    From £64.99
    Out of stock
  13. Minion DHF Plus 3C Maxx Terra EXO TR Tyre

    Maxxis Minion DHF Plus 3C Maxx Terra EXO TR Tyre

    From £64.99
     
  14. Sale
    Assegai Trail Tyre

    Maxxis Assegai Trail Tyre

    Was £49.99 From £49.99
     
  15. Forekaster Tyre

    Maxxis Forekaster Tyre

    From £58.99
     
  16. Best Seller
    Minion DHR II 3C Maxx Terra EXO+ TR Tyre

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

    From £61.99
     
  17. New
    Martello Tyres

    Vittoria Martello Tyres

    £59.99
    Out of stock
  18. Shorty DH Tyre

    Maxxis Shorty DH Tyre

    From £59.99
     
  19. Minion FBF Dual Compound Tyre

    Maxxis Minion FBF Dual Compound Tyre

    From £59.99
     
  20. High Roller II DH Tyre

    Maxxis High Roller II DH Tyre

    Was £59.99 From £59.99
     
  21. Minion DHF DH Single Compound Tyre

    Maxxis Minion DHF DH Single Compound Tyre

  22. New
    Mota Tyres

    Vittoria Mota Tyres

  23. Minion DHF 3C Maxx Terra EXO Tyre

    Maxxis Minion DHF 3C Maxx Terra EXO Tyre

    From £59.99
     
  24. E-Mazza Tyres

    Vittoria E-Mazza Tyres

    £59.99
    Out of stock
  25. New
    E-Agarro Tyres

    Vittoria E-Agarro Tyres

    £59.99
    Out of stock
  26. Shorty Tyre

    Maxxis Shorty Tyre

    Was £59.99 From £59.99
     
  27. New
    Agarro Tyres

    Vittoria Agarro Tyres

  28. Ikon+ Plus Tyre

    Maxxis Ikon+ Plus Tyre

    Was £69.99 From £69.99
    Out of stock
  29. High Roller II Plus Tyre

    Maxxis High Roller II Plus Tyre

    From £59.99
     
Page