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='57936' and ad.lang_id='9' and j.lang_id='9' and vi.lang_id='9'
ISSN: 2329-9029
Henryk Kalisz