Pixiv: Fox-y Ladies

Sat 7/14/18 12:17am

Comments: 0

Cheesecake

I’m taking a sort-of Underpants Gnomes approach to selecting cheesecake themes on Pixiv.

Collect Cheesecake.

?

Blog!

Step 2 in the Pixiv Underpants Gnome Plan is “pick a theme I’ve already downloaded enough images for”. In this case, that’s everything containing the kanji 狐 except where it’s used in a proper name, or: 狐耳狐娘キャス狐狐狐耳巫女 #キャス狐アサ狐乳狐狐っ娘狐巫女. That produces a set of 107 images that I already like, and there’s even a pair of red half-rims for an offering.

For amusement, here’s what my theme-discovery process ends up looking like, using the offline DB I build with the API:

% sqlite3 -separator " " pixiv-girls.sqlite3 <<EOF | head -20
select count(i.id),i.tag,t.en
  from illust i
  left outer join trans t on i.tag = t.jp
  where i.tag not like "%users入り"
  group by tag order by count(id) desc
EOF
1010 オリジナル Original
597 女の子 Girl
484 魅惑の谷間 Charming_Cleavage
462 おっぱい Oppai
329 Fate/GrandOrder 
258 R-18 
242 水着 Swimsuit
237 FGO 
230 猫耳 Cat_Girl
228 極上の乳 Superb_Breasts
220 艦これ KanColle
210 尻神様 Butt_Goddess
194 おへそ Belly_Button
194 艦隊これくしょん 
167 魅惑のふともも Captivating_Thighs
156 マシュ・キリエライト Mashu_Kyrielight
134 巨乳 Big_Breasts
125 CLIPSTUDIOPAINT 
116 下着 Underwear
114 アイドルマスターシンデレラガールズ Idolmaster_Cinderella_Girls

Once I’ve picked a set of tags, I have a little Bash script that does boolean searches on the SQLite DB and opens all the matching images in Preview.app, so I can do things like “(catgirl or foxgirl) and big boobs and not loli”.

The tagging still isn’t 100%, though, because tags are applied to illustration IDs, and it’s common for users to post multiple “pages” of images. Sometimes these are actual manga pages, but it’s also used for “grab-bag of sketches”, “N variations of the same drawing”, “N characters from same series”, and the ever-popular “progressively-more-explicit scene”. So, if a series includes a busty fox-girl, a loli catgirl, and a glasses-wearing robot, the ID will have all of those tags. Similarly, if the final image in a sequence is the aftermath of a gang-bang, the wholesome first image gets all the explicit tags as well.