From dirt jump and BMX parts in the early days, today we have developed into a multi discipline company. The MTB jump market was evolving quicker than the companies within it could make suitable products; so Gusset Components stepped in to fill the breach. Quickly gaining a reputation for making bombproof parts, the range has continued to grow and now includes a varied range from beginner level parts to pro spec components made with premium materials covering mountain bikes, BMX and urban bikes.
GBP
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 (101634, 101635, 101636, 101637, 101638, 101639, 101640, 101641, 101642, 101643, 101644, 101645, 101648, 101649, 101651, 101652, 101653, 101654, 101655, 101656, 101658, 101659, 101660, 101661))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,101634,101635,101636,101637,101638,101639,101640,101641,101642,101643,101644,101645,101648,101649,101651,101652,101653,101654,101655,101656,101658,101659,101660,101661)
We use cookies and other similar technologies to improve your browsing experience and the functionality of our site. By clicking "Accept All Cookies", you consent to the storing on your device of all the technologies described in our Privacy Policy.
More Colours Available
