ENUFF

Enuff is an all-British brand, established in January 2006 by a collaboration of two skateboarding experts. Together they had a vision to create a top level UK brand that was fun and affordable without compromising quality. Above all of this, the most important key to Enuff was supporting the UK scene and helping to bring young, unknown skaters to the forefront of the UK talent. The likes of Sam Bosworth, Pete Adams and Alex Halford have all been part of the Enuff team and a true testament to their reasoning of supporting young UK skaters!

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 (234104, 234129, 234130, 31888, 205113, 234141, 237835, 237836, 234110, 234120, 234143, 92555, 92556, 108389, 108391, 108392, 108819, 108820, 108821, 108822, 108823, 108824, 108825, 108826))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,234104,234129,234130,31888,205113,234141,237835,237836,234110,234120,234143,92555,92556,108389,108391,108392,108819,108820,108821,108822,108823,108824,108825,108826)
Page