select distinct search from globalSearch where 1=1 order by search limit 0,40

Mantra

Magic-Gold-Rust
Magic-Grey-Blue
Magic-Grey-Beige
Damask-Grey
GL-03-Silver
KC-731-Multi
MN-200-Indigo
MN-200-Lt.Blue
MN-200-Natural
MN-201-Beige
9714-C-Green
MN-202-Natural
MN-203-Natural
MN-203-SkyBlue
MN-203-Turquoise
MN-204-Navy1
MN-204-Silver-Blue
MN-206-Naturale
9863-E-Natural-Blue
MN-207-Blue
MN-208-Gold
MN-208-Ivory-Natural
MN-208-Natural
MN-209-Beige-Pink
MN-209-Gold-SkyBlue
MN-209-Natural-Green
9844-D-Sky-Blue
MN-210-Dk.Grey
MN-211-Natural-Gold
9938-Silver
MN-213-Grey-Black
MN-213-Lt.Blue
MN-213-Silver-Taupe
MN-219-Beige-Green
MN-220-Lt.Green
9978-A-Natural
MN-220-Silver-Beige
MN-226-Ivory-Silver
MN-226-Wheat
MN-230-Indigo
MN-232-Green
MN-234-Grey-Silver
10092-D-Camel
MN-236-Charcoal
MN-237-Charcoal
MN-238-Silver-Blue
MN-239-Grey-Blue
MN-239-Grey-RoyalBlue
MN-240-Aqua
MN-240-Blue
MN-241-Brown
10046-D-Lt.Blue
MN-242-Ivory-Green
MN-242-Silver-Blue
MN-243-Carbon-Black
MN-243-Charcoal
MN-243-Grey-Metallic
MN-243-Silver-Lt.Blue
MN-244-Silver-Blue
MN-245-Grey
MN-246-Green
MN-246-Ivory
MN-246-Silver
MN-248-Natrual-Storm
NP-10-Blue-Grey
Nepal-3-Grey
1162-Silver-Lilac
MD-855-Grey-Lt.Lilac
MD-854-Charcoal-Silver
MD-854-Silver-NavyBlue
TI-618-Silver-EggPlant
A-21-Silver-Blue
A-21-Silver-Green
A-21-Silver-Lilac
TI-664-Blue
A-22-Green
1189-WH-Silver-Silver
MN-267-Ivory-Multi
10282-C-Ivory
MN-269-Ivory-Lt.Blue
MN-273-Ivory,MN-273-Ivory-C1
10338-D-Charcoal
MN-279-Blue-Granite
MN-288-Grey-Black
MN-288-SmokeBlue
MN-290-Silver-Lt.Blue
MN-297-Lt.Blue-Natural
MN-298-Ivory
MN-301-Beige
MN-304-Brown
MN-307-Ivory-Gold
MN-308-Silver-Grey
MN-309-Ivory-Grey
MN-310-Blue
MN-315-Ivory
MN-317-Dk.Grey
10740-A3-Fog
MN-317-Ivory-Silver
MN-317-Natural
MN-318-Green
MN-322-Fog
10496-B-Beige
10496-G-Ivory
MN-324-Ivory-Silver
MN-325-Charcoal
MN-325-Ivory-Aqua
MN-326-Carbone
MN-326-Grey-Lt.Blue
MN-326-Ivory-Aqua
MN-326-Ivory-Gold
MN-326-Tonal-Brown
MN-326-Tonal-Grey
10754-B-Carbon
MN-327-Fog
MN-327-Ivory
MN-327-Stone
MN-327-Taupe
MN-328-Carbon
MN-328-Stone
MN-328-Taupe
MN-329-Carbon
MN-329-Fog
MN-330-Fog
MN-330-Ivory-Silver
MN-331-Grey-Ivory
MN-331-Ivory-Aqua
MN-331-Ivory-Charcoal
MN-331-Ivory-Grey
MN-339-Beige
MN-342-Ivory-Grey
MN-343-Beige-Rust
MN-346-Ivory-Silver
MN-348-Beige
MN-349-Heather-Grey
MN-350-Beige
MN-350-Grey
MN-350-Grey-Dk.Grey
10748-B-Ivory-Silver
10750-B-Carbon
MN-351-Fog
MN-351-Grey
MN-351-Ivory
MN-353-Sea-Green
MN-354-Ivory-Black
MN-356-Beige-Camel
10064-L-Camel-Beige
MN-356-Mist
MN-356-Stone
10174-A-Black-Taupe
10308-A Beige-Green
MN-361-Green
10313-B-Green-Blue
10558-B-Charcoal
MN-367-Beige
MN-367-Ivory
10562-B-Silver
MN-368-Slate-Ivory
MN-369-Stone
10755-B-Carbon
10755-D-Fog
MN-370-Grey
MN-370-Ivory
MN-370-Stone
MN-370-Taupe
6045-L-Natural-Gold
7089-F-Ivory
7227-F-Fog
MN-378-Pearl-Grey
9493-F-Ivory
MN-380-Grey
9614-A-Natural
9624-B-Charcoal
9689-B-Blue
MN-384-Blue
AP-60-Solid-Grey
Franklin-A-Lt.Blue
MN-388-Ivory-Grey
MN-388-Silver-Grey
10580-Lt.Brown
9269-A-Camel
MN-391-Grey
MN-391-Lt.Silver
MN-392-Gold
MN-392-Natural
MN-393-Magenta-Multi
MN-394-Silver-Blue
MN-395-Ivory-Black
MN-396-Silver-Blue
MN-397-Washed-Black
MN-398-Grey-Charcoal
MN-399-Sage
MN-400-Black
MN-401-Natural-Green
MN-402-Grey-Rust
MN-403-Silver-Grey
MN-404-Ivory-Black
MN-405-Beige
MN-405-Blue
MN-406-Stone
MN-408-Ivory-Silver
MN-409-Ivory-Silver
sPT-201-Grey
10132-B-Beige-Green
9980-A-Grey-Blue
PW-918-Grey