select if(instr(chrCorrected,'®')=0 or chrCorrected is null,chrKeyword,chrCorrected) as keyword,  round(sum(lngSearches)) as s, round(sum(lngClickthrus)) as c, sum(curYield) as y, curAverageYield, bMark from tmtmCategoryKeyword ck inner join tblKeyword on ck.idfKeywordID=idsKeywordID left outer join kdmreports.tblKeywordPool kp on idsKeywordID=kp.idfKeywordID and kp.idfPageID=121391 and (dtmDate>='2011-09-30') where idfCategoryID=3056083 group by ck.idfKeywordID order by y desc