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 (20923,20947,20839,20797,20693) 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 (20766,20928,20661,20753,20752) 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 (20945,20939,20799,20757,20954) 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 (20907,20716,20956,20955,20930) order by article_opendate desc
