超过7天不生成队列,队列自动关闭测试
sql
select id
from t_publish_strategy
where id not in (
select distinct strategy_id
from t_publish_execute_queue
where create_time > date_add(now(), INTERVAL -7 DAY)
)
and create_time < date_add(now(), INTERVAL -7 DAY)
and auto_disable = 1
and status = 0
and is_deleted = 0