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='Rose' group by webdata_galiche.productid,webdata_galiche.ground,webdata_galiche.border,webdata_galiche.image order by webdata_galiche.productid asc Shop Rose | Galiche
select distinct search from globalSearch where 1=1 order by search limit 0,40

Rose

  1. Home
  2. Rose
CAM-3-DOVEGRAY_01.jpg
RO-503 DOVE GRAY
CAM-12-BEIGE_01.jpg
RO-507 BEIGE
CAM-47-BLUE_01.jpg
RO-518 BLUE
CAM-49-SILVER-01.jpg
RO-519 SILVER