Gesicht

Abdeck-Stift

All Over Cover Stick

Beschreibung

Der perfekte Stift für alle Haut-Typen und Haut-Töne!
Deckt schnell und zuverlässig unerwünschte Hautunreinheiten im Gesicht und am Körper ab! Durch natürliche und hautfreundliche Inhaltsstoffe wird das Gesicht und die Haut gepflegt und geschützt.
Besonders empfehlenswert für Augenringe und Hautunreinheiten.
Optimal für anfällige Haut. Farben:

Fair –> Helle Abdeckung (für den hellen Hauttyp und neutrale Untertöne)

Light –> Leichte Abdeckung (für den mittleren Hauttyp und warme Untertöne)

Warm –> Mittlere Abdeckung (für den dunkleren Hauttyp und neutrale
Untertöne)

Anwendung

Stift drehen und die Abdeck-Creme nach Belieben auf die bevorzugten oder über alle Partien auftragen.

Inhaltsstoffe

Microcrystalline Wax, Ceresin Wax, Synthetic Beeswax, Cetyl Alcohol, Bis-Diglyceryl Polyacyladipate-2, Titanium Dioxide, Methlyparaben, Ethylhexyl Palmitate, kann [±] CI 77491, CI 77492, CI 77499 enthalten.

Details / Duft	Inhalt	ArtNr	Preis
Fair	4 g 44,75 EUR/100g	3201	1,79 EUR*
Light	4 g 44,75 EUR/100g	3202	1,79 EUR*
Medium	4 g 44,75 EUR/100g	3203	1,79 EUR*
Toffee	4 g 44,75 EUR/100g	3204	1,79 EUR*
Ivory	4 g 44,75 EUR/100g	3205	1,79 EUR*
Light Beige	4 g 44,75 EUR/100g	3206	1,79 EUR*
Rosy Beige	4 g 44,75 EUR/100g	3207	1,79 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Lidschatten-Pinsel,
1,79 EUR

Duo-Mascara, Schwarz
1,79 EUR

3-in-1 Farbstift, Pink Lemonade
1,79 EUR

Nagel-Lack, Nude
1,79 EUR

Lidstrich-Pinsel,
1,79 EUR

* Alle Preise inkl. MwSt., ggf. zuzüglich Zahlungs- und Versandkosten, ab 25 EUR Bestellwert in Deutschland versandkostenfrei.
ausreichend auf Lager nur noch geringe Menge auf Lager Nicht auf Lager, in ca. 2 Wochen wieder verfügbar

(default) 7 queries took 480 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `productgroups`	12	12	1
2	DESCRIBE `productmaingroups`	7	7	59
3	DESCRIBE `products`	18	18	40
4	DESCRIBE `productgroups_products`	2	2	23
5	SELECT `productgroup`.`anwendung`, `productgroup`.`beschreibung`, `productgroup`.`inhaltsstoffe`, `productgroup`.`name_en` FROM `productgroups` AS `productgroup` LEFT JOIN `productmaingroups` AS `Productmaingroup` ON (`productgroup`.`productmaingroup_id` = `Productmaingroup`.`id`) WHERE `productgroup`.`id` = 24 LIMIT 1	1	1	0
6	SELECT id, name_de, inhalt_g, inhalt_ml, farbe_de, farbe_en, duft, preis_ev, preis_ret, bestand, bestellt, DATE_FORMAT(created, '%d.%m.%Y') AS created, IF(DATE_ADD(Product.created, INTERVAL 30 day) > NOW(), 1, 0) AS neu FROM products As Product JOIN productgroups_products AS pp ON Product.id = pp.product_id LEFT JOIN product_open_from_orders AS ProductOpenFromOrder ON Product.id = ProductOpenFromOrder.product_id WHERE pp.productgroup_id = 24 AND Product.aktiv = 1 ORDER BY order_no, id	7	7	327
7	SELECT oi2.product_id, CONCAT(pg.name_de, ', ', IF(p.farbe_de IS NULL, farbe_en, farbe_de)) AS name_de, count(DISTINCT o.id) AS anzahl, pg.id, p.preis_ev, p.preis_ret FROM order_items AS oi JOIN orders AS o ON oi.order_id = o.id AND o.bestelldatum >= DATE_SUB(CURRENT_DATE(), INTERVAL 42 DAY) JOIN order_items AS oi2 ON o.id = oi2.order_id JOIN products AS p ON oi2.product_id = p.id AND p.aktiv = 1 AND p.bestand >= 5 JOIN productgroups_products AS pgp ON p.id = pgp.product_id JOIN productgroups AS pg ON pgp.productgroup_id = pg.id AND pg.aktiv = 1 WHERE oi.product_id IN(3201, 3202, 3203, 3204, 3205, 3206, 3207) AND oi2.product_id NOT IN(3201, 3202, 3203, 3204, 3205, 3206, 3207) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	30

(default) 7 queries took 480 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `productgroups`

DESCRIBE `productmaingroups`

DESCRIBE `products`

DESCRIBE `productgroups_products`

SELECT `productgroup`.`anwendung`, `productgroup`.`beschreibung`, `productgroup`.`inhaltsstoffe`, `productgroup`.`name_en` FROM `productgroups` AS `productgroup` LEFT JOIN `productmaingroups` AS `Productmaingroup` ON (`productgroup`.`productmaingroup_id` = `Productmaingroup`.`id`) WHERE `productgroup`.`id` = 24 LIMIT 1

SELECT id, name_de, inhalt_g, inhalt_ml, farbe_de, farbe_en, duft, preis_ev, preis_ret, bestand, bestellt, DATE_FORMAT(created, '%d.%m.%Y') AS created, IF(DATE_ADD(Product.created, INTERVAL 30 day) > NOW(), 1, 0) AS neu FROM products As Product JOIN productgroups_products AS pp ON Product.id = pp.product_id LEFT JOIN product_open_from_orders AS ProductOpenFromOrder ON Product.id = ProductOpenFromOrder.product_id WHERE pp.productgroup_id = 24 AND Product.aktiv = 1 ORDER BY order_no, id

327

SELECT oi2.product_id, CONCAT(pg.name_de, ', ', IF(p.farbe_de IS NULL, farbe_en, farbe_de)) AS name_de, count(DISTINCT o.id) AS anzahl, pg.id, p.preis_ev, p.preis_ret FROM order_items AS oi JOIN orders AS o ON oi.order_id = o.id AND o.bestelldatum >= DATE_SUB(CURRENT_DATE(), INTERVAL 42 DAY) JOIN order_items AS oi2 ON o.id = oi2.order_id JOIN products AS p ON oi2.product_id = p.id AND p.aktiv = 1 AND p.bestand >= 5 JOIN productgroups_products AS pgp ON p.id = pgp.product_id JOIN productgroups AS pg ON pgp.productgroup_id = pg.id AND pg.aktiv = 1 WHERE oi.product_id IN(3201, 3202, 3203, 3204, 3205, 3206, 3207) AND oi2.product_id NOT IN(3201, 3202, 3203, 3204, 3205, 3206, 3207) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5