Gesicht

Mini Make-up Collection

Beschreibung

Die praktische Studio Make-up Kollektion für Augen, Lippen und Gesicht. Perfektes Schminken leicht gemacht – wann immer und wo immer!

Die Alles-in-einem-Komfort-Box ist unentbehrlich für alle, die ihren ganz eigenen Style kreieren möchten. Durch das flache und schlanke Design der Box ist die Kollektion ideal für die Handtasche bzw. für unterwegs!

Enthält 27 Studio-Artikel und einen integrierten Spiegel:
9 Lidschatten-Farben, 1 Creme-Lidschatten, 1 Rouge, 1 Bronzer, 10 Lip Gloss Farben, 1 Brauen-Puder, 1 Lidstrich-Stift, 1 Lidschatten-Applikator/-Pinsel, 1 Gesichts-Pinsel sowie 1 Lippen-Pinsel.

Maße:
Geschlossen: 10 x 10 x 2,5 cm.
Geöffnet: 20 x 12 x 2,5 cm.

Bild	Ausführung	Details / Duft	Inhalt	ArtNr	L	Anzahl	Preis	Warenkorb
		S-Box (27 Artikel)		85002			15,99 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Epilier-Pinzette,
1,79 EUR

Lidschatten-Pinsel,
1,79 EUR

Lidstrich-Pinsel,
1,79 EUR

Glanz-Lidstrich, Schwarz
1,79 EUR

Mattierungs-Puder, Apricot Beige (Tone1)
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 499 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `productgroups`	12	12	1
2	DESCRIBE `productmaingroups`	7	7	67
3	DESCRIBE `products`	18	18	42
4	DESCRIBE `productgroups_products`	2	2	54
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` = 85 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 = 85 AND Product.aktiv = 1 ORDER BY order_no, id	1	1	332
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(85002) AND oi2.product_id NOT IN(85002) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	3

(default) 7 queries took 499 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` = 85 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 = 85 AND Product.aktiv = 1 ORDER BY order_no, id

332

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(85002) AND oi2.product_id NOT IN(85002) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5