错误号:12142
错误原因:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY lxkj_archives.Order ASC, lxkj_archives.ID DESC ) a,( select @rowNO :=0 ' at line 1
错误SQL语句:
select * from ( select (@rowNO := @rowNo+1) AS rowno, ID, Title_Ch, a.Order from ( SELECT ID, Title_Ch, lxkj_archives.Order FROM lxkj_archives where ViewFlagCh and SortID= ORDER BY lxkj_archives.Order ASC, lxkj_archives.ID DESC ) a,( select @rowNO :=0 ) b ) c WHERE rowno = -1