Only SFW Artists

This is a list of artists that only have safe artwork on e621. A small note, this is only artists that have more than ten posts.

Maybe something to do is to have a list of all artists with percentages of types of artwork.

2019-02-25

select tag_name 
from posts inner join (
    select tag_name, count 
    from tag_count inner join tag_info using(tag_name) 
    where count > 10 and tag_type = 1 
) as artists on (tags @> Array[tag_name])
where rating = 23 
group by tag_name, count 
having count(*) = count