Founded in 1980 in the heart of Hawaii, Maui and Sons have been at the forefront of the skate apparel business for decades. Branching out, Maui and Sons longboards and skateboards have become a huge part of their business, with enthusiasts and beginners alike falling for their products. All of their products are available in a variety of shapes and sizes to best suit the rider, and with both Maui and Sons cruisers and Maui and Sons stunt scooters joining the product line, there isn’t an adventurer out there who isn’t catered to. Suitable for both girls and boys – with styles to suit either – this is a brand you can trust, with a wealth of knowledge and experience forged across a long and successful career within the adventure sports industry.

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 (177527, 177534, 84225, 238747, 238749, 238750, 177523, 177524, 177525, 175465, 174940, 83892, 238748, 177526, 177528, 177533, 177529, 174941, 84120, 238751, 177591))) AND (e.created_in <= '1656093600') AND (e.updated_in > '1656093600') ORDER BY FIELD(e.entity_id,177527,177534,84225,238747,238749,238750,177523,177524,177525,175465,174940,83892,238748,177526,177528,177533,177529,174941,84120,238751,177591)

21 Items