What a brand we have here. Everything these guys touch ends up in with a tinge of green and black, and despite a fairly un-dynamic colourset, these boys know how to make skate gear that will knock you out the park. Their decks tend to hit the larger size of the scale so if you love skating pools / bowls / vert you have landed in the right place. Huge purveyors of the 'hesh' skating culture with one of the sickest teams around, even if most of them look like they haven't seen a shower lately!

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 (124807, 125804, 132793, 132794, 132943, 133437, 133438, 133439, 133440, 133441, 161714, 161715, 163793, 164075, 164076, 164077, 164079, 169137, 169138))) AND (e.created_in <= '1637884861') AND (e.updated_in > '1637884861') ORDER BY FIELD(e.entity_id,124807,125804,132793,132794,132943,133437,133438,133439,133440,133441,161714,161715,163793,164075,164076,164077,164079,169137,169138)