acmcc/supabase/migrations/20260511212702_bb91340b-6a78-40ef-b09d-e66e2277d3d2.sql

CREATE POLICY "Public can view associations with published page"
ON public.associations
FOR SELECT
TO anon, authenticated
USING (
  EXISTS (
    SELECT 1 FROM public.association_public_pages app
    WHERE app.association_id = associations.id
      AND app.is_published = true
  )
);