select top 10 a.*,S_Folder,S_GID,C_Folder,C_FileName,S_Name,S_enname from zzz_Content as a,zzz_Sort as b where sid=C_sid and ','+S_path+',' like '%,5,%' and DateDiff('d',C_AddTime,'2022/8/12 下午 11:36:27')>=0 and C_OnOff=1 and ispic=1 order by IsTop desc,isgood desc,C_order asc,C_AddTime desc,CID desc