BookWalker

home / database

series_tags

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

28 rows where series_id = "CNT_3Z782GFC4ZZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3Z782GFC4ZZG,TAG_0AMNE3F46BR0 Fairy Cube CNT_3Z782GFC4ZZG complete TAG_0AMNE3F46BR0
CNT_3Z782GFC4ZZG,TAG_0M0JHS1FS5V0 Fairy Cube CNT_3Z782GFC4ZZG Fantasy TAG_0M0JHS1FS5V0
CNT_3Z782GFC4ZZG,TAG_0MV2CQSX9BA0 Fairy Cube CNT_3Z782GFC4ZZG safe TAG_0MV2CQSX9BA0
CNT_3Z782GFC4ZZG,TAG_11P58PSGWS60 Fairy Cube CNT_3Z782GFC4ZZG First Love TAG_11P58PSGWS60
CNT_3Z782GFC4ZZG,TAG_13C8W64TF7S0 Fairy Cube CNT_3Z782GFC4ZZG Ensemble Cast TAG_13C8W64TF7S0
CNT_3Z782GFC4ZZG,TAG_158WXZSY8Q10 Fairy Cube CNT_3Z782GFC4ZZG Love Confession TAG_158WXZSY8Q10
CNT_3Z782GFC4ZZG,TAG_17KHA2S9A570 Fairy Cube CNT_3Z782GFC4ZZG Heterosexual TAG_17KHA2S9A570
CNT_3Z782GFC4ZZG,TAG_1904WEK65PH0 Fairy Cube CNT_3Z782GFC4ZZG Body Swapping TAG_1904WEK65PH0
CNT_3Z782GFC4ZZG,TAG_1AASAHGH74Q0 Fairy Cube CNT_3Z782GFC4ZZG Alternate Universe TAG_1AASAHGH74Q0
CNT_3Z782GFC4ZZG,TAG_1DKX1NP6H8T0 Fairy Cube CNT_3Z782GFC4ZZG Crimes TAG_1DKX1NP6H8T0
CNT_3Z782GFC4ZZG,TAG_1FJH543XKFG0 Fairy Cube CNT_3Z782GFC4ZZG Child Abuse TAG_1FJH543XKFG0
CNT_3Z782GFC4ZZG,TAG_1FZ1W0CD32F0 Fairy Cube CNT_3Z782GFC4ZZG Childhood Friends TAG_1FZ1W0CD32F0
CNT_3Z782GFC4ZZG,TAG_1GBABM09YKD0 Fairy Cube CNT_3Z782GFC4ZZG Supernatural TAG_1GBABM09YKD0
CNT_3Z782GFC4ZZG,TAG_1KE9P1SCHK30 Fairy Cube CNT_3Z782GFC4ZZG Spirits TAG_1KE9P1SCHK30
CNT_3Z782GFC4ZZG,TAG_1P3QSYSHW6X0 Fairy Cube CNT_3Z782GFC4ZZG Tragedy TAG_1P3QSYSHW6X0
CNT_3Z782GFC4ZZG,TAG_1Q7H0T5XXFN0 Fairy Cube CNT_3Z782GFC4ZZG Twins TAG_1Q7H0T5XXFN0
CNT_3Z782GFC4ZZG,TAG_1QD1MDDEDRA0 Fairy Cube CNT_3Z782GFC4ZZG Urban Fantasy TAG_1QD1MDDEDRA0
CNT_3Z782GFC4ZZG,TAG_1RAA6QAW7XY0 Fairy Cube CNT_3Z782GFC4ZZG Mystery TAG_1RAA6QAW7XY0
CNT_3Z782GFC4ZZG,TAG_1SPTXKQDQGN0 Fairy Cube CNT_3Z782GFC4ZZG Mythology TAG_1SPTXKQDQGN0
CNT_3Z782GFC4ZZG,TAG_1TCY4V5T9HS0 Fairy Cube CNT_3Z782GFC4ZZG Male Lead TAG_1TCY4V5T9HS0
CNT_3Z782GFC4ZZG,TAG_1W924MYZK110 Fairy Cube CNT_3Z782GFC4ZZG Revenge TAG_1W924MYZK110
CNT_3Z782GFC4ZZG,TAG_1X0XMNRA3Q20 Fairy Cube CNT_3Z782GFC4ZZG School TAG_1X0XMNRA3Q20
CNT_3Z782GFC4ZZG,TAG_2M2AXCZQH3EG Fairy Cube CNT_3Z782GFC4ZZG Drama TAG_2M2AXCZQH3EG
CNT_3Z782GFC4ZZG,TAG_2M852Y701XZG Fairy Cube CNT_3Z782GFC4ZZG Shoujo TAG_2M852Y701XZG
CNT_3Z782GFC4ZZG,TAG_2MBNBKTGHS0G Fairy Cube CNT_3Z782GFC4ZZG Romance TAG_2MBNBKTGHS0G
CNT_3Z782GFC4ZZG,TAG_2MSAF40PHDMG Fairy Cube CNT_3Z782GFC4ZZG Action TAG_2MSAF40PHDMG
CNT_3Z782GFC4ZZG,TAG_3K01KKPB9JPG Fairy Cube CNT_3Z782GFC4ZZG Special Ability TAG_3K01KKPB9JPG
CNT_3Z782GFC4ZZG,TAG_3TS7WVTHH6ZG Fairy Cube CNT_3Z782GFC4ZZG 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);
Powered by Datasette · Queries took 8.643ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS