Cores e Padrões

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 = 7 AND pat.stage = 0  AND  col.name = 'X Series'
		GROUP BY p.patternCode 
		ORDER BY p.orderinRegion ASC

Dark Jet Black

019X

Dark Pewter

093X

Dark Galaxy Mist

311X

Dark Rio Grande Stone

503X

Dark Starry Starry Night

508XS

Dark Chocolate

091X

Dark Raven Boulder

810X

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 = 7 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)