SELECT c.firstname, c.lastname, c.email FROM ps_customer c INNER JOIN ps_newsbuild_customer nc WHERE c.newsletter = 1 AND c.id_customer = nc.id_customer AND nc.news = 0

SELECT value WHERE X=X and Z=Z and T=T

SELECT c.firstname, c.lastname, c.email FROM ps_customer c INNER JOIN ps_newsbuild_customer nc WHERE c.newsletter = 1 AND nc.news = 0

Array (
[0] => Array ( [firstname] => John [lastname] => DOE [email] => zz@gmail.com )
[1] => Array ( [firstname] => jaimy [lastname] => DOE [email] => tt@skynet.be )
[2] => Array ( [firstname] => John [lastname] => DOE [email] => zz@gmail.com )
[3] => Array ( [firstname] => jaimy [lastname] => DOE[email] => tt@skynet.be ) )