2021 Derpibooru Community Collab

SELECT name FROM tags
WHERE id IN (
SELECT tag_id
FROM image_taggings
WHERE image_id IN (
SELECT image_id
FROM image_taggings
WHERE tag_id = 478530
)
AND image_id NOT IN (
SELECT id
FROM images
WHERE hidden_from_users = true
AND id IN (
SELECT image_id
FROM image_taggings
WHERE tag_id = 478530
)
)
)
AND (namespace = ‘oc’ OR namespace = ‘artist’)
GROUP BY name;

• the tag is on an image that is tagged with tag ID 478530 (2020 Community Collab)  
• the tag also is on an image that is not deleted  
• the tag also has an “artist” or “oc” namespace
   
  There’s probably a cleaner and more efficient way to do that, but that’s a query that only has to be ran like once or twice a year, so I didn’t really care.

tag ID 478530 (2020 Community Collab)

select t.name from images i inner join image_taggings it on it.image_id = i.id right outer join image_taggings it2 on it2.image_id = i.id inner join tags t on t.id = it2.tag_id where it.tag_id = 478530 and t.namespace in ('oc', 'artist') and i.hidden_from_users = false group by t.name;

select t.name from images i
inner join image_taggings it on it.image_id = i.id
right outer join image_taggings it2 on it2.image_id = i.id
inner join tags t on t.id = it2.tag_id
where it.tag_id = 478530 and t.namespace in ('oc', 'artist') and i.hidden_from_users = false
group by t.name;