Erreur SQL !
SELECT *,annonceurs.nom as nom, '100' as score from annonces,annonceurs WHERE annonceur=refannonceur and annonceur in (select refannonceur from annonceurs where nom = 'Coface') ;