BLANK

BLANK was started in 2004 in Cheddar, Somerset, when Rob Hill and Andy Bishop of Split Second Imports decided they needed another BMX brand to add to their bike portfolio. Rather than try to acquire an existing brand, they decided that due to the years of experience they had both accumulated in the study of bike spec, costs, design and import logistics, they would use all of their ideas and expertise to invent their own! Today BLANK products can be found in BMX retailers across the length and breadth of the UK, offering replacement and after-market parts and accessories of all sizes, shapes and colours, all at the same great price you’ve come to expect from BLANK, along with the awesome range of complete bikes which seem to get better year-on-year!

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 (244923, 244924, 60241, 156074, 156075, 156078))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,244923,244924,60241,156074,156075,156078)