SELECT count(_id), REPLACE(REPLACE(pattern_name,'ULTRALEATHER ',''), 'SUPREEN ','') AS pattern_new
FROM textile_db WHERE hide ='0' AND upholstery = '1' AND entertainment_and_sports_arenas_mkt = '1' GROUP BY pattern_name ORDER BY pattern_name ASC
17
31
1
1 / 1
ALMOST®
ALMOST® Asheville
ALMOST® Avante
ALMOST® Buffed
ALMOST® Calf
ALMOST® Cambridge
ALMOST® Classic
ALMOST® Glove
ALMOST® Matte
ALMOST® Nappa
ALMOST® Natural
ALMOST® Ostrich
ALMOST® Pearl
ALMOST® Perforated
ALMOST® Textura
ALMOST® Vogue
Bayside
Boho
Fuse
Gulf Pro
Harbor
Pacific Pro
Pebble
Plaid Perfect
Tally
Viva
Walden
Writer's Block Salinger
Writer's Block Tolstoy
1 / 1