[Exception: 无法绑定由多个部分组成的标识符 "a.id"。 SELECT TOP 20 * FROM (select a.*,b.nick_name,b.avatar FROM view_channel_shequ as a inner join dt_users as b on a.user_name=b.user_name where 1=1 and a.status=0 and (a.title like '%汽车%' or nick_name like '%汽车%' or a.user_name like '%汽车%' or tags like '%汽车%')) AS T ORDER BY (select top 1 add_time from dt_article_comment where article_id=a.id and is_lock=0 and channel_id=9 order by add_time desc) desc ]
XCWL.DBUtility.DbHelperSQL.Query(String SQLString) in D:\xcwl_All\xcwl\XCWL.Web\XCWL.DBUtility\DbHelperSQL.cs:552
XCWL.DAL.article.GetList(String channel_name, Int32 category_id, Int32 pageSize, Int32 pageIndex, String strWhere, String filedOrder, Int32& recordCount, String fields) +585
XCWL.BLL.article.GetList(String channel_name, Int32 category_id, Int32 pageIndex, String strWhere, String filedOrder, Int32& recordCount, Int32& pageSize) +82
XCWL.Web.shequ_list.Page_Load(Object sender, EventArgs e) +871
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.Web.UI.Control.OnLoad(EventArgs e) +95
System.Web.UI.Control.LoadRecursive() +59
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +678
|