SELECT accounts.id ,accounts_cstm.client_status_c,accounts_cstm.annua l_turnover_c,accounts_cstm.number_of_employees_c,a ccounts_cstm.digitracc_user_c,accounts_cstm.prospe ct_c,accounts_cstm.active_lead_c,accounts_cstm.pip eline_opportunity_c,accounts_cstm.active_tracc_cli ent_c,accounts_cstm.active_consulting_client_c,acc ounts_cstm.inactive_client_c,accounts_cstm.wdgll_l ead_c,accounts_cstm.active_wdgll_client_c,accounts _cstm.do_not_mail_c,accounts_cstm.region_c,account s_cstm.desirability_c,accounts_cstm.source_c,accou nts_cstm.desirability_a_c,accounts_cstm.desirabili ty_b_c,accounts_cstm.desirability3_c,accounts_cstm .currency_c,accounts_cstm.data_verified_c,accounts _cstm.country_code_1_c,accounts_cstm.dialing_code_ 1_c,accounts_cstm.dialing_code_2_c,accounts_cstm.c ountry_code_other_c,accounts_cstm.temp_desire_c,ac counts_cstm.temp_client_status_c,accounts_cstm.tem p_account_manager_c,accounts_cstm.main_number_c,ac counts_cstm.active_client_c,accounts_cstm.extra1_c ,accounts_cstm.extra2_c,accounts_cstm.extra3_c,acc ounts_cstm.info_from_c, accounts.name , jt0.name parent_name , jt0.assigned_user_id parent_name_owner , 'Accounts' parent_name_mod, accounts.billing_address_city , accounts.description , accounts.phone_office , jt1.name team_name , jt1.created_by team_name_owner , 'Teams' team_name_mod, accounts.shipping_address_city , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, accounts.assigned_user_id FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN accounts jt0 ON jt0.id= accounts.parent_id AND jt0.deleted=0 AND jt0.deleted=0 LEFT JOIN teams jt1 ON jt1.id= accounts.team_id AND jt1.deleted=0 AND jt1.deleted=0 LEFT JOIN users jt2 ON jt2.id= accounts.assigned_user_id AND jt2.deleted=0 AND jt2.deleted=0 where ((jt0.name = 'abi')) AND accounts.deleted=0 ORDER BY accounts.name ASC is the search query by sugar.

it brings back no data. but when i change te jy0 to accounts i get info? help