Lippen

Lip Gloss (Mineral)

Mineral Lip Gloss

Beschreibung

Dieser Lip Gloss hinterlässt super Glanz ohne ein klebrige Gefühl zu verursachen.
Enthält Vitamin A und E um die Lippen zu schützen und Feuchtigkeit zu spenden.
100% Mineral, Ohne Parabene, keine Konservierungsmittel und ohne chemische Färbung.

Inhaltsstoffe

Mineral Oil, Ethylhexyl Palmitate, Hydrogenated Polyisobutene, Mica Silica, Capryly Glycol, Tocopherol (Vitamin E), Retinyl Palmitate (Vitamin A), Titanium Dioxide, Iron Oxides (CI77491, CI77492, CI77499), Manganese Violet (CI77742), Mica (CI77019), Red No.7 Lake (CI15850), Red No.27 Lake (CI45410), Red No.6 Lake (CI15850), Blue No.1 Lake (CI42090), Yellow No.5 Lake (CI19140), Yellow No.6 Lake (CI15985).

Details / Duft	Inhalt	ArtNr	Preis
Crystal Clear	6.5 g 69,08 EUR/100g	6731	4,49 EUR*
Au Naturale	6.5 g 69,08 EUR/100g	6732	4,49 EUR*
Trophy Wife	6.5 g 69,08 EUR/100g	6733	4,49 EUR*
Sorority Girl	6.5 g 69,08 EUR/100g	6734	4,49 EUR*
Fierce	6.5 g 69,08 EUR/100g	6736	4,49 EUR*
Night Owl	6.5 g 69,08 EUR/100g	6738	4,49 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Lidschatten-Pinsel,
1,79 EUR

Lidstrich-Pinsel,
1,79 EUR

Grundierungs-Puder LSF 15 (Mineral),
6,99 EUR

Nagel-Lack, Blush
1,79 EUR

Nagel-Lack, Champagne
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) 3 queries took 342 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	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` = 249 LIMIT 1	1	1	0
2	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 = 249 AND Product.aktiv = 1 ORDER BY order_no, id	6	6	335
3	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(6731, 6732, 6733, 6734, 6736, 6738) AND oi2.product_id NOT IN(6731, 6732, 6733, 6734, 6736, 6738) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	7

(default) 3 queries took 342 ms

Query

Error

Affected

Num. rows

Took (ms)

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` = 249 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 = 249 AND Product.aktiv = 1 ORDER BY order_no, id

335

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(6731, 6732, 6733, 6734, 6736, 6738) AND oi2.product_id NOT IN(6731, 6732, 6733, 6734, 6736, 6738) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5