useful_metadata_joins.sql

-- What roles have access to which attributes on the given entity 

SELECT r.name, a.name 
FROM meta_attribute_roles ar 

JOIN roles r on ar.role_id = r.id 
JOIN meta_attributes a ON ar.meta_attribute_id = a.id 
JOIN meta_entities e ON a.meta_entity_id = e.id 

WHERE e.name like '%festival%';