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 (17108,17176,17069,16987,17197) 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 (17207,17092,17138,17146,16862) 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 (17157,17187,17180,17204,17134) 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 (17057,17156,17195,17160,17011) order by article_opendate desc
