1

Please login or register to vote for this query.

(click on this box to dismiss)

For the list of non-series tags, see: https://data.stackexchange.com/anime/query/1863699.

Q&A for scientists using computers to solve scientific problems

with tagnames as (
select tagsynonyms.*, '%<' + sourcetagname + '>%' as src, '%<' + targettagname + '>%' as target from tags
inner join tagsynonyms
on tagsynonyms.approvaldate is not null
and tags.tagname in (
'aimer',
 'amv',
 'anime-expo',
 'anime-history',
 'anime-industry',
 'anime-no-chikara',
 'anime-planet',
 'anime-production',
 'australia',
 'barasui',
 'censorship',
 'claris',
 'comiket',
 'conventions',
 'copyright',
 'cosplay',
 'crossovers',
 'crunchyroll',
 'culture',
 'domo-kun',
 'doujinshi',
 'england',
 'europe',
 'events',
 'funimation',
 'gainax',
 'game-history',
 'germany',
 'greece',
 'hatsune-miku',
 'hayao-miyazaki',
 'hideaki-anno',
 'hiroyuki-sawano',
 'identification-request',
 'india',
 'itasha',
 'japan',
 'japanese-language',
 'jun-maeda',
 'kajiura-yuki',
 'kazuki-nakashima',
 'kazuki-takahashi',
 'ken-akamatsu',
 'key',
 'kouji-seo',
 'kyoto-animation',
 'law',
 'licensing',
 'light-novel-history',
 'light-novel-production',
 'light-novel-site',
 'live-action-production',
 'localization',
 'maaya-sakamoto',
 'madhouse',
 'makoto-shinkai',
 'mamiko-noto',
 'mamoru-hosoda',
 'mamoru-oshii',
 'manga-history',
 'manga-production',
 'mangaka',
 'masamune-shirow',
 'meme',
 'merchandise',
 'music',
 'myanimelist',
 'netflix',
 'north-korea',
 'os-tan',
 'panel-arrangement',
 'pixiv',
 'promotional-videos',
 'quotes',
 'resources',
 'retag',
 'ribon',
 'sachika-misawa',
 'sentai-filmworks',
 'shonen-jump',
 'shun-saeki',
 'sign-language',
 'singapore',
 'spain',
 'streaming-sites',
 'studio-ghibli',
 'super-sonico',
 'symbolism',
 'terminology',
 'theme-song',
 'tourism',
 'tropes',
 'type-moon',
 'united-states',
 'visual-novel-production',
 'vocaloid',
 'voice-acting'
)
and tags.tagname = tagsynonyms.sourcetagname
)
select top 10 * from posts 
inner join tagnames
on posts.posttypeid = 1
and posts.tags like '%anime-production%'

view current version

edited oct 1

created oct 1 Gao