On Wed, 10 Sep 2008 12:12:27 +0200 "Neil: esl-lounge.com" neil@esl-lounge.com wrote:
$query= "SELECT node.title, node.nid, node_counter.totalcount FROM node INNER JOIN node_counter ON node.nid = node_counter.nid WHERE uid = $uid ORDER BY totalcount DESC LIMIT 5";
which gives me the top 5 viewed pages for each user on their main /user page. It's very handy and I think I'll use it. Can someone give me a pointer to go the next step towards my initial aim, the total of a user's pageviews and then a list of the top X
select sum(node_counter.totalcount) from node inner join node_counter on node.nid = node_counter.nid where node.uid=$uid; total page viewed by a user if I interpret it right.
users on a site based on pageviews. I know I need to use SUM in the sql statement but I don't seem to be able to get the syntax right.
select uid, sum(node_counter.totalcount) from node inner join node_counter on node.nid = node_counter.nid group by node.uid order by sum(node_counter.totalcount) desc limit 5;
If I interpret it right.
The second query may be pretty expensive.