insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.activitiesByOrganizations' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.activitiesByTeamMembers' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.organizationGraphData' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageClicks' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageEngagement' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageEngagementRate' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageImpressions' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageLikeGrowth' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageLikeOverview' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageOverallLikes' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pagePostEngagement' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageReach' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageVideoViews' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageViews' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.topPostsByEngagement' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.topPostsByImpression' as resourceID from smd__organization_role WHERE roleID LIKE '%.analyst.%';

insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.activitiesByOrganizations' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.activitiesByTeamMembers' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.organizationGraphData' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageClicks' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageEngagement' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageEngagementRate' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageImpressions' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageLikeGrowth' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageLikeOverview' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageOverallLikes' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pagePostEngagement' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageReach' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageVideoViews' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.pageViews' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.topPostsByEngagement' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';
insert into smd__organization_role_has_resources (roleID, resourceID) select roleID, 'analytics.analytics.topPostsByImpression' as resourceID from smd__organization_role WHERE roleID LIKE '%.client.%';