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 (19662,19679,19559,19190,19661) 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 (19708,19473,19675,19560,19187) 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 (19195,19667,19689,19655,19654) 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 (19614,19701,18928,19569,19713) order by article_opendate desc
