select l.linknum, l.catagory, l.name, l.link, l.views, count(r.linknum) as RATECOUNT, sum(r.rating)
from links l, ratings r
where l.linknum=r.linknum and l.catagory=64 
group by l.linknum, l.catagory 
order by l.linknum desc limit 5;

select linknum, catagory, name, link, date_entered
    from links where catagory in (64)
    order by linknum desc limit 5;

mysql> select l.linknum, l.catagory, l.name, l.link, l.views, count(r.linknum) as RATECOUNT, sum(r.rating)
    -> from links l, ratings r
    -> where l.linknum in (select linknum from links where catagory=64 order by linknum desc limit 5)
    -> group by l.linknum;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id:    2673
Current database: xxxx

ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'