series_tags

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

23 rows where series_id = "CNT_3480ATAKS3P0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3480ATAKS3P0,TAG_0M9XE1W8SVD0 Initial D Omnibus CNT_3480ATAKS3P0 Seinen TAG_0M9XE1W8SVD0
CNT_3480ATAKS3P0,TAG_0NDWND9M6450 Initial D Omnibus CNT_3480ATAKS3P0 Adapted to Anime TAG_0NDWND9M6450
CNT_3480ATAKS3P0,TAG_11R5K4KJWPJ0 Initial D Omnibus CNT_3480ATAKS3P0 Friendship TAG_11R5K4KJWPJ0
CNT_3480ATAKS3P0,TAG_17G11DBTTR20 Initial D Omnibus CNT_3480ATAKS3P0 High School TAG_17G11DBTTR20
CNT_3480ATAKS3P0,TAG_17KHA2S9A570 Initial D Omnibus CNT_3480ATAKS3P0 Heterosexual TAG_17KHA2S9A570
CNT_3480ATAKS3P0,TAG_1A1YWANG7EX0 Initial D Omnibus CNT_3480ATAKS3P0 Alcohol TAG_1A1YWANG7EX0
CNT_3480ATAKS3P0,TAG_1KARDCBW1QY0 Initial D Omnibus CNT_3480ATAKS3P0 Sports TAG_1KARDCBW1QY0
CNT_3480ATAKS3P0,TAG_1MJGSGTRXJV0 Initial D Omnibus CNT_3480ATAKS3P0 Violence TAG_1MJGSGTRXJV0
CNT_3480ATAKS3P0,TAG_1TCY4V5T9HS0 Initial D Omnibus CNT_3480ATAKS3P0 Male Lead TAG_1TCY4V5T9HS0
CNT_3480ATAKS3P0,TAG_1WN0XQJKJR90 Initial D Omnibus CNT_3480ATAKS3P0 Primarily Male Cast TAG_1WN0XQJKJR90
CNT_3480ATAKS3P0,TAG_1WY3BY9WJY30 Initial D Omnibus CNT_3480ATAKS3P0 Prostitution TAG_1WY3BY9WJY30
CNT_3480ATAKS3P0,TAG_1X0XMNRA3Q20 Initial D Omnibus CNT_3480ATAKS3P0 School TAG_1X0XMNRA3Q20
CNT_3480ATAKS3P0,TAG_1XVDF2GSKYD0 Initial D Omnibus CNT_3480ATAKS3P0 Rural TAG_1XVDF2GSKYD0
CNT_3480ATAKS3P0,TAG_2M2AXCZQH3EG Initial D Omnibus CNT_3480ATAKS3P0 Drama TAG_2M2AXCZQH3EG
CNT_3480ATAKS3P0,TAG_2MSAF40PHDMG Initial D Omnibus CNT_3480ATAKS3P0 Action TAG_2MSAF40PHDMG
CNT_3480ATAKS3P0,TAG_2NH5Z5211KHG Initial D Omnibus CNT_3480ATAKS3P0 20th Century TAG_2NH5Z5211KHG
CNT_3480ATAKS3P0,TAG_3CTBM2Y283BG Initial D Omnibus CNT_3480ATAKS3P0 Coming of Age TAG_3CTBM2Y283BG
CNT_3480ATAKS3P0,TAG_3K715CVA9WWG Initial D Omnibus CNT_3480ATAKS3P0 Smoking TAG_3K715CVA9WWG
CNT_3480ATAKS3P0,TAG_3KY6Q5W995AG Initial D Omnibus CNT_3480ATAKS3P0 Slice of Life TAG_3KY6Q5W995AG
CNT_3480ATAKS3P0,TAG_3WRV58X4AK8G Initial D Omnibus CNT_3480ATAKS3P0 Racing TAG_3WRV58X4AK8G
CNT_3480ATAKS3P0,TAG_3XGAN9WGVS5G Initial D Omnibus CNT_3480ATAKS3P0 Romantic Subplot TAG_3XGAN9WGVS5G
CNT_3480ATAKS3P0,TAG_3Y9Y5N0XD7JG Initial D Omnibus CNT_3480ATAKS3P0 Personality Change TAG_3Y9Y5N0XD7JG
CNT_3480ATAKS3P0,TAG_3ZA83YSAT31G Initial D Omnibus CNT_3480ATAKS3P0 Primarily Adult Cast TAG_3ZA83YSAT31G

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