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')
46
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

Stockholm
Pepper STOCK01

Stockholm
Stormy Sea STOCK02A

Stockholm
Stucco STOCK03A

Stockholm
Sapphire STOCK04

Stockholm
Blueberry STOCK05A

Stockholm
Bluestone STOCK06A

Stockholm
Balsam STOCK07

Stockholm
Hunter Green STOCK08A

Stockholm
Avocado STOCK09A

Stockholm
Ebony STOCK10

Stockholm
Chocolate STOCK11

Stockholm
Spiced Cider STOCK12

Stockholm
Garnet STOCK14A

Stockholm
Poppy STOCK16

Stockholm
Mandarin STOCK17A

Stockholm
Amber STOCK18A

Stockholm
Sunflower STOCK19

Stockholm
Brunswick STOCK20

Stockholm
Maple STOCK21

Stockholm
Cameo STOCK22

Stockholm
Sand STOCK23