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

Arabica

AB-201-Ivory-Red
AB-202-Navy-Red
AB-203-Camel-Lt.Blue
T-2B-Blue-Camel
T-2-Blue-Red
T-11-Multi
AB-206-Navy-Gold
T-9-Ivory-Red
M-20-Ivory-Ivory
M-19-Red-Black
T-3-Lt.Blue-Brown