PINDALOO

Fancy sharpening your hand-eye coordination skills? Play Pindaloo! Pindaloo is the new toy that is so addictive it will definitely be the next new craze. Suitable for both kids and adults, almost anyone can play this simple ball game of looping the ball through the loop continuously as many times as you can. This toy is perfect to get the kids of their electronic toys and outside in the fresh air. It’s also a great ball game for kids parties. Order your Pindaloo solo or in a family pack today!

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 = '5' LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 5 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 (122999, 123000, 123001, 123002, 167374, 167375))) AND (e.created_in <= '1638698403') AND (e.updated_in > '1638698403') ORDER BY FIELD(e.entity_id,122999,123000,123001,123002,167374,167375)