show-thumbnails-anon-read.sql

SELECT 
  * 
FROM 
  public.item2bundle, 
  public.bundle, 
  public.bundle2bitstream, 
  public.resourcepolicy
WHERE 
  item2bundle.bundle_id = bundle.bundle_id AND
  bundle.bundle_id = bundle2bitstream.bundle_id AND
  resourcepolicy.resource_id = bundle2bitstream.bitstream_id AND
  bundle."name" = 'THUMBNAIL' AND 
  resourcepolicy.resource_type_id = 0 AND 
  resourcepolicy.action_id = 0 AND 
  resourcepolicy.epersongroup_id = 1;

thumbnails-anon-read.sql

UPDATE
  resourcepolicy
SET
  epersongroup_id=0
WHERE 
(policy_id IN (
SELECT
  resourcepolicy.policy_id
FROM 
  public.item2bundle, 
  public.bundle, 
  public.bundle2bitstream, 
  public.resourcepolicy
WHERE 
  item2bundle.bundle_id = bundle.bundle_id AND
  bundle.bundle_id = bundle2bitstream.bundle_id AND
  resourcepolicy.resource_id = bundle2bitstream.bitstream_id AND
  bundle."name" = 'THUMBNAIL' AND 
  resourcepolicy.resource_type_id = 0 AND 
  resourcepolicy.action_id = 0 AND 
  resourcepolicy.epersongroup_id = 1
));