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

from Newest questions tagged laravel-5 - Stack Overflow http://bit.ly/2DEQj5k
via IFTTT