Check mass disabled topics SQL

select * from topic where date(last_update_date)='2017-03-02' and status = 0 order by topic_id asc; select count(*) from topic where status = 1 and mark_like = 0 and articles <=2 and topic_id >= 2735181 and topic_id <=2750731 and create_date <'2015-01-01' ; select * from topic where topic_id>=2735181 and topic_id<2853221 and articles<=2 and status = 1 and date(create_date)<'2015-01-01' limit 10000; ;

Comments