Gesicht

Anti-age-Tönung LSF 15

Tinted Moisturizer SPF 15

Beschreibung

Tönt und schützt (LSF 15) jeden Hauttyp vor UV-Strahlung und frühzeitiger Alterung!
Die Feuchtigkeit spendende Anti-aging-Formel beugt Alterungsprozessen sowie Sonneneinstrahlungen vor – und erhält die Haut jung, gesund und geschmeidig.

Anwendung

Täglich oder bei Bedarf eine geringe Menge auf die bevorzugten Hautpartien auftragen – und sanft eincremen.

Inhaltsstoffe

Caprylic/Capric Trigly-ceride, Kaolin, Titanium Dioxide, Talc, Mica, Octyl Palmitate, Glyceryl Stea-rate, Synthetic Beeswax, Stearic Acid, Stearyl Alcohol, DEA-Cetyl Phos-phate, Propylene Glycol, Magnesi-um Aluminum Silicate, Phenoxy-ethanol, Triethanolamine, Xanthan Gum, Methylparaben, Propylpara-ben, Ethylparaben, Fragrance (Aro-ma), Disodium EDTA, kann [±] Aqua, Benzophenone-3, Octyl Methoxy-cinnamate, CI 77491, CI 77492, CI 77499 enthalten.

Details / Duft	Inhalt	ArtNr	Preis
Apricot Beige (Tone 1)	12 g 14,92 EUR/100g	6001	1,79 EUR*
Honey (Tone 2)	12 g 14,92 EUR/100g	6002	1,79 EUR*
Spice (Tone 3)	12 g 14,92 EUR/100g	6003	1,79 EUR*
Toffee (Tone 4)	12 g 14,92 EUR/100g	6004	1,79 EUR*
Ivory	12 g 14,92 EUR/100g	6005	1,79 EUR*
Light Beige	12 g 14,92 EUR/100g	6006	1,79 EUR*
Rosy Beige	12 g 14,92 EUR/100g	6007	1,79 EUR*

Kunden, die diesen Artikel gekauft haben, kauften auch

Abdeck-Stift, Rosy Beige
1,79 EUR

Duo-Mascara, Schwarz
1,79 EUR

3-in-1 Farbstift,
1,79 EUR

Nagel-Lack, Nude
1,79 EUR

Warning (2): getimagesize(img/products/1203_m.jpg) [function.getimagesize]: failed to open stream: No such file or directory [APP/views/kosmetik/productgroup.ctp, line 202]

Code | Context

$___viewFn	=	"/homepages/26/d283610669/htdocs/app/views/kosmetik/productgroup.ctp"
$___dataForView	=	array(
	"productMainGroupId" => 3,
	"productMainGroup" => "Gesicht",
	"productMainGroupUrl" => "gesicht",
	"productGroupId" => 27,
	"productGroup" => "Anti-age-Tönung LSF 15",
	"productGroupUrl" => "anti-age-toenung-lsf-15",
	"interesting" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"productinfo" => array(
	"productgroup" => array(),
	"Product" => array()
),
	"products" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"meta_keywords" => "Anti-age-Tönung LSF 15, Apricot Beige (Tone 1), Apricot Beige (Tone 1), Honey (Tone 2), Spice (Tone 3), Toffee (Tone 4), Ivory, Light Beige, Rosy Beige",
	"meta_description" => "Tönt und schützt (LSF 15) jeden Hauttyp vor UV-Strahlung und frühzeitiger Alterung!
Die Feuchtigkeit spendende Anti-aging-Formel beugt Alterungsprozessen sowie Sonneneinstrahlungen vor – und erhält die Haut jung, gesund und geschmeidig."
)
$loadHelpers	=	true
$cached	=	false
$loadedHelpers	=	array(
	"shop" => shopHelper
shopHelper::$helpers = array
shopHelper::$base = ""
shopHelper::$webroot = "/"
shopHelper::$themeWeb = NULL
shopHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
shopHelper::$params = array
shopHelper::$action = "productgroup"
shopHelper::$plugin = NULL
shopHelper::$data = NULL
shopHelper::$namedArgs = NULL
shopHelper::$argSeparator = NULL
shopHelper::$validationErrors = NULL
shopHelper::$tags = array
shopHelper::$__tainted = NULL
shopHelper::$__cleaned = NULL
shopHelper::$_log = NULL
shopHelper::$Session = SessionHelper object
shopHelper::$elf = elfHelper object
shopHelper::$form = FormHelper object,
	"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "4d89452a23fb6ac8b525b20000ea0e14"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1268291004
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
SessionHelper::$params = array
SessionHelper::$action = "productgroup"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL,
	"elf" => elfHelper
elfHelper::$helpers = array
elfHelper::$base = ""
elfHelper::$webroot = "/"
elfHelper::$themeWeb = NULL
elfHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
elfHelper::$params = array
elfHelper::$action = "productgroup"
elfHelper::$plugin = NULL
elfHelper::$data = NULL
elfHelper::$namedArgs = NULL
elfHelper::$argSeparator = NULL
elfHelper::$validationErrors = NULL
elfHelper::$tags = array
elfHelper::$__tainted = NULL
elfHelper::$__cleaned = NULL
elfHelper::$_log = NULL
elfHelper::$Session = SessionHelper object,
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
FormHelper::$params = array
FormHelper::$action = "productgroup"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
HtmlHelper::$params = array
HtmlHelper::$action = "productgroup"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"cache" => CacheHelper
CacheHelper::$__replace = array
CacheHelper::$__match = array
CacheHelper::$view = NULL
CacheHelper::$cacheAction = NULL
CacheHelper::$helpers = NULL
CacheHelper::$base = ""
CacheHelper::$webroot = "/"
CacheHelper::$themeWeb = NULL
CacheHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
CacheHelper::$params = array
CacheHelper::$action = "productgroup"
CacheHelper::$plugin = NULL
CacheHelper::$data = NULL
CacheHelper::$namedArgs = NULL
CacheHelper::$argSeparator = NULL
CacheHelper::$validationErrors = NULL
CacheHelper::$tags = array
CacheHelper::$__tainted = NULL
CacheHelper::$__cleaned = NULL
CacheHelper::$_log = NULL,
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
HtmlHelper::$params = array
HtmlHelper::$action = "productgroup"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "4d89452a23fb6ac8b525b20000ea0e14"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1268291004
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
SessionHelper::$params = array
SessionHelper::$action = "productgroup"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$helper	=	"session"
$camelBackedHelper	=	"session"
$shop	=	shopHelper
shopHelper::$helpers = array
shopHelper::$base = ""
shopHelper::$webroot = "/"
shopHelper::$themeWeb = NULL
shopHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
shopHelper::$params = array
shopHelper::$action = "productgroup"
shopHelper::$plugin = NULL
shopHelper::$data = NULL
shopHelper::$namedArgs = NULL
shopHelper::$argSeparator = NULL
shopHelper::$validationErrors = NULL
shopHelper::$tags = array
shopHelper::$__tainted = NULL
shopHelper::$__cleaned = NULL
shopHelper::$_log = NULL
shopHelper::$Session = SessionHelper object
shopHelper::$elf = elfHelper object
shopHelper::$form = FormHelper object
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "4d89452a23fb6ac8b525b20000ea0e14"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1268291004
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
SessionHelper::$params = array
SessionHelper::$action = "productgroup"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$elf	=	elfHelper
elfHelper::$helpers = array
elfHelper::$base = ""
elfHelper::$webroot = "/"
elfHelper::$themeWeb = NULL
elfHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
elfHelper::$params = array
elfHelper::$action = "productgroup"
elfHelper::$plugin = NULL
elfHelper::$data = NULL
elfHelper::$namedArgs = NULL
elfHelper::$argSeparator = NULL
elfHelper::$validationErrors = NULL
elfHelper::$tags = array
elfHelper::$__tainted = NULL
elfHelper::$__cleaned = NULL
elfHelper::$_log = NULL
elfHelper::$Session = SessionHelper object
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = "post"
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
FormHelper::$params = array
FormHelper::$action = "productgroup"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
HtmlHelper::$params = array
HtmlHelper::$action = "productgroup"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$cache	=	CacheHelper
CacheHelper::$__replace = array
CacheHelper::$__match = array
CacheHelper::$view = NULL
CacheHelper::$cacheAction = NULL
CacheHelper::$helpers = NULL
CacheHelper::$base = ""
CacheHelper::$webroot = "/"
CacheHelper::$themeWeb = NULL
CacheHelper::$here = "/kosmetik/gesicht/anti-age-toenung-lsf-15"
CacheHelper::$params = array
CacheHelper::$action = "productgroup"
CacheHelper::$plugin = NULL
CacheHelper::$data = NULL
CacheHelper::$namedArgs = NULL
CacheHelper::$argSeparator = NULL
CacheHelper::$validationErrors = NULL
CacheHelper::$tags = array
CacheHelper::$__tainted = NULL
CacheHelper::$__cleaned = NULL
CacheHelper::$_log = NULL
$productMainGroupId	=	3
$productMainGroup	=	"Gesicht"
$productMainGroupUrl	=	"gesicht"
$productGroupId	=	27
$productGroup	=	"Anti-age-Tönung LSF 15"
$productGroupUrl	=	"anti-age-toenung-lsf-15"
$interesting	=	array(
	array(
	"oi2" => array(),
	array(),
	"pg" => array(),
	"p" => array(),
	"url" => "/kosmetik/gesicht/abdeck-stift?source=suggestion"
),
	array(
	"oi2" => array(),
	array(),
	"pg" => array(),
	"p" => array(),
	"url" => "/kosmetik/augen/duo-mascara?source=suggestion"
),
	array(
	"oi2" => array(),
	array(),
	"pg" => array(),
	"p" => array(),
	"url" => "/kosmetik/gesicht/3-in-1-farbstift?source=suggestion"
),
	array(
	"oi2" => array(),
	array(),
	"pg" => array(),
	"p" => array(),
	"url" => "/kosmetik/naegel/nagel-lack?source=suggestion"
),
	array(
	"oi2" => array(),
	array(),
	"pg" => array(),
	"p" => array(),
	"url" => "/kosmetik/lippen/schimmer-gel-booster?source=suggestion"
)
)
$productinfo	=	array(
	"productgroup" => array(
	"anwendung" => "Täglich oder bei Bedarf eine geringe Menge auf die bevorzugten Hautpartien auftragen – und sanft eincremen.",
	"beschreibung" => "Tönt und schützt (LSF 15) jeden Hauttyp vor UV-Strahlung und frühzeitiger Alterung!
Die Feuchtigkeit spendende Anti-aging-Formel beugt Alterungsprozessen sowie Sonneneinstrahlungen vor – und erhält die Haut jung, gesund und geschmeidig.",
	"inhaltsstoffe" => "?Caprylic/Capric Trigly-ceride, Kaolin, Titanium Dioxide, Talc, Mica, Octyl Palmitate, Glyceryl Stea-rate, Synthetic Beeswax, Stearic Acid, Stearyl Alcohol, DEA-Cetyl Phos-phate, Propylene Glycol, Magnesi-um Aluminum Silicate, Phenoxy-ethanol, Triethanolamine, Xanthan Gum, Methylparaben, Propylpara-ben, Ethylparaben, Fragrance (Aro-ma), Disodium EDTA, kann [±] Aqua, Benzophenone-3, Octyl Methoxy-cinnamate, CI 77491, CI 77492,
CI 77499 enthalten.",
	"name_en" => "Tinted Moisturizer SPF 15"
),
	"Product" => array()
)
$products	=	array(
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
),
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
),
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
),
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
),
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
),
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
),
	array(
	"Product" => array(),
	"ProductOpenFromOrder" => array(),
	array()
)
)
$meta_keywords	=	"Anti-age-Tönung LSF 15, Apricot Beige (Tone 1), Apricot Beige (Tone 1), Honey (Tone 2), Spice (Tone 3), Toffee (Tone 4), Ivory, Light Beige, Rosy Beige"
$meta_description	=	"Tönt und schützt (LSF 15) jeden Hauttyp vor UV-Strahlung und frühzeitiger Alterung!
Die Feuchtigkeit spendende Anti-aging-Formel beugt Alterungsprozessen sowie Sonneneinstrahlungen vor – und erhält die Haut jung, gesund und geschmeidig."
$image	=	"<img src="/img/productgroup/27.jpg" alt="Anti-age-Tönung LSF 15" />"
$imgProductgroup	=	"img/productgroup/27.jpg"
$inhaltsstoffe	=	"Caprylic/Capric Trigly-ceride, Kaolin, Titanium Dioxide, Talc, Mica, Octyl Palmitate, Glyceryl Stea-rate, Synthetic Beeswax, Stearic Acid, Stearyl Alcohol, DEA-Cetyl Phos-phate, Propylene Glycol, Magnesi-um Aluminum Silicate, Phenoxy-ethanol, Triethanolamine, Xanthan Gum, Methylparaben, Propylpara-ben, Ethylparaben, Fragrance (Aro-ma), Disodium EDTA, kann [±] Aqua, Benzophenone-3, Octyl Methoxy-cinnamate, CI 77491, CI 77492,
CI 77499 enthalten."
$zIndex	=	43
$p	=	array(
	"Product" => array(
	"id" => "6007",
	"name_de" => "Anti-age-Tönung LSF 15, Rosy Beige",
	"inhalt_g" => "12.0",
	"inhalt_ml" => null,
	"farbe_de" => "Rosy Beige",
	"farbe_en" => "Rosy Beige",
	"duft" => "",
	"preis_ev" => "1.79",
	"preis_ret" => "0.90",
	"bestand" => "42"
),
	"ProductOpenFromOrder" => array(
	"bestellt" => "2"
),
	array(
	"created" => "17.07.2009",
	"neu" => "0"
)
)
$farbe	=	"Rosy Beige"
$neu	=	""
$farbbild	=	"img/productcolors/6007.jpg"
$img	=	"/img/products/6007.jpg"
$imagedata	=	array(
	80,
	66,
	2,
	"width="80" height="66"",
	"bits" => 8,
	"channels" => 3,
	"mime" => "image/jpeg"
)
$inhalt	=	"<br />12&nbsp;g<br /><span class="grundpreis">14,92&nbsp;EUR/100g</span>"
$bild	=	"img/products/6007.jpg"
$lager	=	"<span class="bestand-green" title="ausreichend auf Lager">&nbsp;&nbsp;&nbsp;</span>&nbsp;&nbsp;"
$input	=	"<div><a href="#" onclick="qtyMinus(6007); return false;"><img src="/img/icon_minus.gif" alt="-" /></a><input type="text" class="anzahl" name="Product[id][6007]" id="i6007" value="1" /><a href="#" onclick="qtyPlus(6007); return false;"><img src="/img/icon_plus.gif" alt="+" /></a></div>"
$button	=	"<input type="image" src="/img/but_addtocart.gif" name="submit[6007]" value="1" />"
$verfuegbarer_bestand	=	40
$c	=	5
$i	=	array(
	"oi2" => array(
	"product_id" => "1203"
),
	array(
	"name_de" => "Schimmer-Gel (Booster), Persimmon",
	"anzahl" => "9"
),
	"pg" => array(
	"id" => "88"
),
	"p" => array(
	"preis_ev" => "1.79",
	"preis_ret" => "0.90"
),
	"url" => "/kosmetik/lippen/schimmer-gel-booster?source=suggestion"
)
$file	=	"img/products/1203_m.jpg"
$margintop	=	0
$data	=	array(
	78,
	150,
	2,
	"width="78" height="150"",
	"bits" => 8,
	"channels" => 3,
	"mime" => "image/jpeg"
)
$css	=	"product"

getimagesize - [internal], line ??
include - APP/views/kosmetik/productgroup.ctp, line 202
View::_render() - CORE/cake/libs/view/view.php, line 662
View::render() - CORE/cake/libs/view/view.php, line 376
Controller::render() - CORE/cake/libs/controller/controller.php, line 799
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 230
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php5, line 88

Schimmer-Gel (Booster), Persimmon
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

Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Productmaingroup`.`name_de`, `Productmaingroup`.`id` FROM `productmaingroups` AS `Productmaingroup` WHERE `aktiv` = 1	9	9	0
2	SELECT `Productgroup`.`id`, `Productgroup`.`name_de`, `Productgroup`.`productmaingroup_id` FROM `productgroups` AS `Productgroup` WHERE aktiv = 1 AND `Productgroup`.`productmaingroup_id` IN (1, 2, 3, 4, 5, 6, 7, 8, 9) ORDER BY `productmaingroup_id` ASC, `order_no` ASC	155	155	0
3	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` = 27 LIMIT 1	1	1	0
4	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 = 27 AND Product.aktiv = 1 ORDER BY order_no, id	7	7	321
5	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(6001, 6002, 6003, 6004, 6005, 6006, 6007) AND oi2.product_id NOT IN(6001, 6002, 6003, 6004, 6005, 6006, 6007) GROUP BY product_id ORDER BY anzahl DESC LIMIT 5	5	5	15