Grooptoo dispose d'un magasin de puériculture en ligne pour bébé où tout est réuni pour accueillir votre enfant ou le laisser grandir dans les meilleures conditions,...pluset cela, avec de gros rabais. Notre magasin pour bébés et enfants dispose grâce au soutien de Sobaby d'un vaste choix de jouets en bois (Boikido, Plan Toys), de chancelières, d'articles pour le bain et de nombreux autres articles pour bébés comme les porte-bébés, les sièges Doomoo et les célèbres hamacs Amazonas. moins
XXXXXXXXXXXXXXXX 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`, `at_socko_date_ok`.`value` AS `socko_date_ok`, `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 = 8 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
INNER JOIN `catalog_product_entity_int` AS `at_socko_date_ok` ON (`at_socko_date_ok`.`entity_id` = `e`.`entity_id`) AND (`at_socko_date_ok`.`attribute_id` = '553') AND (`at_socko_date_ok`.`store_id` = 0)
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (at_socko_date_ok.value = 1) AND (e.entity_id IN (58482, 58438, 58379, 58128, 58118, 58012, 55223, 54848)) ORDER BY FIELD(e.entity_id,58482,58438,58379,58128,58118,58012,55223,54848)