利用PHPMYADMIN执行

update threads
set is_display = 0
where id in (select thread_id from thread_tom where tom_type in (104, 106, 107))
or price > 0 or attachment_price > 0 or is_anonymous=1;

过了以后再

update threads
set is_display = 1
where id in (select thread_id from thread_tom where tom_type in (104, 106, 107))
or price > 0 or attachment_price > 0 or is_anonymous=1;