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 (18683,18562,18623,18464,18338) 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 (18638,18237,18420,18542,18621) 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 (18362,18670,18597,18691,18703) 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 (18374,18662,18685,18650,18644) order by article_opendate desc
