I am unable to view target lists. I receive the following error in 6.1.4 CE:

Target List
Error retrieving ProspectList list: Query Failed: (SELECT accounts.id , accounts.name , accounts.phone_office , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id , 'accounts' panel_name FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON jt0.id= accounts.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0 INNER JOIN prospect_lists_prospects ON (accounts.id=prospect_lists_prospects.related_id AND prospect_lists_prospects.prospect_list_id= '4b7afb8d-97fb-caa9-3c90-4defdbb0eb93' AND prospect_lists_prospects.related_type='Accounts') where ( prospect_lists_prospects.deleted=0 AND accounts.deleted=0) AND accounts.deleted=0) ORDER BY email1 asc LIMIT 0,10: Database failure. Please refer to sugarcrm.log for details.
sugarcrm.log
11/14/11 13:19:18 [1168][c6d90463-0e54-8cd6-43a7-4b7c2df11f5b][FATAL] Error retrieving ProspectList list: Query Failed: (SELECT accounts.id , accounts.name , accounts.phone_office , CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')) assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id , 'accounts' panel_name FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= accounts.assigned_user_id AND jt0.deleted=0
Now if I take that SQL and place it into phpmyadmin - it collects all the information requested and shows it. Why is SugarCRM taking such great offense to this code?

Thanks,

Kevin