{-{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|..]

,}}

{-{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|..]

,}}

{-{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|..]

,}}