MySQL error 1052: Column 'first_name' in order clause is ambiguous

[climbing-alien]

Hi

I am getting an error
MySQL error 1052: Column 'first_name' in order clause is ambiguous
when clicking on any target list.


01/06/11 08:23:04 [2416][1][FATAL] Error retrieving ProspectList list: Query Failed: (SELECT leads.id , leads.last_name , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.refered_by , leads.phone_work , leads.lead_source_description , jt0.user_name assigned_user_name , leads.assigned_user_id , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.created_by , leads.account_name , 'leads' panel_name FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 INNER JOIN prospect_lists_prospects ON (leads.id=prospect_lists_prospects.related_id AND prospect_lists_prospects.prospect_list_id= '4d1f7135-7158-dd70-7d77-4d1c46f4f844' AND prospect_lists_prospects.related_type='Leads') where ( prospect_lists_prospects.deleted=0 AND leads.deleted=0) AND leads.deleted=0) ORDER BY leads.last_name, first_name desc LIMIT 0,11: MySQL error 1052: Column 'first_name' in order clause is ambiguous

Anyone any ideas where I might start trying to track this problem down?

[climbing-alien]

As a note i have a first_name_c and last_name _c field in leads. Would this be affecting it?