character_artist_tags_by_post.json is a file produced by the sql ; select post_id, tag_name, tag_type from ( select unnest(tags) as tag_name, post_id, row_number() over (partition by post_id order by change_seq desc) from e621.change_history ; ) as tags_post_table ; inner join e621.tags using (tag_name) ; where row_number <= 1
Heart2soul.com site quick analysis ; Top Quantcast rank: 124,511 · Host IP 96.31.33.29 · Quick to load · Currently online · Number of websites on the same IP: 26+ · Top Alexa rank: 985,265 · 658 mistypes · Domain substitutes: 730