Ver originalSELECT u.id, u.empresa, u.mail, u.url, u.telefono, u.zona, u.nivel, COUNT( DISTINCT m.id ) AS Machines FROM m_usuarios u LEFT JOIN m_maquinas m ON m.id_dis = u.id WHERE u.eliminado =0 and m.eliminado=0 GROUP BY u.id