error

SELECT * FROM(SELECT ROW_NUMBER() OVER (ORDER BY A.DTime) AS [ORDER],A.*,B.Npath AS sThumbnail FROM xbls_INFO A LEFT JOIN xbls_ATTACHMENT B ON B.infoID=A.ID AND B.classID=A.ClassID AND B.fieldID=17 AND B.tableID=1 AND B.siteID=0 WHERE A.ClassID={#Sm:Id/} AND A.Id <> 306 AND A.Audit=2 AND A.DTime > CONVERT(datetime, '2021-01-29 15:02:41'))_TNZ WHERE _TNZ.[ORDER] > 0 AND _TNZ.[ORDER]<= 1

返回首页