series_tags

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

9 rows where tag_id = "TAG_31QJNRPRMRNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0280EZQFR5QG,TAG_31QJNRPRMRNG My Boyfriend in Orange CNT_0280EZQFR5QG Firefighters TAG_31QJNRPRMRNG
CNT_06H6DE23M4PG,TAG_31QJNRPRMRNG Fire in His Fingertips: A Flirty Fireman Ravishes Me with His Smoldering Gaze CNT_06H6DE23M4PG Firefighters TAG_31QJNRPRMRNG
CNT_0D7X9KHZNNV0,TAG_31QJNRPRMRNG Ride Your Wave Manga CNT_0D7X9KHZNNV0 Firefighters TAG_31QJNRPRMRNG
CNT_0FJZYRMSZ4Z0,TAG_31QJNRPRMRNG Fire Force CNT_0FJZYRMSZ4Z0 Firefighters TAG_31QJNRPRMRNG
CNT_0YC3TKME9KVG,TAG_31QJNRPRMRNG Yaoi Café With A Firefighter CNT_0YC3TKME9KVG Firefighters TAG_31QJNRPRMRNG
CNT_1W8Y3QGGMPAG,TAG_31QJNRPRMRNG Fire in His Fingertips CNT_1W8Y3QGGMPAG Firefighters TAG_31QJNRPRMRNG
CNT_22TN9G5F0NHG,TAG_31QJNRPRMRNG Firefighter!: Daigo of Fire Company M CNT_22TN9G5F0NHG Firefighters TAG_31QJNRPRMRNG
CNT_26CB519A80A0,TAG_31QJNRPRMRNG Fairy Tail: 100 Years Quest CNT_26CB519A80A0 Firefighters TAG_31QJNRPRMRNG
CNT_2B86F4F6CRR0,TAG_31QJNRPRMRNG Ride Your Wave Light Novel CNT_2B86F4F6CRR0 Firefighters TAG_31QJNRPRMRNG

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