Shop an exciting range of Element skateboards, decks, trucks, t shirts, hoodies and loads more! Element Skateboards is a highly successful skateboard company based in Irvine, California. Element Skateboards has adopted the principles of martial arts and the purities associated with it. Their focus and attention is on the future of the brand, what it represents and the way the world perceives it. In an effort to shine a positive light on the global skateboarding community, Element Skateboards created the masterful Department of Elementology. With the idea of designing innovative and quality products that promote an environmentally-friendly skate culture, Element created programs such as Elemental Awareness and Element Endangered.

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 (277908, 277912, 277915, 277923, 277924, 277927, 277930, 277936, 277937, 277938, 281326, 277910, 277913, 277922, 277925, 277926, 277928, 277929, 277931, 277932, 280899, 281325, 294030, 277911))) AND (e.created_in <= '1656698400') AND (e.updated_in > '1656698400') ORDER BY FIELD(e.entity_id,277908,277912,277915,277923,277924,277927,277930,277936,277937,277938,281326,277910,277913,277922,277925,277926,277928,277929,277931,277932,280899,281325,294030,277911)

Showing 24 out of 30