Thule Chariot

Thule Chariot

Having spent 70 years building a reputation for solutions that let you take anything you want along for a ride Thule Chariot now provides a safe and unique way to transport your children while you ride. Thule believes in tough stable and safe carriers that let you take your children along secure in the knowledge that they are well looked after. No matter if your cycling, hiking, jogging or even cross-country skiing the Chariot is there and ready for action.

8 Items

per page
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.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')) 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 WHERE ((e.entity_id IN (442935, 442923, 442890, 442899, 442887, 442902, 442869, 442911))) AND (e.created_in '1627772401') ORDER BY FIELD(e.entity_id,442935,442923,442890,442899,442887,442902,442869,442911)