顺应职教浪潮,构建职教行业信息门户网站
打赏榜
分享榜
热评榜
点击榜
{-{0,<< select top 50 A.* from [_Life] as A inner join [_LifeShare] as B on A.ID=B.FID where A.Enable=1 and B.ID in (select max(ID) from [_LifeShare] group by FID) order by B.ShareTime desc>>,
[Title][Contents|100|..]
[Title]
,}}
{-{0,<< select top 50 A.* from [_Life] as A inner join [_LifeComment] as B on A.id=B.FID where A.Enable=1 and B.Enable=1 and B.id in(select max(id) from _LifeComment group by FID) order by B.InsertTime desc>>,
[Title][Contents|100|..]
[Title]
,}}
{-{0,<< select top 50 *,(select count(*) from _LifeClick where FID=A.id and ClickTime between convert(varchar(10),getdate()-3,120) and convert(varchar(10),getdate()+1,120)) as count2 from [_Life] as A where Enable=1 order by count2 desc>>,
[Title][Contents|100|..]
[Title]
,}}
本网站由职教网提供技术
首页
红人堂
发布
我发的
更多
统计代码