summaryrefslogtreecommitdiff
path: root/graphs/sql/red_flag/req03.sql
blob: c13cc56e91708320b4385711ec7c71068a2cc70e (plain)
1
2
3
4
DELETE FROM public.epix_posts AS p
USING public.epix_hashtags AS h,public.people AS pp, public.epix_accounts AS a
WHERE h.id = p.hashtag_id AND h.name = 'EndSurveillance' AND pp.id = a.person_id AND p.author_id = a.id
RETURNING first_name,last_name,username,p.body AS post_content;