series_tags

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

39 rows where series_id = "CNT_16H26YC7BDYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_16H26YC7BDYG,TAG_0M9XE1W8SVD0 Blue Period CNT_16H26YC7BDYG Seinen TAG_0M9XE1W8SVD0
CNT_16H26YC7BDYG,TAG_0MV2CQSX9BA0 Blue Period CNT_16H26YC7BDYG safe TAG_0MV2CQSX9BA0
CNT_16H26YC7BDYG,TAG_0NDWND9M6450 Blue Period CNT_16H26YC7BDYG Adapted to Anime TAG_0NDWND9M6450
CNT_16H26YC7BDYG,TAG_0NZDKK5S9M20 Blue Period CNT_16H26YC7BDYG 21st Century TAG_0NZDKK5S9M20
CNT_16H26YC7BDYG,TAG_11R5K4KJWPJ0 Blue Period CNT_16H26YC7BDYG Friendship TAG_11R5K4KJWPJ0
CNT_16H26YC7BDYG,TAG_128EPTRYEX10 Blue Period CNT_16H26YC7BDYG Drawing TAG_128EPTRYEX10
CNT_16H26YC7BDYG,TAG_15FWFQ2X8HF0 Blue Period CNT_16H26YC7BDYG LGBTQ+ TAG_15FWFQ2X8HF0
CNT_16H26YC7BDYG,TAG_17G11DBTTR20 Blue Period CNT_16H26YC7BDYG High School TAG_17G11DBTTR20
CNT_16H26YC7BDYG,TAG_19Y5HGS45S50 Blue Period CNT_16H26YC7BDYG Bisexual TAG_19Y5HGS45S50
CNT_16H26YC7BDYG,TAG_1A1YWANG7EX0 Blue Period CNT_16H26YC7BDYG Alcohol TAG_1A1YWANG7EX0
CNT_16H26YC7BDYG,TAG_1BG9Y4R3QX40 Blue Period CNT_16H26YC7BDYG Androgynous Character TAG_1BG9Y4R3QX40
CNT_16H26YC7BDYG,TAG_1CZKT8ATGE20 Blue Period CNT_16H26YC7BDYG College TAG_1CZKT8ATGE20
CNT_16H26YC7BDYG,TAG_1H35VN34FSE0 Blue Period CNT_16H26YC7BDYG Tall Male Lead TAG_1H35VN34FSE0
CNT_16H26YC7BDYG,TAG_1JRF4PV6GYZ0 Blue Period CNT_16H26YC7BDYG Senpai-Kouhai Relationship TAG_1JRF4PV6GYZ0
CNT_16H26YC7BDYG,TAG_1P3QSYSHW6X0 Blue Period CNT_16H26YC7BDYG Tragedy TAG_1P3QSYSHW6X0
CNT_16H26YC7BDYG,TAG_1P772JF0C260 Blue Period CNT_16H26YC7BDYG Tomboys TAG_1P772JF0C260
CNT_16H26YC7BDYG,TAG_1TCY4V5T9HS0 Blue Period CNT_16H26YC7BDYG Male Lead TAG_1TCY4V5T9HS0
CNT_16H26YC7BDYG,TAG_1X0XMNRA3Q20 Blue Period CNT_16H26YC7BDYG School TAG_1X0XMNRA3Q20
CNT_16H26YC7BDYG,TAG_1XDCBGAVGBS0 Blue Period CNT_16H26YC7BDYG School Clubs TAG_1XDCBGAVGBS0
CNT_16H26YC7BDYG,TAG_2M2AXCZQH3EG Blue Period CNT_16H26YC7BDYG Drama TAG_2M2AXCZQH3EG
CNT_16H26YC7BDYG,TAG_31BWV424N1DG Blue Period CNT_16H26YC7BDYG Gender Bender TAG_31BWV424N1DG
CNT_16H26YC7BDYG,TAG_32Z7SP0V69PG Blue Period CNT_16H26YC7BDYG Delinquents TAG_32Z7SP0V69PG
CNT_16H26YC7BDYG,TAG_3350B1617FTG Blue Period CNT_16H26YC7BDYG Educational TAG_3350B1617FTG
CNT_16H26YC7BDYG,TAG_3555NYENGW7G Blue Period CNT_16H26YC7BDYG LGBT Character TAG_3555NYENGW7G
CNT_16H26YC7BDYG,TAG_373R9ETCJMXG Blue Period CNT_16H26YC7BDYG Homophobia TAG_373R9ETCJMXG
CNT_16H26YC7BDYG,TAG_3BD0MB7NCFSG Blue Period CNT_16H26YC7BDYG Appearance Different from Personality TAG_3BD0MB7NCFSG
CNT_16H26YC7BDYG,TAG_3CTBM2Y283BG Blue Period CNT_16H26YC7BDYG Coming of Age TAG_3CTBM2Y283BG
CNT_16H26YC7BDYG,TAG_3DJ543SYS94G Blue Period CNT_16H26YC7BDYG Crossdressing TAG_3DJ543SYS94G
CNT_16H26YC7BDYG,TAG_3EBEM0XVAQDG Blue Period CNT_16H26YC7BDYG Character Growth TAG_3EBEM0XVAQDG
CNT_16H26YC7BDYG,TAG_3G43TZ3GPVEG Blue Period CNT_16H26YC7BDYG Suicide TAG_3G43TZ3GPVEG
CNT_16H26YC7BDYG,TAG_3K715CVA9WWG Blue Period CNT_16H26YC7BDYG Smoking TAG_3K715CVA9WWG
CNT_16H26YC7BDYG,TAG_3KY6Q5W995AG Blue Period CNT_16H26YC7BDYG Slice of Life TAG_3KY6Q5W995AG
CNT_16H26YC7BDYG,TAG_3MX8K9E1NP0G Blue Period CNT_16H26YC7BDYG Visual Arts TAG_3MX8K9E1NP0G
CNT_16H26YC7BDYG,TAG_3PAYAKYA4X1G Blue Period CNT_16H26YC7BDYG Transgender TAG_3PAYAKYA4X1G
CNT_16H26YC7BDYG,TAG_3WK8G5MBTTVG Blue Period CNT_16H26YC7BDYG Primarily Teen Cast TAG_3WK8G5MBTTVG
CNT_16H26YC7BDYG,TAG_3WWBECGMTGDG Blue Period CNT_16H26YC7BDYG Psychological TAG_3WWBECGMTGDG
CNT_16H26YC7BDYG,TAG_3X845AY38F6G Blue Period CNT_16H26YC7BDYG School Life TAG_3X845AY38F6G
CNT_16H26YC7BDYG,TAG_3ZA83YSAT31G Blue Period CNT_16H26YC7BDYG Primarily Adult Cast TAG_3ZA83YSAT31G
CNT_16H26YC7BDYG,TAG_3ZJYKXZYDX4G Blue Period CNT_16H26YC7BDYG Philosophy TAG_3ZJYKXZYDX4G

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE series_tags (
      series_id TEXT NOT NULL,
      tag_id TEXT NOT NULL,
      PRIMARY KEY (series_id, tag_id),
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (tag_id) REFERENCES tags(id)
    );
CREATE INDEX idx_series_tags_tag ON series_tags(tag_id);