SELECT count(_id), REPLACE(REPLACE(pattern_name,'ULTRALEATHER ',''), 'SUPREEN ','') AS pattern_new
FROM textile_db WHERE hide ='0' AND upholstery = '1'
AND product_type IN ('Leather')
25
1
1
Copenhagen
Black COPEN01
Copenhagen
Slate COPEN02
Copenhagen
Dove COPEN03
Copenhagen
Cloud COPEN05
Copenhagen
Winter COPEN06
Copenhagen
Off White COPEN07
Copenhagen
Shiitake COPEN10
Copenhagen
Wheat COPEN14
Copenhagen
Butterscotch COPEN16
Copenhagen
Spice COPEN17
Copenhagen
Cayenne COPEN18
Copenhagen
Port COPEN20
Copenhagen
Oyster COPEN21
Copenhagen
Cashmere COPEN23
Copenhagen
Sorrel Brown COPEN29
Copenhagen
Dark Chocolate COPEN30
Copenhagen
Blue Spruce COPEN50
Copenhagen
Ultramarine COPEN51
Copenhagen
Cobalt COPEN52
Copenhagen
Horizon COPEN53
Copenhagen
Pine Needles COPEN60
Copenhagen
Pumpkin COPEN65
Copenhagen
Umbria Red COPEN71
Copenhagen
Red Pepper COPEN72
Copenhagen
Ladybug COPEN74