RIDE CONCEPTS

Ride Concepts was born with one common mission: to build the most comfortable, durable and reliable mountain bike footwear. A rider-owned company based in the mountains of Lake Tahoe, all their products are designed and tested in their surroundings by their team of factory pros and everyday riders. Ride Concepts is a company true to its core, SkateHut is proud to stock Ride Concepts MTB footwear.

Loading...
SELECT `e`.*, `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` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' 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 `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE ((stock_status_index.stock_status = 1) AND (e.entity_id IN (59306, 59312, 153615, 153619, 59309, 153614, 59307, 59308, 59310, 153617, 153618, 153620, 153621, 153622, 153623, 153624, 153625, 153626, 158373, 158374, 158376))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,59306,59312,153615,153619,59309,153614,59307,59308,59310,153617,153618,153620,153621,153622,153623,153624,153625,153626,158373,158374,158376)