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='68479' and ad.lang_id='9' and j.lang_id='9' and vi.lang_id='9'
ISSN: 2471-9870
Jansson K*