I have been using SugarCRM 4.5.1 with the SQL 2005, while navigating through the list of members of a team, the team module crahes, becuase the query being formed to get the new page is borken, the query being formed is

SELECT TOP 10 * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY teams.id) AS row_number, users.id , users_cstm.*, users.first_name , users.last_name , ISNULL(users.first_name,'') + ' ' + ISNULL(users.last_name,'') as full_name, users.user_name , users.email1 , users.phone_work , users.created_by , 'users' panel_name FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c INNER JOIN team_membership ON (users.id=team_membership.user_id AND team_membership.team_id='eaa1ce56-652c-2cb5-90ff-478cc7eefe4a') where ( team_membership.deleted=0 AND users.deleted=0) AND users.deleted=0
) AS a
WHERE row_number > 10


which actually should be

SELECT TOP 10 * FROM
(
SELECT ROW_NUMBER() OVER (ORDER BY team_membership.id) AS row_number, users.id , users_cstm.*, users.first_name , users.last_name , ISNULL(users.first_name,'') + ' ' + ISNULL(users.last_name,'') as full_name, users.user_name , users.email1 , users.phone_work , users.created_by , 'users' panel_name FROM users LEFT JOIN users_cstm ON users.id = users_cstm.id_c INNER JOIN team_membership ON (users.id=team_membership.user_id AND team_membership.team_id='eaa1ce56-652c-2cb5-90ff-478cc7eefe4a') where ( team_membership.deleted=0 AND users.deleted=0) AND users.deleted=0
) AS a
WHERE row_number > 10


Note the Teams.id field in the first query, while there is no join or cross being done with the Teams table.

Anyhow i got it work by doing some dirty workarround, however let me know is there any better way to do it. Thanks.