Zen Cart批量删除垃圾评论

en Cart V1.39h 被人狂发垃圾评论 决心清理一下   请注意：操作前请务必备份数据库。     delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.status=0 AND t2.reviews_text like “%href%” OR t2.reviews_text like “%http%”; 或     delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.status=0 AND t2.reviews_text like “%href%” OR t2.reviews_text like “%http%” OR t1.customers_name is null; 删除指定id 的评论     delete t1,t2 from reviews as t1 left join reviews_description as t2 on t1.reviews_id=t2.reviews_id where t1.reviews_id=4423;