how to extract email IDs ?

[tiptop]

How to extract email IDs from phpmyadmin sql command line ?

I need email ID of all customers who are subscribing to emailing (have not opt out or marketing emails  ) and account is not closed

[sentq]

SELECT `email` FROM `tblclients` WHERE `emailoptout` = '0' AND `status` != 'Closed';

 

[tiptop]

3 hours ago, sentq said:

SELECT `email` FROM `tblclients` WHERE `emailoptout` = '0' AND `status` != 'Closed';

what will be query to extract emails of clients who are affiliates ?

 

[sentq]

to get emails of affiliates where their account aren't closed use:

SELECT `tblclients`.`email` FROM `tblclients` JOIN `tblaffiliates` ON (`tblaffiliates`.`clientid` = `tblclients`.`id`) WHERE `tblclients`.`status` != 'Closed' ;