select DISTINCT webdata_galiche.productid,webdata_galiche.handle,webdata_galiche.collection,webdata_galiche.productstyle,webdata_galiche.image,webdata_galiche.ground,webdata_galiche.border from webdata_galiche where 1=1 and webdata_galiche.collection='Orchid' group by webdata_galiche.productid,webdata_galiche.ground,webdata_galiche.border,webdata_galiche.image order by webdata_galiche.productid asc Shop Orchid | Galiche
select distinct search from globalSearch where 1=1 order by search limit 0,40

Orchid

  1. Home
  2. Orchid
CEN-6_LAVENDER_IVORY.jpg
OR-801 Lavender Ivory
CEN-8-SALMON_PINK_IVORY.jpg
OR-802 Salmon Pink Ivory
CEN-18-INDIGO_BLUE_IVORY.jpg
OR-806 INDIGO BLUE IVORY
CEN-20-BURGUNDY-RED-TEAL.jpg
OR-807 Burgundy Red Teal