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

4-Gray
AB-201-Ivory-Red
Margot-Grey-Brown
CR-101-Zebra
EW-201-Beige
EA-250-Teal
FL-1002-Metal-Ivory
BZ-111-Ivory-Orange
J-3-Lt.Grey
710-Red-Beige
sPT-303-Carbon
MN-206-Naturale
SY-604-Grey-Blue
KM-105-Natural
10573C-Natural
SC-10-Ivory-Natural
Block-Silver-Grey
Metallic-Squares-Gold-Silver
175-Black-Beige
5082-Blue-Ivory
HW5126B-White
Palms-Camel
TK-007-Beige-Brown