Count linkid

SELECT uli.title, li.link, uli.tags, LEFT (uli.dateAdded, 20) AS dateAdded, uli.topic, uli.rating, uli.visitedRate, uli.comment, uli.linkid AS linkID, (select count(uliCount.linkid) from userlinkinfo as uliCount where uliCount.linkid = uli.linkid group by uliCount.linkid) as counter FROM userLinkInfo AS uli, linkinfo as li WHERE (uli.userid =@userid) and uli.linkid = li.linkid ORDER BY uli.dateAdded DESC

powered by performancing firefox