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