string(0) ""
string(7312) "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.doc_1,
PD.doc_2,
PD.doc_3,
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 = '92843' 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
"
Kit Trucco Wild Life - Tutete
string(0) ""
string(7312) "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.doc_1,
PD.doc_2,
PD.doc_3,
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 = '92843' 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
"
https://www.tutete.com/tienda/it/96_giocattoli-per-bambini/320_smalti-lucidalabbra-e-tattoo/92843_kit-trucco-wild-life.html92843Kit Trucco Wild LifeCrea il tuo trucco da animale selvaggio con questo kit di trucchi certificato biologico, ipoallergenico e a base d'acqua che contiene una palette di 6 colori.
Modo d'uso: il colore viene sciolto con acqua e applicato sulla pelle con il pennello. La rimozione del trucco si esegue facilmente con acqua tiepida e un po' di sapone. Dopo l'uso, lascia asciugare il pennello e la palette di ombretti prima di riporli nella confezione.
Namaki è un marchio francese che formula cosmetici delicati nel rispetto della pelle dei bambini e dell'ambiente, dermatologicamente testati e non testati sugli animali.
Caratteristiche
Il 99.9% degli ingredienti è di origine naturale, il 21% proviene da agricoltura biologica
Contiene una palette di 6 colori (nero, bianco, marrone, grigio, giallo e arancio), 1 pennello e 5 modelli di trucco
Ogni tonalità di colore ha 2,5 g
Puoi truccarti fino a 10 volte con un kit
Il trucco può essere conservato fino a 12 mesi dopo l'apertura
Imballaggi in cartone riciclabile
Etichettatura Cosmebio
Certificato da Quality France
Prodotta in Francia
Composizione: Bianco, marrone: gliceril oleato-citrato, oryza sativa in polvere (polvere di riso sativa)1, glicerina2, amido di zea mays (amido di zea mays (mais))1, cellulosa microcristallina, trigliceride caprilico/caprico, gomma di cellulosa, oleico /poligliceridi linoleici/linolenici, gliceril caprilato, pentilene glicole, acido p-anisico, estratto di corteccia di magnolia officinalis, tocoferolo, profumo (fragranza).Oro: mica, gliceril oleato citrato, polvere di oryza sativa (polvere di oryza sativa (riso))1, glicerina2, amido di zea mays (amido di zea mays (mais))1, cellulosa microcristallina, trigliceride caprilico/caprico, silice, cellulosa gomma, poligliceridi oleico/linoleico/linolenico, gliceril caprilato, pentilene glicole, acido p-anisico, estratto di corteccia di magnolia officinalis, tocoferolo, profumo (fragranza). Nero, bianco, arancione: gliceril oleato citrato, polvere di oryza sativa (polvere di oryza sativa (riso))1, glicerina2, amido di zea mays (amido di zea mays (mais))1, cellulosa microcristallina, caprilico/caprico trigliceridi, gomma di cellulosa, poligliceridi oleico/linoleico/linolenico, gliceril caprilato, pentilene glicole, acido p-anisico, estratto di corteccia di magnolia officinalis, tocoferolo, profumo (fragranza).+/- CI 77891 (biossido di titanio), CI 77510 (ferrico ammonio ferrocianuro), CI 77491 (ossidi di ferro), CI 77492 (ossidi di ferro), CI 77499 (ossidi di ferro), CI 75470 (carminio).
https://s3-eu-south-2.ionoscloud.com/dev-cdn-in.tutete.com/admin/assets/images/productos/6/2/9/7/2/5/629725-1200x1000.jpg31.9InStock31.9000/Juguetes para Niños/Pintura de Uñas, Brillos y TattoosNamakicosmetici namakikit trucco Namakiface paintingtrucca bimbiNamaki
Crea il tuo trucco da animale selvaggio con questo kit di trucchi certificato biologico, ipoallergenico e a base d'acqua che contiene una palette di 6 colori.
Modo d'uso: il colore viene sciolto con acqua e applicato sulla pelle con il pennello. La rimozione del trucco si esegue facilmente con acqua tiepida e un po' di sapone. Dopo l'uso, lascia asciugare il pennello e la palette di ombretti prima di riporli nella confezione.
Namaki è un marchio francese che formula cosmetici delicati nel rispetto della pelle dei bambini e dell'ambiente, dermatologicamente testati e non testati sugli animali.
Caratteristiche
Il 99.9% degli ingredienti è di origine naturale, il 21% proviene da agricoltura biologica
Contiene una palette di 6 colori (nero, bianco, marrone, grigio, giallo e arancio), 1 pennello e 5 modelli di trucco
Ogni tonalità di colore ha 2,5 g
Puoi truccarti fino a 10 volte con un kit
Il trucco può essere conservato fino a 12 mesi dopo l'apertura
Imballaggi in cartone riciclabile
Etichettatura Cosmebio
Certificato da Quality France
Prodotta in Francia
Composizione: Bianco, marrone: gliceril oleato-citrato, oryza sativa in polvere (polvere di riso sativa)1, glicerina2, amido di zea mays (amido di zea mays (mais))1, cellulosa microcristallina, trigliceride caprilico/caprico, gomma di cellulosa, oleico /poligliceridi linoleici/linolenici, gliceril caprilato, pentilene glicole, acido p-anisico, estratto di corteccia di magnolia officinalis, tocoferolo, profumo (fragranza). Oro: mica, gliceril oleato citrato, polvere di oryza sativa (polvere di oryza sativa (riso))1, glicerina2, amido di zea mays (amido di zea mays (mais))1, cellulosa microcristallina, trigliceride caprilico/caprico, silice, cellulosa gomma, poligliceridi oleico/linoleico/linolenico, gliceril caprilato, pentilene glicole, acido p-anisico, estratto di corteccia di magnolia officinalis, tocoferolo, profumo (fragranza). Nero, bianco, arancione: gliceril oleato citrato, polvere di oryza sativa (polvere di oryza sativa (riso))1, glicerina2, amido di zea mays (amido di zea mays (mais))1, cellulosa microcristallina, caprilico/caprico trigliceridi, gomma di cellulosa, poligliceridi oleico/linoleico/linolenico, gliceril caprilato, pentilene glicole, acido p-anisico, estratto di corteccia di magnolia officinalis, tocoferolo, profumo (fragranza). +/- CI 77891 (biossido di titanio), CI 77510 (ferrico ammonio ferrocianuro), CI 77491 (ossidi di ferro), CI 77492 (ossidi di ferro), CI 77499 (ossidi di ferro), CI 75470 (carminio).