FINGERBOARD PARKS

Shop a great range of finger skateboards and other Tech Deck sensations. Find great small gifts and treats such as fidget spinners, fingerboards, fingerboard ramps, fingerboard rails and more. The Build-A-Park set includes everything you need to build an awesome custom park for you to test your fingerboarding skills! Start your collection now.

Loading...
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 (123011, 123013, 123014, 123019, 123020, 123021, 123026, 134631, 134633, 134636, 134657, 134659, 134663, 134665, 134667, 134668, 134669, 134674, 139184, 167327, 167328, 167329, 167334, 177414, 177415, 177424, 177425, 177426))) AND (e.created_in <= '1632902400') AND (e.updated_in > '1632902400') ORDER BY FIELD(e.entity_id,123011,123013,123014,123019,123020,123021,123026,134631,134633,134636,134657,134659,134663,134665,134667,134668,134669,134674,139184,167327,167328,167329,167334,177414,177415,177424,177425,177426)