One of the best SFW imageboards e-shuushuu.net already ripped in FULL (unfiltered, unconverted) releases
[2005-2014](https://nyaa.si/view/513582) 380 GB
[2014-2015](https://nyaa.si/view/771715) 155 GB partially overlap
[2016-2018](https://www.acgnx.se/show-cceb3260269b5423cbd7f8d59f2c84531750923b.html) 189 GB
Years ago e-shuushuu was very active, now it lost it's leadership and most of activity, but still the best by image selection.
To complete rips to current sate, this release contains:
- 66.618 images for 2019-2020 archived by volumes (3 per month) not filtered, not converted
* files name contain *ID - up_to_3_copyrights ~ up_to_5_characters (up_to_2_artists)*
- metadata in text TSV format for ALL 1.030.423 available post (including 1.000.228 from releases mentioned above and current one)
* tags by category, fav_count, EXIF info, MD5 etc
* location info in torrent's structure
* and also separately parsed 3.253.443 tags for copyrights, characters and artists
- some scripts for DIY activists
* python grabber by ID range or list
* SQLs helpful for processing in database
Q: who are the most favorited characters from popular ones ?
```sql
select d.tag, count(*) cnt, round(avg(favn)) favn
from ess_ld l
join ess_dt_ld d on l.id=d.id and tag_cat=4
group by d.tag
having count(*)>=100
order by 3 desc
fetch first 10 rows only
```
A: Chocola & Vanilla