select count(r.id_receta) total, (p.id_expediente), sum(if(p.sexo='M', 1, 0) ) M from receta r LEFT JOIN persona p ON r.id_expediente=p.id_expediente group by p.id_expediente