Is there any way to find active members of week or month?

asked 02 Jan '11, 14:13

Hameds's gravatar image

Hameds
271141720
accept rate: 50%


I think there is not any way to find the active member.

link

answered 04 Jan '11, 02:05

amit's gravatar image

amit
163
accept rate: 0%

edited 04 Jan '11, 02:06

This will order by last activity in the given period:

SELECT count(*), author_id,added_at FROM forum_node where added_at > '2011-01-01' and added_at < '2011-01-08' group by author_id order by added_at desc

This will order by most posts in the given period:

SELECT count(*), author_id,added_at FROM forum_node where added_at > '2011-01-01' and added_at < '2011-01-08' group by author_id order by added_at desc

link

answered 07 Jan '11, 15:23

Vijay%20Chauhan's gravatar image


105138
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×51

Asked: 02 Jan '11, 14:13

Seen: 949 times

Last updated: 07 Jan '11, 15:23

powered by OSQA