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

Harmony

BZ-111-Ivory-Orange
1510-Ivory-Grey
1643-Ivory-Grey
SA1-White-Beige
1060-1440-Lt.Blue-8x10
1100-359-Natural-Lt.Grey-9x12
503-Lt.Blue-Blue
316910-Harmony
1387-Dark-Grey-Black
HR-380-Grey-Dk.Grey
HR-381-Blue-Lt.Blue
1470-L-White
1568-Grey-Black
316904-Harmony
HR-399-Grey-Blue
1467-Natural-White
316900-Harmony
316901-Harmony
316898-Harmony
316903-Harmony
316896-Harmony
316913-Harmony
2093-Grey-Ivory
316907-Harmony
2263-Lt.Blue
2265-Grey
2307-Lt.Blue
2323-White
2359-Grey
2468-White-Multi
4601-Ivory-Black
4601-Ivory-White
541-D-Grey-Black
541-D-White-Black
541-L-White-Grey
DJ-1031-Ivory-white
Relay-144-White
10553-A-Ivory