【动易】通用信息列表

通用信息列表

'

''

AND CM.LinkType = 0

AND SI.SpecialID IN ()

AND CM.ModelID IN ()

AND CM.GeneralID IN ()

AND CM.EliteLevel >=

AND CM.Priority >=

AND CM.Hits >=

AND CM.Day Hits >=

AND CM.WeekHits >=

AND CM.MonthHits >=

AND DATEDIFF(d,CM.UpdateTime,GETDATE()) <=

AND CM.DefaultPicUrl != ''''

AND CM.Inputer = ''''

AND CM.Editor = ''''

AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) >= '''') AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) <= '''')

AND IncludePic LIKE ''%[图文]%''

AND CM.DefaultPicUrl != ''

AND CM.Inputer = ''

AND CM.Editor = ''

AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) >= '') AND (CONVERT(varchar(10) , CM.UpdateTime, 120 ) <= '')

AND IncludePic LIKE '%[图文]%'

titleLength="" linkOpenType="" nodes="" displayCommentLink="" display Editor="" displayPropertyPrefix="" display DateTime="" displayTitlePrefix="" displayHits="" display Tips="" displayInputer="" displayNodeName="" display HotSign="" displayNewSign="" optionalExtend=""

通用信息列表_

CM.GeneralID DESC

CM.GeneralID ASC

CM.UpdateTime DESC,CM.GeneralID DESC

CM.UpdateTime ASC,CM.GeneralID DESC

CM.Hits DESC,CM.GeneralID DESC

CM.Hits ASC,CM.GeneralID DESC

https://www.360docs.net/doc/5c5710739.html,mentAudited DESC,CM.GeneralID DESC

https://www.360docs.net/doc/5c5710739.html,mentAudited ASC,,CM.GeneralID DESC

CM.Day Hits DESC,CM.GeneralID DESC

CM.Day Hi ts ASC,CM.GeneralID DESC

CM.WeekHits DESC,CM.GeneralID DESC

CM.WeekHits ASC,CM.GeneralID DESC

CM.MonthHits DESC,CM.GeneralID DESC

CM.MonthHits ASC,CM.GeneralID DESC

CM.EliteLevel DESC,CM.GeneralID DESC

CM.EliteLevel ASC,CM.GeneralID DESC

CM.Priority DESC,CM.GeneralID DESC

CM.Priority ASC,CM.GeneralID DESC

CM.Hits DESC,CM.UpdateTime DESC,CM.GeneralID DESC CM.EliteLevel DESC,CM.UpdateTime DESC,CM.GeneralID DESC CM.Priority DESC,CM.UpdateTime DESC,CM.GeneralID DESC https://www.360docs.net/doc/5c5710739.html,mentAudited DESC,CM.UpdateTime DESC,CM.GeneralID DESC CM.UpdateTime DESC,CM.GeneralID DESC

,

0

INNER JOIN PE_SpecialInfos SI ON (CM.ItemID = SI.GeneralID)

{https://www.360docs.net/doc/5c5710739.html,bel id=""

queryCond="EXEC [dbo].[PR_Common_PagingLarge] 'PE_CommonModel CM ', 'CM.GeneralID', '*', @pagesize, @startrow,

'CM.Status = 99 AND CM.NodeID IN ()

',

'', '' ;"

queryCount="SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM WHERE CM.Status = 99 AND CM.NodeID IN ()

"

page="true" pagesize="" urlpage="true" /}

{https://www.360docs.net/doc/5c5710739.html,bel id=""

queryCond="SELECT TOP * FROM PE_CommonModel CM WHERE CM.Status = 99 AND CM.NodeID IN ()

ORDER BY " page="false" /}

{https://www.360docs.net/doc/5c5710739.html,bel id="" queryCond="EXEC [dbo].[PR_Common_PagingLarge] 'PE_CommonModel CM ', 'CM.GeneralID', '*', @pagesize, @startrow, 'CM.Status = 99

', '', '' ;" queryCount="SELECT COUNT (CM.ItemID) FROM PE_CommonModel CM WHERE

CM.Status = 99

" page="true" pagesize="" urlpage="true" /}

{https://www.360docs.net/doc/5c5710739.html,bel id="" queryCond="SELECT TOP * FROM PE_CommonModel CM WHERE CM.Status = 99

ORDER BY " page="false" /}

指定了不存在的栏目ID或栏目数组！