series_tags

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

21 rows where series_id = "CNT_1DXZXDATJDXG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1DXZXDATJDXG,TAG_0AMNE3F46BR0 My Girlfriend's a Geek CNT_1DXZXDATJDXG complete TAG_0AMNE3F46BR0
CNT_1DXZXDATJDXG,TAG_0M42TYMY92W0 My Girlfriend's a Geek CNT_1DXZXDATJDXG Comedy TAG_0M42TYMY92W0
CNT_1DXZXDATJDXG,TAG_0MV2CQSX9BA0 My Girlfriend's a Geek CNT_1DXZXDATJDXG safe TAG_0MV2CQSX9BA0
CNT_1DXZXDATJDXG,TAG_15HDDYY3R140 My Girlfriend's a Geek CNT_1DXZXDATJDXG Kind Male Lead TAG_15HDDYY3R140
CNT_1DXZXDATJDXG,TAG_1CZKT8ATGE20 My Girlfriend's a Geek CNT_1DXZXDATJDXG College TAG_1CZKT8ATGE20
CNT_1DXZXDATJDXG,TAG_1NPJ0W64TVK0 My Girlfriend's a Geek CNT_1DXZXDATJDXG Writing TAG_1NPJ0W64TVK0
CNT_1DXZXDATJDXG,TAG_1SB44Z39MSD0 My Girlfriend's a Geek CNT_1DXZXDATJDXG Older Female Younger Male TAG_1SB44Z39MSD0
CNT_1DXZXDATJDXG,TAG_1SEMDMPR46P0 My Girlfriend's a Geek CNT_1DXZXDATJDXG Office Worker TAG_1SEMDMPR46P0
CNT_1DXZXDATJDXG,TAG_1TCY4V5T9HS0 My Girlfriend's a Geek CNT_1DXZXDATJDXG Male Lead TAG_1TCY4V5T9HS0
CNT_1DXZXDATJDXG,TAG_2M2AXCZQH3EG My Girlfriend's a Geek CNT_1DXZXDATJDXG Drama TAG_2M2AXCZQH3EG
CNT_1DXZXDATJDXG,TAG_2M852Y701XZG My Girlfriend's a Geek CNT_1DXZXDATJDXG Shoujo TAG_2M852Y701XZG
CNT_1DXZXDATJDXG,TAG_2MBNBKTGHS0G My Girlfriend's a Geek CNT_1DXZXDATJDXG Romance TAG_2MBNBKTGHS0G
CNT_1DXZXDATJDXG,TAG_35AMS1P60PMG My Girlfriend's a Geek CNT_1DXZXDATJDXG Love At First Sight TAG_35AMS1P60PMG
CNT_1DXZXDATJDXG,TAG_38R2D1MGCJZG My Girlfriend's a Geek CNT_1DXZXDATJDXG Autobiographical TAG_38R2D1MGCJZG
CNT_1DXZXDATJDXG,TAG_3BD0MB7NCFSG My Girlfriend's a Geek CNT_1DXZXDATJDXG Appearance Different from Personality TAG_3BD0MB7NCFSG
CNT_1DXZXDATJDXG,TAG_3CCAGGGC8GQG My Girlfriend's a Geek CNT_1DXZXDATJDXG Cosplay TAG_3CCAGGGC8GQG
CNT_1DXZXDATJDXG,TAG_3G7K3MH76RKG My Girlfriend's a Geek CNT_1DXZXDATJDXG Subtle Romance TAG_3G7K3MH76RKG
CNT_1DXZXDATJDXG,TAG_3KY6Q5W995AG My Girlfriend's a Geek CNT_1DXZXDATJDXG Slice of Life TAG_3KY6Q5W995AG
CNT_1DXZXDATJDXG,TAG_3TB679CKHJBG My Girlfriend's a Geek CNT_1DXZXDATJDXG Male Lead Falls in Love First TAG_3TB679CKHJBG
CNT_1DXZXDATJDXG,TAG_3Y0ZQE5WD1RG My Girlfriend's a Geek CNT_1DXZXDATJDXG Parody TAG_3Y0ZQE5WD1RG
CNT_1DXZXDATJDXG,TAG_3YVF3WW3WQBG My Girlfriend's a Geek CNT_1DXZXDATJDXG Otaku TAG_3YVF3WW3WQBG

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