How to select last records from related table?

The way I (finally) solved the problem was as follows:

SELECT 
Negociacao.id,Cliente.nome,NegociacaoStatus.nome,NegociacaoContato.created,DATEDIFF(NOW(),NegociacaoContato.created) AS dias
FROM negociacoes AS Negociacao
LEFT JOIN 
    (
        SELECT NC.negociacao_id,NC.created,max(NC.id) AS id 
        FROM negociacao_contatos AS NC 
        GROUP BY negociacao_id
    ) AS NegociacaoContato2
ON NegociacaoContato2.negociacao_id = Negociacao.id
LEFT JOIN negociacao_status AS NegociacaoStatus 
ON Negociacao.negociacao_status_id = NegociacaoStatus.id
LEFT JOIN clientes AS Cliente
ON Negociacao.cliente_id = Cliente.id
LEFT JOIN negociacao_contatos AS NegociacaoContato
ON NegociacaoContato.id = NegociacaoContato2.id
WHERE NegociacaoStatus.finaliza != "Y"
AND Negociacao.consultor_id = 23
AND Negociacao.ativo = "Y"
AND NegociacaoStatus.alerta_usuario = "Y"
AND datediff(now(),NegociacaoContato.created) >= NegociacaoStatus.prazo_alerta
ORDER BY dias DESC

Thank you all for the contributions. Through them I was able to reach this result.

If I understand correctly it will be something like this:

Aquery:

SELECTCOUNT(*)ascountFROMnegociacao_statusasnsINNERJOINnegociacoesasnonn.negociacoes_status_id=ns.idINNERJOINnegociacao_contatosasnconnc.negociacoes_id=n.idWHEREns.alerta_usuario="Y" AND nc.created > ns.prazo_alerta ;

Following the same settings of Jorge B. tables without using JOIN would look like this:

    select count(*) 
    from negociacoes n, negociacao_contatos nc, negociacao_status ns       
    where ns.id = n.negociacoes_status_id 
      and n.id = nc.negociacoes_id 
      and ns.alerta_usuario='Y' 
      and nc.created > ns.prazo_alerta;

Whereas the tables look like this:

CREATE TABLE 'negociacao_contatos' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'created' varchar(45) DEFAULT NULL,
  'negociacoes_id' int(11) DEFAULT NULL,
  PRIMARY KEY ('id')
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

CREATE TABLE 'negociacao_status' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'alerta_usuario' varchar(45) DEFAULT NULL,
  'prazo_alerta' varchar(45) DEFAULT NULL,
  PRIMARY KEY ('id')
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

CREATE TABLE 'negociacoes' (
  'id' int(11) NOT NULL AUTO_INCREMENT,
  'negociacoes_status_id' int(11) DEFAULT NULL,
  PRIMARY KEY ('id')
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;