http://ba-k.com/showthread.php?t=179689



SELECT COUNT(w_pressupostosout.id_outsource), w_outsources.nom_outsource
FROM w_projectes INNER JOIN w_pressupostosout
ON w_pressupostosout.id_projecte = w_projectes.id_projecte INNER JOIN w_outsources
ON w_outsources.id_outsource = w_pressupostosout.id_outsource
WHERE w_pressupostosout.estat IN (3,4,5)
GROUP BY w_outsources.id_outsource;