Spagnolo
Italiano
Inglese
Portoghese
Francese
string(0) ""
string(7315) "SELECT
(
SELECT customizations_code_value
FROM customizations_code
WHERE customizations_code_id = P.customizations_code_id
) as codigo_maquina,
P.products_id,
PD.products_name,
PD.products_description,
PD.ai,
PD.publicar,
P.products_quantity,
P.products_type,
P.products_cost_price,
IFNULL(s.specials_new_products_price, P.products_price_text) precio_final,
P.products_price_text,
P.barcode,
P.es_promocion,
P.btn_visible_solo_comerciales,
P.barcodeGenerate,
P.manufacturers_id,
(
SELECT manufacturers_name FROM manufacturers WHERE manufacturers_id=P.manufacturers_id LIMIT 1
) manufacturers_name,
P.products_reorder_level,
P.ref_fabricante,
P.customization,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_med,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_lrg,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_sm_1,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_xl_1,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_sm_2,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=2 LIMIT 1), NULL) as products_image_xl_2,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_sm_3,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=3 LIMIT 1), NULL) as products_image_xl_3,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_sm_4,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=4 LIMIT 1), NULL) as products_image_xl_4,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_sm_5,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=5 LIMIT 1), NULL) as products_image_xl_5,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_sm_6,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=6 LIMIT 1), NULL) as products_image_xl_6,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_sm_7,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=7 LIMIT 1), NULL) as products_image_xl_7,
IFNULL((SELECT CONCAT(pi.path, '-400x338.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_list,
IFNULL((SELECT CONCAT(pi.path, '-1200x1000.jpg') FROM products_images pi WHERE pi.products_id=P.products_id AND pi.deleted=0 AND pi.order=1 LIMIT 1), NULL) as products_image_detail,
NULL as products_image_video,
P.products_embed_video,
P.showPreview,
P.is_exclusive,
P.products_production_days,
P.dias_produccion_a_causa_de,
DATE_FORMAT(P.products_date_available, '%Y-%m-%d') products_date_available,
P.products_model,
P.products_status,
P.products_date_added,
P.customizations_code_id,
P.products_color_rgb,
P.products_tax_class_id,
s.status as specstat,
s.specials_new_products_price specials_new_products_price,
P.products_tasks,
P.puntos,
P.sumar_personalizacion,
P.ref_catalogo,
ISNULL(fp.products_id) as disponibleFueraUE,
P.es_dropshipping,
P.meses_min,
P.meses_max,
0 discount,
P.es_producto_manufacturado as PERSONALIZADO,
ROUND((1 - s.specials_new_products_price / P.products_price_text) * 100, -1) AS descuento
FROM products P
INNER JOIN products_description PD ON P.products_id = '87700' AND PD.language_id = '4' AND PD.products_id = P.products_id
LEFT JOIN filtros_products fp ON
P.products_id = fp.products_id AND fp.filtros_id = '97' #Filtro 97 = 'soloDisponibleEnUE'
LEFT JOIN specials s ON
P.products_id = s.products_id AND s.status=1 AND (s.expires_date>now() OR s.expires_date='0000-00-00 00:00:00') AND s.es_vip = 0
LEFT JOIN specials svip ON
P.products_id = svip.products_id AND svip.status=1 AND (svip.expires_date>now() OR svip.expires_date='0000-00-00 00:00:00') AND svip.es_vip = 1
WHERE P.products_type!='4' AND P.products_type!='8'
group by P.products_id
"
Giocattoli per bambini > Giocattoli Bimbi 3 Anni > Zoo Walkie Talkie Rabbit/Rabbit
https://www.tutete.com/tienda/it/96_giocattoli-per-bambini/326_giocattoli-bimbi-3-anni/87700_zoo-walkie-talkie-rabbitrabbit.html
87700
Zoo Walkie Talkie Rabbit/Rabbit
https://s3.eu-west-1.amazonaws.com/dev-cdn.tutete.com/admin/assets/images/productos/6/1/3/9/6/1/613961-1200x1000.jpg
54.95
EUR
InStock
96_giocattoli-per-bambini
96_giocattoli-per-bambini/326_giocattoli-bimbi-3-anni
2024-07-04
ricetrasmittente
The Zoofamily
walkie talkie
Il divertimento è assicurato con i walkie talkie Zoo di The Zoofamily!
Rivestiti in silicone per resistere a piccole cadute accidentali, hanno una portata fino a 3 km, perfetti per giocare a nascondino o per restare in contatto durante le escursioni. Sono facili da usare e dispongono di una luce led integrata per giocare di notte in campeggio o in giardino.
Il sistema a pulsante singolo garantisce una comunicazione immediata, promuovendo il gioco interattivo e migliorando la comunicazione tra i giovani avventurieri.
Amore per la natura: per ogni fotocamera Zoofamily acquistata, il brand si impegna a piantare un albero.
Caratteristiche
- Include: 2 walkie talkie, 1 set di adesivi, 2 tracolle e istruzioni
- Misure: 5,75 x 13,15 x 3,75 cm
- Materiale: ABS + silicone, finitura morbida al tatto
- Potenza di uscita: 0,5 W
- Funziona con 3 batterie AAA (non incluse)
- Intervallo: da 1 a 3 km (all'aperto, la portata viene ridotta in presenza di ostacoli come montagne, boschi...)
- Torcia elettrica inclusa
- Il walkie talkie è un dispositivo elettronico, non un giocattolo. Può rompersi se cade o viene colpito duramente.
- A partire da 3 anni