Query for user mail subscription group

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cykelmyggen
    Member
    • Oct 2006
    • 73
    • 3.5.x

    [Forum] Query for user mail subscription group

    HI
    Could someone show me a query to filter out the latest 1000 member on my forum in a mail list which could be imported into Mailchimp? That is - if it could be done?
    http://www.boggnasker.dk/vbforums/
  • Hartmut
    Senior Member
    • Nov 2007
    • 2870
    • 4.2.x

    #2
    Not that easy i guess, is there a special format which the list for Mailchimp needs to have ot only the email addresses?
    No private support, only PM me when I ask for it. Support in the forums only.

    Comment

    • BirdOPrey5
      Senior Member
      • Jul 2008
      • 9613
      • 5.6.3

      #3
      You want the emails of the most recent 1000 registered users?

      Code:
      SELECT email FROM user WHERE usergroupid = 2 ORDER BY userid DESC LIMIT 1000
      You would have to export it via phpmyadmin into some format mailchimp can use, no idea what they need.

      If you have multiple primary usergroups members could be members of then you can do:

      Code:
      SELECT email FROM user WHERE usergroupid IN (2, 11, 12) ORDER BY userid DESC LIMIT 1000
      That would pull from usergroups 2, 11, and 12

      Comment

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