Posts

Lineart’s done.

Might be a bit late.

Also, if someone else designs your OC, then it’s not really yours is it?

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.

It does have the nice side effect of forcing people to actually look at and through the collage. If it you’re skimming over and the masses are just visual white noise, it’s still means more people are seeing the various OCs than if they know where to look.

.

Here is an update to the last pic i sent, made a report to have it merged into the new one

They’re generally grouped by color but not necessarily