This website is operated by H. Young (Operations) Limited. It uses cookies and other similar technologies to collect information about how it is used and what users’ preferences are. This information helps us provide users with a better browsing experience, improve how our website operates and the product selection and services available through it, and deliver targeted advertising and marketing that is more relevant to our users’ interests. For more information, see our Cookie Policy. We require your consent to set certain non-essential cookies on your device. By continuing to browse our website without changing your cookie preferences, you consent to us setting cookies on your device. You can withdraw your consent at any time by changing your cookie preferences. Our Cookie Policy explains how you can do this.
Balance bikes are the perfect way to get your little one on the bike sooner. Without the complication of pedals and gears they can scoot around to their hearts content whilst learning how to handle a bike. All of our balance bikes are built to enhance your child's learning and to withstand being dropped!
8 Items
per page
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF(at_price_desc.value_id > 0, at_price_desc.value, at_price_desc_default.value) AS `price_desc` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=22133
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
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 `search_tmp_6046cfdc05aa65_74412011` AS `search_result` ON e.entity_id = search_result.entity_id
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc_default` ON (`at_price_desc_default`.`row_id` = `e`.`row_id`) AND (`at_price_desc_default`.`attribute_id` = '887') AND `at_price_desc_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc` ON (`at_price_desc`.`row_id` = `e`.`row_id`) AND (`at_price_desc`.`attribute_id` = '887') AND (`at_price_desc`.`store_id` = 1) WHERE (e.created_in '1615161601') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc
LIMIT 30
