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.
GBP
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)
We use cookies and other similar technologies to improve your browsing experience and the functionality of our site. By clicking "Accept All Cookies", you consent to the storing on your device of all the technologies described in our Privacy Policy.
