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

Salisbury

SAV-1_GRAY
SAV-2_IVORY_GRAY
SAV-3_RED_IVORY
SAV-4_GRAY_GOLD
SAV-5_GRAY_BLUE
SAV-6_GRAY_RED
SAV-7_IVORY_GRAY
SAV-8_GRAY_BLUE