SELECT count(_id), REPLACE(REPLACE(pattern_name,'ULTRALEATHER ',''), 'SUPREEN ','') AS pattern_new
FROM textile_db WHERE hide ='0' AND upholstery = '1' AND senior_living_mkt = '1' GROUP BY pattern_name ORDER BY pattern_name ASC
17
34
1
Sorry, we couldn't find any results.
Try altering your search to find results from our available textile lines.
1 / 1