search

fire-eggs / Danbooru2021

Python scripts and tools for working with the Danbooru2022 data set. Note: this is a sqlite database and a viewer, not directly related to machine learning.
https://www.gwern.net/Danbooru2021
MIT License
42 stars 2 forks source link

Artists table is missing counts #57

Open fire-eggs opened 1 year ago

fire-eggs commented 1 year ago

The [Artists] table only has 0 values for the count column.

Should be easy to populate: set artists.count = (select count from tags where artists.tag_id = tags.tag_id)

fire-eggs commented 1 year ago

update artists set count=(select count from tags where artists.tag_id = tags.tag_id)