35 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=18688 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_607d6aa24c53c5_26771989` 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. Tubeless Ready MTB Tyre

    Nutrak Tubeless Ready MTB Tyre

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

    Nutrak Mileater tyre with puncture breaker and reflective, black

  3. Road tyre

    Nutrak Road tyre

  4. MTB Slick tyre skinwall black

    Nutrak MTB Slick tyre skinwall black

    From £20.99
     
  5. Best Seller
    Commuter tyre

    Nutrak Commuter tyre

  6. Best Seller
    Traditional tyre

    Nutrak Traditional tyre

    From £18.99
     
  7. Best Seller
    Street Tyre Black for Strollers

    Nutrak Street Tyre Black for Strollers

    From £14.99
     
  8. Best Seller
    Blockhead Tyre

    Nutrak Blockhead Tyre

    From £14.99
     
  9. Best Seller
    Comp tyre black

    Nutrak Comp tyre black

    From £14.99
     
  10. Inner Tube Self-sealing Presta or Schrader

    Nutrak Inner Tube Self-sealing Presta or Schrader

  11. Inner Tube 26"

    Nutrak Inner Tube 26"

    From £6.99
     
  12. Best Seller
    Inner Tube 700C Presta or Schrader Valve

    Nutrak Inner Tube 700C Presta or Schrader Valve

    From £6.99
     
  13. Inner Tube Youth Bikes

    Nutrak Inner Tube Youth Bikes

  14. Inner Tube 27.5 inch (650B) Schrader or Presta

    Nutrak Inner Tube 27.5 inch (650B) Schrader or Presta

    From £6.99
     
Page