Announcement

Collapse
No announcement yet.

Need help with an SQL Query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Need help with an SQL Query

    I am looking for a query that would give me a list of members that have started a topic in a particular forum. I found it a few years back but after numerous searches I can't locate it anymore. Thank you in advance.

  • #2
    Try this...
    Code:
    SELECT
        postusername AS starter,
        COUNT(threadid) AS started
    FROM
        thread
    WHERE
     forumid = 8
    GROUP BY
        starter
    ORDER BY
        started DESC
    Change the 8 to whatever you need.
    Lats...

    Comment


    • #3
      Originally posted by Lats View Post
      Try this...
      Code:
      SELECT
          postusername AS starter,
          COUNT(threadid) AS started
      FROM
          thread
      WHERE
       forumid = 8
      GROUP BY
          starter
      ORDER BY
          started DESC
      Change the 8 to whatever you need.
      That's perfect, thank you!

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X