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

Check for tag duplication across categories #24

Closed fire-eggs closed 4 years ago

fire-eggs commented 4 years ago

Verify whether tags with the same name exist in more than one category.

If so, may want include the category when filtering by tag.

fire-eggs commented 4 years ago

Doesn't appear to be the case. select name from tags where category=0 intersect select name from tags where category=1 Repeated for 0 vs 1,3,4,5; 1 vs 3,4,5; 3 vs 4,5; 4 vs 5.