sql="select F.forum,F.frm_id,T.tpc_id,T.topic,T.hit, date_format(lastdate,'%d.%m.%y-%H:%i') as lastdate , " +
                " date_format(lastdate,'%Y%m%d%H%i') as sort ,"+
                " T.lastuser, count(msg_id) as totalpost "+
                " from t_topics T,t_message M, t_forum F  where tstatus < 1 "+
                " and "+
                " T.tpc_id=M.tpc_id and T.frm_id=F.frm_id  group BY T.tpc_id order by sort desc LIMIT 0,30 ";