Can't find subscribers' emails in the database

I use the Subscribe by Email plugin to get the email addresses of my blog readers. I am using a multisite install and I'm trying to find the email addresses of my subscribers in the database for the blog with an id of 166. Do you know where I can find them?

  • Majid

    Hey Samuel !

    I hope you are doing great today,

    The subscribers are created as a custom post type, which means that you will find them under "posts" table. with the post_title as the email as you can see here,

    in the case of a multisite, WordPress add a the ID of the blog to each table, your wp_posts table should look something like this:
    [table_prefix]_166_posts
    and you can get the table prefix from the wp-config.php file, mine is just "wp_"

    I hope this helps.

    Cheers,
    Majid

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.