Appeared a problem with connection to SQL 1 Appeared a problem with connection to SQL 1 Appeared error in query, contact with admin 2 - select top 10 p.name, p.skill_level,p.alliance_id,p.castle_id,p.ruler_id,count(char_id) as cnt from dbo.Pledge p, user_data ud where ud.pledge_id=p.pledge_id group by p.name, p.skill_level,p.alliance_id,p.castle_id,p.ruler_id order by -skill_level,-count(char_id)