Posts

tag ID 478530 (2020 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.