select top 3 topics.topic_id, topics.topic_title_en, topics.topic_title_zh, topics.topic_area, articles.author_id, articles.article_id ,article_subject, article_excerpt, article_subject_short , article_opendate, article_maximg, article_minimg, blogger_id, article_responeditor, article_editorid, article_advertise from articles left join topics on articles.topic_id=topics.topic_id where article_switch = 1 and topics.topic_area=2 and article_opendate <=getdate() and articles.article_id not in (19085,18591,19280,19214,19368) order by article_opendate desc
select top 3 topics.topic_id, topics.topic_title_en, topics.topic_title_zh, topics.topic_area, articles.author_id, articles.article_id ,article_subject, article_excerpt, article_subject_short , article_opendate, article_maximg, article_minimg, blogger_id, article_responeditor, article_editorid, article_advertise from articles left join topics on articles.topic_id=topics.topic_id where article_switch = 1 and topics.topic_area=1 and article_opendate <=getdate() and articles.article_id not in (18870,19302,19200,19193,19456) order by article_opendate desc
select top 3 topics.topic_id, topics.topic_title_en, topics.topic_title_zh, topics.topic_area, articles.author_id, articles.article_id ,article_subject, article_excerpt, article_subject_short , article_opendate, article_maximg, article_minimg, blogger_id, article_responeditor, article_editorid, article_advertise from articles left join topics on articles.topic_id=topics.topic_id where article_switch = 1 and topics.topic_area=3 and article_opendate <=getdate() and articles.article_id not in (19361,19423,19468,19495,19522) order by article_opendate desc
select top 3 topics.topic_id, topics.topic_title_en, topics.topic_title_zh, topics.topic_area, articles.author_id, articles.article_id ,article_subject, article_excerpt, article_subject_short , article_opendate, article_maximg, article_minimg, blogger_id, article_responeditor, article_editorid, article_advertise from articles left join topics on articles.topic_id=topics.topic_id where article_switch = 1 and topics.topic_area=5 and article_opendate <=getdate() and articles.article_id not in (19441,19488,19245,19487,19538) order by article_opendate desc
