select ad.sno,ad.journal,ad.title,ad.author_names,ad.abstract,ad.abstractlink,j.j_name,vi.* from articles_data ad left join journals j on j.journal=ad.journal left join vol_issues vi on vi.issue_id_en=ad.issue_id where ad.sno_en='55342' and ad.lang_id='6' and j.lang_id='6' and vi.lang_id='6'
ISSN: 2165- 7866
Sushmit Jha