series_tags

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

25 rows where series_id = "CNT_1VFHEMZBD3JG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1VFHEMZBD3JG,TAG_0AMNE3F46BR0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG complete TAG_0AMNE3F46BR0
CNT_1VFHEMZBD3JG,TAG_0M42TYMY92W0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Comedy TAG_0M42TYMY92W0
CNT_1VFHEMZBD3JG,TAG_0NPD5CER9Y80 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Shounen TAG_0NPD5CER9Y80
CNT_1VFHEMZBD3JG,TAG_0NZDKK5S9M20 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG 21st Century TAG_0NZDKK5S9M20
CNT_1VFHEMZBD3JG,TAG_12QZ8H22HHJ0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Dead Family Member/s TAG_12QZ8H22HHJ0
CNT_1VFHEMZBD3JG,TAG_13T9H8JRFAD0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Ecchi TAG_13T9H8JRFAD0
CNT_1VFHEMZBD3JG,TAG_15MJPJDJ8E90 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Kidnapping TAG_15MJPJDJ8E90
CNT_1VFHEMZBD3JG,TAG_18STAKDR4GD0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Attempted Murder TAG_18STAKDR4GD0
CNT_1VFHEMZBD3JG,TAG_1FJH543XKFG0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Child Abuse TAG_1FJH543XKFG0
CNT_1VFHEMZBD3JG,TAG_1GSBF6EFY610 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Student-Teacher Relationship TAG_1GSBF6EFY610
CNT_1VFHEMZBD3JG,TAG_1HFNJHDNZW50 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Teachers TAG_1HFNJHDNZW50
CNT_1VFHEMZBD3JG,TAG_1Q0HX10YX5F0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Unrequited Love TAG_1Q0HX10YX5F0
CNT_1VFHEMZBD3JG,TAG_1Q7H0T5XXFN0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Twins TAG_1Q7H0T5XXFN0
CNT_1VFHEMZBD3JG,TAG_1X0XMNRA3Q20 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG School TAG_1X0XMNRA3Q20
CNT_1VFHEMZBD3JG,TAG_1YM4H7YAMZ70 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Older Sister TAG_1YM4H7YAMZ70
CNT_1VFHEMZBD3JG,TAG_1YX7FENBMPS0 GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Orphans TAG_1YX7FENBMPS0
CNT_1VFHEMZBD3JG,TAG_2M2AXCZQH3EG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Drama TAG_2M2AXCZQH3EG
CNT_1VFHEMZBD3JG,TAG_2MSAF40PHDMG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Action TAG_2MSAF40PHDMG
CNT_1VFHEMZBD3JG,TAG_2N8QF7XXYSJG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Adoption TAG_2N8QF7XXYSJG
CNT_1VFHEMZBD3JG,TAG_32Z7SP0V69PG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Delinquents TAG_32Z7SP0V69PG
CNT_1VFHEMZBD3JG,TAG_3GYGNDT662SG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Strong Male Lead TAG_3GYGNDT662SG
CNT_1VFHEMZBD3JG,TAG_3KN6TX189FGG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Sisters TAG_3KN6TX189FGG
CNT_1VFHEMZBD3JG,TAG_3X845AY38F6G GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG School Life TAG_3X845AY38F6G
CNT_1VFHEMZBD3JG,TAG_3YDEEAPDX4QG GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Past Plays a Big Role TAG_3YDEEAPDX4QG
CNT_1VFHEMZBD3JG,TAG_3ZPEWHDEXT9G GTO: 14 Days in Shonan CNT_1VFHEMZBD3JG Perverted Male Lead TAG_3ZPEWHDEXT9G

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