traduction de la requete sql en requete query builder

SELECT a.entite, a.etat, COUNT(a.etat) as nombre_toperform, b.nombre_performed,c.nombre_incompatible FROM controlens a

LEFT JOIN ( SELECT entite,COUNT(etat) as nombre_performed from controlens WHERE etat like 'PERFORMED' GROUP BY entite, etat) b on a.entite = b.entite

LEFT JOIN ( SELECT entite,COUNT(etat) as nombre_incompatible from controlens WHERE etat like 'INCOMPATIBLE' GROUP BY entite, etat) c on a.entite = c.entite

WHERE a.etat like '%TOPERFORM%' GROUP BY a.entite, a.etat, b.nombre_performed,c.nombre_incompatible

via Chebli Mohamed