$consulta = "SELECT mail, DATE_FORMAT(date_expire, '%Y-%m-%d') AS nfecha, selector, firmname FROM dimeq_listings WHERE membership = 1 AND nfecha = DATE_SUB(CURDATE(),INTERVAL 15 DAY)";