FARBEN UND MUSTER

SELECT p.patternCode, pat.name, siz.name Size, p.regionID, col.name collection, 
			GROUP_CONCAT(DISTINCT car.name ORDER BY car.name) characteristics, 
			GROUP_CONCAT(DISTINCT color.name ORDER BY color.name) colors 
		FROM colors_patterns_regions p 
		INNER JOIN colors_characteristic_group c ON p.patternCode = c.code AND c.region = p.regionID
		INNER JOIN colors_region r ON r.id = p.regionID 
		INNER JOIN colors_characteristic car ON car.id = c.characteristic 
		INNER JOIN colors_collections col ON c.collection = col.id 
		INNER JOIN colors_color_group cc ON cc.code = c.code AND c.region = cc.region
		INNER JOIN colors_color color ON color.id = cc.color 
		INNER JOIN colors_pattern pat ON pat.code = c.code 
		INNER JOIN colors_size siz ON p.regionSize = siz.id
		WHERE p.regionID = 8 AND pat.stage = 0  AND  col.name = 'X Series'
		GROUP BY p.patternCode 
		ORDER BY p.orderinRegion ASC

Dark Jet Black

019X

SELECT p.patternCode, pat.name, siz.name Size, p.regionID, col.name collection, 
			GROUP_CONCAT(DISTINCT car.name ORDER BY car.name) characteristics, 
			GROUP_CONCAT(DISTINCT color.name ORDER BY color.name) colors 
		FROM colors_patterns_regions p 
		INNER JOIN colors_characteristic_group c ON p.patternCode = c.code AND c.region = p.regionID
		INNER JOIN colors_region r ON r.id = p.regionID 
		INNER JOIN colors_characteristic car ON car.id = c.characteristic 
		INNER JOIN colors_collections col ON c.collection = col.id 
		INNER JOIN colors_color_group cc ON cc.code = c.code AND c.region = cc.region
		INNER JOIN colors_color color ON color.id = cc.color 
		INNER JOIN colors_pattern pat ON pat.code = c.code 
		INNER JOIN colors_size siz ON p.regionSize = siz.id
		WHERE p.regionID = 8 AND pat.stage = 0  AND  col.name = 'Sinks & Bowls'
		GROUP BY p.patternCode 
		ORDER BY p.orderinRegion ASC

Snow White

BS110(033)

Snow White

BS115(033)