I don't see firstname and lastname in the SQL table '..._list_subscriber'

[Traffiix]

...But I do see them in the subscriber list in MW.

Can someone advise if this is the correct table to d/l the entire list to csv?

Thanks in advance.

 

[twisted1919]

They're stored in list_field_value which is connected to list_field.

 

[Traffiix]

Thanks appreciate the quick response, now I need to know how to export them to a csv, 1 row firstname, lastname, email, at a time please?

 

[twisted1919]

In MailWizz you have various export options which can help you do this.
If you want to do it directly from mysql, that's more difficult, we can't really help with that, you'll have to join from the subscriber table to these two tables and alias the field name as a column with its value.

 

[Traffiix]

No problem, I found the Tools>Export>CSV option that will suffice for now - thanks all the same.