Untitled attachment

Notices where this attachment appears

1. Embed this notice
   Yukkuri (iamtakingiteasy@eientei.org)'s status on Monday, 04-Sep-2023 19:21:29 JST Yukkuri

   in reply to
   @Humpleupagus @cassidyclown @lina @mint Something along the lines of with ids as ( select activities.id as acitivity_id, objects.id as object_id from activities join objects on objects.data->>'id' = associated_object_id(activities.data) and not ( activities.data::text like '%eveningzoo.club%' or objects.data::text like '%eveningzoo.club%' or greatest(activities.inserted_at, activities.updated_at, objects.inserted_at, objects.updated_at) >= now()-'30 days'::interval ) ), del_activities as ( delete from activities where id in (select acitivity_id from ids) ) delete from objects where id in (select object_id from ids) But setup a DB and instance copy first to test it thoroughly without affecting your live instance.