Select Top 1 A.*,B.SR_CnName As MSortName,C.SR_CnName As SSortName,B.SR_PyName As MSortPiny,C.SR_PyName As SSortPiny,(Select Count(ID) From [CY_VideoLink] Where VDL_VDID=A.ID) As LinkCount From [CY_Video] A  Left Outer Join [CY_Sort] B On A.VD_MID=B.ID Left Outer Join [CY_Sort] C On A.VD_SID=C.ID Where A.ID='2582' And A.VD_StateNum  In (7,8,9) <br /><br />错误提示：Core.Execute<br />错误来源：ADODB.Connection<br />错误描述：对象关闭时，不允许操作。<br />