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