hottopic.tpl

动网8.2SQL商业版[20081021]版

query|||7200|||bbs|||select top 10  PostUserName,Title,Topicid,Boardid,Dateandtime,Topicid as Topicid2,Hits,Expression,LastPost from [dv_topic] where boardid not in(444,777) and Datediff(day, DateAndTime, GetDate()) <= 30 order by Child desc,topicid desc|||<ul>|||<LI><A href="dispbbs.asp?boardid={$Boardid}&amp;id={$ID}">{$Topic}</A></LI>|||</ul>|||10$4$1$$1$0$2|||28|||2