Select first 1
substring(SPATH from 6 for 200) Path , '/' || SUBSTRING(sorgfilename from 1 for 1) || '/' || SUBSTRING(sorgfilename from 2 for 1) || '/' || sorgfilename dest,
sgroup , MULTIMEDIA.WMMID

FROM
MULTIMEDIA join 
Groups on (wrefid = wgroupid) 

where 
WREFID = <@WGROUPID@> and 
STYPE = 'GROUP' and 
(SPATH like 'link:%' or SPATH like 'file:%') and 
(SGROUP = 'categories_image')
order by MULTIMEDIA.WMMID desc
