SELECT *, REPLACE(REPLACE(pattern_name,'ULTRALEATHER ',''), 'SUPREEN ','') AS pattern_new FROM `textile_db` WHERE hide ='0' AND upholstery = '1'
AND product_type IN ('Leather')
GROUP BY pattern_new ORDER BY pattern_new ASC LIMIT 0, 96
Copenhagen
Stockholm