POGO STICKS

Shop kids pogo sticks for kids aged 3 and over from SkateHut today. As part of our outdoor kids toys range, you can find many models that put a modern twist on the old pogo stick design, to provide hours of fun for kids who love to play outside! Our full range includes top brands like Madd Gear Pro, Flybar and Qu-Ax. Order over £40 will come with Free Delivery. Have any questions or Queries on our pogo stick range? Contact our super-friendly support team via our online chat.

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 (245468, 122946, 122943, 139192, 153084, 153085, 122941, 122942, 122949, 122944, 122945, 167321, 122940, 122947, 122951, 122950, 122953, 167322, 122952, 139190, 167323, 122948, 134648, 122954))) AND (e.created_in <= '1638356402') AND (e.updated_in > '1638356402') ORDER BY FIELD(e.entity_id,245468,122946,122943,139192,153084,153085,122941,122942,122949,122944,122945,167321,122940,122947,122951,122950,122953,167322,122952,139190,167323,122948,134648,122954)