# Data Explorer Categories Permissions

**URL:** <https://meta.discourse.org/t/data-explorer-categories-permissions/111682>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [15 במרץ,‏ 2019,‏ 10:39am UTC](https://meta.discourse.org/t/data-explorer-categories-permissions/111682 "2019-03-15T10:39:45Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![csmu](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/csmu/32/124581_2.png) [@csmu](https://meta.discourse.org/u/csmu)\
**Post date:** [16 במרץ,‏ 2019,‏ 8:09pm UTC](https://meta.discourse.org/t/data-explorer-categories-permissions/111682/2 "2019-03-16T20:09:23Z")

</div>

This SQL shows all permissions in subcategories that are not in the parent categories.

```sql
SELECT subcategories.* FROM ( 
	SELECT category.parent_category_id 
	, category.id category_id
	, category.name category_name
	, category.position category_position
	, category_group.permission_type permission_type
	, groups.name group_name
	, groups.id group_id
	FROM categories category
	INNER JOIN category_groups category_group
	ON category_group.category_id = category.id
	INNER JOIN GROUPS
	ON groups.id = category_group.group_id
	WHERE parent_category_id IS NOT NULL
) subcategories
LEFT JOIN ( 
	SELECT category.id category_id
	, category.name category_name
	, category.position category_position
	, category_group.permission_type permission_type
	, groups.name group_name
	, groups.id group_id
	FROM categories category
	INNER JOIN category_groups category_group
	ON category_group.category_id = category.id
	INNER JOIN GROUPS
	ON groups.id = category_group.group_id
	WHERE parent_category_id IS NULL
) categories
ON categories.category_id = subcategories.parent_category_id
AND categories.group_id = subcategories.group_id
AND categories.permission_type = subcategories.permission_type
WHERE categories.category_id IS NULL

```

Example results

```plaintext
"parent_category_id","category_id","category_name","category_position","permission_type","group_name","group_id"
70,40,"CSMU Bogan's Run",57,1,"bd2l",44
70,40,"CSMU Bogan's Run",57,1,"bd2l-sales-marketing",59
70,55,"CSMU Miaffirmations",63,1,"miaffirmations",56
70,45,"CSMU Music",61,1,"csmu-music",64

```

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-categories-permissions/111682)._
