One of the best **purely SFW** imageboards e-shuushuu.net already ripped in **full** (unfiltered, unconverted) releases [2005-2014](https://nyaa.iss.one/view/513582) 380 GB [2014-2015](https://nyaa.iss.one/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 (ID 979.402-1.046.967) 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 (file name, zip name, path) 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 among e-shuushuu popular ones ? ```sql select d.tag, count(*) cnt, round(avg(favn)) favn from ess_posts l join ess_tags 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 are P.S. complete list of arranged releases on rutracker (russian torrents site, you can get magnet there even when uned) [2018](https://rutracker.org/forum/viewtopic.php?t=5582710) 43 GB [2017](https://rutracker.org/forum/viewtopic.php?t=5397445) 64 GB [2016](https://rutracker.org/forum/viewtopic.php?t=5184361) 83 GB [2015](https://rutracker.org/forum/viewtopic.php?t=4952787) 90 GB [06.2013-2014](https://rutracker.org/forum/viewtopic.php?t=4583098) 101 GB [06.2011-05.2013 part 1](https://rutracker.org/forum/viewtopic.php?t=4462893) [06.2011-05.2013 part 2](https://rutracker.org/forum/viewtopic.php?t=4575912) 59 + 70 GB [2005-05.2011](https://rutracker.org/forum/viewtopic.php?t=3612068) 216 GB And art stream goes on [2021-2022](https://nyaa.iss.one/view/1623787), stay tuned !