TOTAL BMX

There is a simple truth that comes with riding a BMX to full capacity – eventually, some things are going to need replacing. One of the world’s largest BMX spare parts specialists, Total BMX are at the forefront of this field, offering sprockets, headsets and forks, as well as their own branded Total BMX seats, which we sell a variety of. Total BMX wheels are also some of the sturdiest and most trustworthy around, coming in a variety of styles and sizes, dependent on what you want to get out of your bike. The beauty of owning a BMX is that they can be truly customised and individualised, creating an extension of your own personality – and that’s where Total BMX can help you truly come in to your own. Running repairs and constant modification is a central pillar of the true BMX experience, and should you find yourself catching the bug, there may not be a better brand than Total BMX to get familiar with.

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 (127915, 135150, 135184, 156510))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,127915,135150,135184,156510)