select sa.sap_id,sa.a_name,sa.a_designation,sa.a_dept,sa.a_url,sa.a_email,sa.a_photo,sa.a_biography,sa.a_ri,sa.acnt_id,sa.a_catid,ui.uname,ui.university_url,jcl.journal_cat_name,jcl.status,jcl.journal_cat,sc.country_name,si.ind_name from sap_authors sa left join unversity_info ui on ui.id=sa.unv_id left join journals_category_list jcl on jcl.sno=sa.a_catid left join sap_country sc on sc.cnt_id=sa.acnt_id left join sap_industries si on si.ind_id=sa.ind_id where sap_id='1495872'