series_tags

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

41 rows where series_id = "CNT_04PVNAG7KJN0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_04PVNAG7KJN0,TAG_0M0JHS1FS5V0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Fantasy TAG_0M0JHS1FS5V0
CNT_04PVNAG7KJN0,TAG_0M9XE1W8SVD0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Seinen TAG_0M9XE1W8SVD0
CNT_04PVNAG7KJN0,TAG_0NDWND9M6450 The Summer Hikaru Died CNT_04PVNAG7KJN0 Adapted to Anime TAG_0NDWND9M6450
CNT_04PVNAG7KJN0,TAG_11A4ZJ5WX3Y0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Ghosts TAG_11A4ZJ5WX3Y0
CNT_04PVNAG7KJN0,TAG_158WXZSY8Q10 The Summer Hikaru Died CNT_04PVNAG7KJN0 Love Confession TAG_158WXZSY8Q10
CNT_04PVNAG7KJN0,TAG_15FWFQ2X8HF0 The Summer Hikaru Died CNT_04PVNAG7KJN0 LGBTQ+ TAG_15FWFQ2X8HF0
CNT_04PVNAG7KJN0,TAG_16W7T1ZYXZA0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Gods TAG_16W7T1ZYXZA0
CNT_04PVNAG7KJN0,TAG_1720DWX4TNE0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Horror TAG_1720DWX4TNE0
CNT_04PVNAG7KJN0,TAG_17EG37FMB850 The Summer Hikaru Died CNT_04PVNAG7KJN0 Human-Nonhuman Relationship TAG_17EG37FMB850
CNT_04PVNAG7KJN0,TAG_17G11DBTTR20 The Summer Hikaru Died CNT_04PVNAG7KJN0 High School TAG_17G11DBTTR20
CNT_04PVNAG7KJN0,TAG_1CE2W2EM0Y50 The Summer Hikaru Died CNT_04PVNAG7KJN0 Cosmic Horror TAG_1CE2W2EM0Y50
CNT_04PVNAG7KJN0,TAG_1FZ1W0CD32F0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Childhood Friends TAG_1FZ1W0CD32F0
CNT_04PVNAG7KJN0,TAG_1GBABM09YKD0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Supernatural TAG_1GBABM09YKD0
CNT_04PVNAG7KJN0,TAG_1HGTZ79TFC20 The Summer Hikaru Died CNT_04PVNAG7KJN0 Suspense TAG_1HGTZ79TFC20
CNT_04PVNAG7KJN0,TAG_1JDY9R0Q0QC0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Shounen Ai TAG_1JDY9R0Q0QC0
CNT_04PVNAG7KJN0,TAG_1P3QSYSHW6X0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Tragedy TAG_1P3QSYSHW6X0
CNT_04PVNAG7KJN0,TAG_1PN464N6FPT0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Thriller TAG_1PN464N6FPT0
CNT_04PVNAG7KJN0,TAG_1Q0HX10YX5F0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Unrequited Love TAG_1Q0HX10YX5F0
CNT_04PVNAG7KJN0,TAG_1QD1MDDEDRA0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Urban Fantasy TAG_1QD1MDDEDRA0
CNT_04PVNAG7KJN0,TAG_1RAA6QAW7XY0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Mystery TAG_1RAA6QAW7XY0
CNT_04PVNAG7KJN0,TAG_1SPTXKQDQGN0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Mythology TAG_1SPTXKQDQGN0
CNT_04PVNAG7KJN0,TAG_1TCY4V5T9HS0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Male Lead TAG_1TCY4V5T9HS0
CNT_04PVNAG7KJN0,TAG_1X0XMNRA3Q20 The Summer Hikaru Died CNT_04PVNAG7KJN0 School TAG_1X0XMNRA3Q20
CNT_04PVNAG7KJN0,TAG_1XVDF2GSKYD0 The Summer Hikaru Died CNT_04PVNAG7KJN0 Rural TAG_1XVDF2GSKYD0
CNT_04PVNAG7KJN0,TAG_324PES9NP27G The Summer Hikaru Died CNT_04PVNAG7KJN0 Discrimination TAG_324PES9NP27G
CNT_04PVNAG7KJN0,TAG_32JQ2BPA9PVG The Summer Hikaru Died CNT_04PVNAG7KJN0 Death of Loved One TAG_32JQ2BPA9PVG
CNT_04PVNAG7KJN0,TAG_3555NYENGW7G The Summer Hikaru Died CNT_04PVNAG7KJN0 LGBT Character TAG_3555NYENGW7G
CNT_04PVNAG7KJN0,TAG_373R9ETCJMXG The Summer Hikaru Died CNT_04PVNAG7KJN0 Homophobia TAG_373R9ETCJMXG
CNT_04PVNAG7KJN0,TAG_391WSG8EXM4G The Summer Hikaru Died CNT_04PVNAG7KJN0 Body Horror TAG_391WSG8EXM4G
CNT_04PVNAG7KJN0,TAG_3DD4YRESSWAG The Summer Hikaru Died CNT_04PVNAG7KJN0 Dark Ambience TAG_3DD4YRESSWAG
CNT_04PVNAG7KJN0,TAG_3DYNVEAE9C3G The Summer Hikaru Died CNT_04PVNAG7KJN0 Curses TAG_3DYNVEAE9C3G
CNT_04PVNAG7KJN0,TAG_3FBRJ8VGVK0G The Summer Hikaru Died CNT_04PVNAG7KJN0 Classmates TAG_3FBRJ8VGVK0G
CNT_04PVNAG7KJN0,TAG_3G9JE2B16NZG The Summer Hikaru Died CNT_04PVNAG7KJN0 Supernatural Elements TAG_3G9JE2B16NZG
CNT_04PVNAG7KJN0,TAG_3R33NJ4VZ5VG The Summer Hikaru Died CNT_04PVNAG7KJN0 Monsters TAG_3R33NJ4VZ5VG
CNT_04PVNAG7KJN0,TAG_3R6KYQTAF2WG The Summer Hikaru Died CNT_04PVNAG7KJN0 Monster Boys TAG_3R6KYQTAF2WG
CNT_04PVNAG7KJN0,TAG_3RC23S34ZVDG The Summer Hikaru Died CNT_04PVNAG7KJN0 Mysterious Elements TAG_3RC23S34ZVDG
CNT_04PVNAG7KJN0,TAG_3STX5K7PCBMG The Summer Hikaru Died CNT_04PVNAG7KJN0 Non-human TAG_3STX5K7PCBMG
CNT_04PVNAG7KJN0,TAG_3WK8G5MBTTVG The Summer Hikaru Died CNT_04PVNAG7KJN0 Primarily Teen Cast TAG_3WK8G5MBTTVG
CNT_04PVNAG7KJN0,TAG_3WWBECGMTGDG The Summer Hikaru Died CNT_04PVNAG7KJN0 Psychological TAG_3WWBECGMTGDG
CNT_04PVNAG7KJN0,TAG_3XF5Q23289CG The Summer Hikaru Died CNT_04PVNAG7KJN0 School Boy TAG_3XF5Q23289CG
CNT_04PVNAG7KJN0,TAG_3YDEEAPDX4QG The Summer Hikaru Died CNT_04PVNAG7KJN0 Past Plays a Big Role TAG_3YDEEAPDX4QG

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);