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

Bellisimo

BLS-1001-Ivory-Grey
BLS-1002-Blue-Ivory
BLS-1002-Ivory-Red
BLS-1002-Red-Blue
BLS-1003-Red-Ivory
BLS-1004-Blue-Red
BLS-1004-Red-Blue
BLS-1005-Blue
BLS-1005-Red
BLS-1006-Blue-Ivory
BLS-1006-Red-Ivory