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
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
1 / 1