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