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='76891' and ad.lang_id='6' and j.lang_id='6' and vi.lang_id='6'
Pharmacoepidemiology | 76891
