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

Restoration Comp

  1. Home
  2. Restoration Comp
1001-Lt.Brown-Brown.jpg
RH-1001 Lt.Brown Brown
20803-Beige-Lt.Grey.jpg
RH-20803 Beige Grey