执行SQL出现错误

-2147467259超出系统资源。
出错sql语句如下:
select top 1 CID,C_Title,S_Folder,C_GID,C_Folder,C_FileName,C_link,C_PageName,S_Type,C_pic from zzz_Content as a,zzz_Sort as b where C_sid=sid and C_OnOff=1 and CID<1198 and C_sid=6 order by CID desc