series_tags

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

11 rows where series_id = "CNT_0NYA8R4PB7ZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0NYA8R4PB7ZG,TAG_0AMNE3F46BR0 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG complete TAG_0AMNE3F46BR0
CNT_0NYA8R4PB7ZG,TAG_0M0JHS1FS5V0 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Fantasy TAG_0M0JHS1FS5V0
CNT_0NYA8R4PB7ZG,TAG_0NPD5CER9Y80 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Shounen TAG_0NPD5CER9Y80
CNT_0NYA8R4PB7ZG,TAG_1FJH543XKFG0 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Child Abuse TAG_1FJH543XKFG0
CNT_0NYA8R4PB7ZG,TAG_1P3QSYSHW6X0 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Tragedy TAG_1P3QSYSHW6X0
CNT_0NYA8R4PB7ZG,TAG_1TCY4V5T9HS0 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Male Lead TAG_1TCY4V5T9HS0
CNT_0NYA8R4PB7ZG,TAG_1TTZRDKR94D0 Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Mages TAG_1TTZRDKR94D0
CNT_0NYA8R4PB7ZG,TAG_2MSAF40PHDMG Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Action TAG_2MSAF40PHDMG
CNT_0NYA8R4PB7ZG,TAG_3AY7M95EEJ3G Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Adventure TAG_3AY7M95EEJ3G
CNT_0NYA8R4PB7ZG,TAG_3QWYN1HM5ADG Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Travel TAG_3QWYN1HM5ADG
CNT_0NYA8R4PB7ZG,TAG_3TS7WVTHH6ZG Fairy Tail Ice Trail CNT_0NYA8R4PB7ZG Magic TAG_3TS7WVTHH6ZG

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