series_tags

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

7 rows where tag_id = "TAG_18FAY6NAN920"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0KZJP1CA6X30,TAG_18FAY6NAN920 Aggressive Sex with an Angelic Smile CNT_0KZJP1CA6X30 Bara TAG_18FAY6NAN920
CNT_137DYS871YQG,TAG_18FAY6NAN920 Ramen Wolf and Curry Tiger CNT_137DYS871YQG Bara TAG_18FAY6NAN920
CNT_1DSDGX86P0CG,TAG_18FAY6NAN920 Lovesick Odd Couple CNT_1DSDGX86P0CG Bara TAG_18FAY6NAN920
CNT_1HAN3929WJ60,TAG_18FAY6NAN920 All Eyes on Nekoyashiki-kun! Notice Me, Not My Characters CNT_1HAN3929WJ60 Bara TAG_18FAY6NAN920
CNT_1QS7EAY8NN2G,TAG_18FAY6NAN920 My Adorable Betrothed CNT_1QS7EAY8NN2G Bara TAG_18FAY6NAN920
CNT_309J9471B980,TAG_18FAY6NAN920 Amaregulus: Soldier & Soother CNT_309J9471B980 Bara TAG_18FAY6NAN920
CNT_3PT70GTS8D8G,TAG_18FAY6NAN920 Time to Grope and Suck CNT_3PT70GTS8D8G Bara TAG_18FAY6NAN920

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