Toy Machine began in 1993 and have been tearing the earth a new A-hole for over 18 years. Through superior deck construction, world-renowned T-Shirts, and state of the art wheel design, Toy Machine Skateboard Company has devoted the last 18 years to brainwashing young skaters into die-hard fans who stay loyal to the quality they have grown addicted to. The most celebrated part of Toy Machine is the advertising and graphics from the mind of Ed Templeton, Toy Machine’s creator and mastermind. The combination of Toy Machine’s brain-altering graphics and the worlds best skate team including Leo Romero, Johnny Layton, Daniel Lutheran, Collin Provost, and Billy Marks has made Toy Machine the world’s most sought after skateboard company.

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 (283853, 285500, 285773, 283543, 283544, 282185, 282186, 282188, 282192, 282194, 282195, 283545, 283852, 285499, 286093, 286735, 282184, 282189, 282193, 283542, 67839, 108894, 135715, 135720))) AND (e.created_in <= '1652691602') AND (e.updated_in > '1652691602') ORDER BY FIELD(e.entity_id,283853,285500,285773,283543,283544,282185,282186,282188,282192,282194,282195,283545,283852,285499,286093,286735,282184,282189,282193,283542,67839,108894,135715,135720)

Showing 24 out of 140