select ai.sno,ai.journal,ai.title,ai.keywords,ai.name,ai.fullname,ai.pdflink,ai.fulltextlink,ai.doi,ai.article,ai.abstract,ai.abs_link,ai.sup,ai.issn,ai.month,ai.year,ai.htmlviews,ai.pdfviews,ai.pub_date,ai.date,ai.s_page,ai.e_page,ai.class_keywords,ai.vol,ai.issue,ai.is_mobile,fmp.ft_seo_title,fmp.ft_seo_key,fmp.ft_seo_desc,fc.ft_top_content,fc.ft_below_content,fcr.ft_ref_content,fcr.ft_table_content from articlesinpress ai left join ft_meta_info fmp on ai.sno=fmp.art_id left join fulltext_content fc on ai.sno=fc.art_id left join fulltext_content_ref fcr on ai.sno=fcr.art_id where ai.sno='87694'