1.ʽʱ

2.βѯδɵ



dt_article ׼  

SetNoFinish
select * from dt_article where add_time < GetDate() and status=0 and is_top=0 and is_sys = 0


select * from dt_article where add_time < GetDate() and status=0 and is_top=0 and is_sys = 0

select * from dt_article_category where seo_keywords != '' and id in(select category_id from dt_article where is_top=1)

select * from dt_article where is_top=1

1
AddTask
article_category Ŀ,
article ׼ is_top = 1  
SetNoFinish status = 3 ʲô˼
status, is_top = 0
0 δ
1 
2 ȡ
3 
is_msg
0 
1 
is_top = 1
׼

audit_result 0-ؼ죬1-ȷͨ

article_attribute_value Ƶ

GetForAudit type = 1 Ա δ

GetTaskCount type = 3 Ա鿴 δ

convert(varchar(10),GETDATE(),120)