SELECT `r`.`idgrup`, `t`.`nom` FROM `research_project_has_group` AS `r`
INNER JOIN `research_group_trad` AS `t` ON r.idgrup= t.idgrup WHERE (r.idprojecte= '100') AND (t.status = 1) AND (t.idioma = 'en')
Competitive grant to help Junior Groups in hiring Technician Support for Research in Health - Projects - IMPPC