Select  a.*,substring(e.IMP_EXTID from 6 for 10) MASTER,
 f.IMP_EXTID   STOCKITEM,
substring(d.IMP_EXTID from 6 for 10) DETAIL
FROM STOCKWEBOPTIONS a
join groups b on a.WOPTIONID = b.WGROUPID 
join groups c on b.WPARENTGROUP2ID = c.WGROUPID
Join IMP_LINK d on b.WGROUPID = d.WGROUPID and 
d.IMP_SOURCEID = <@SOURCEID@> and d.IMP_EXTID like 'OPGD:%'
Join IMP_LINK e on c.WGROUPID = e.WGROUPID and 
e.IMP_SOURCEID = <@SOURCEID@> 
left join IMP_LINK f on a.WLINKEDITEM = f.WSTOCKID and 
f.IMP_SOURCEID = <@SOURCEID@>  
where a.WStockid = <@WSTOCKID@>
