BookWalker

home / database

product_contributors

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

12 rows where contributor_id = "CON_1CYTWE8SJGQ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_1188YGRNCFX0,CON_1CYTWE8SJGQ0,10 Volume 11 - The Arch-Wizard's Little Sister PRD_1188YGRNCFX0 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_15YV83TZ8EW0,CON_1CYTWE8SJGQ0,10 Volume 7 - 110-Million Bride PRD_15YV83TZ8EW0 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_16NEVTSK4WEG,CON_1CYTWE8SJGQ0,10 Volume 5 - Crimson Magic Clan, Let's & Go!! PRD_16NEVTSK4WEG Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_1M54S6GPKTR0,CON_1CYTWE8SJGQ0,10 Volume 4 - You Good-for-Nothing Quartet PRD_1M54S6GPKTR0 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_1SX1925ZMBJ0,CON_1CYTWE8SJGQ0,10 Volume 3 - You're Being Summoned, Darkness PRD_1SX1925ZMBJ0 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_1VMYPP36R2R0,CON_1CYTWE8SJGQ0,10 Volume 10 - Gamble Scramble PRD_1VMYPP36R2R0 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_24PF9MB31N90,CON_1CYTWE8SJGQ0,10 Volume 1 - Oh! My Useless Goddess PRD_24PF9MB31N90 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_2MZFXP4DVT90,CON_1CYTWE8SJGQ0,10 Volume 2 - Love, Witches & Other Delusions! PRD_2MZFXP4DVT90 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_2Q1E85J0MSM0,CON_1CYTWE8SJGQ0,10 Volume 12 - The Knight's Lullaby PRD_2Q1E85J0MSM0 Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_37HGQSBTAECG,CON_1CYTWE8SJGQ0,10 Volume 6 - Princess of the Six Flowers PRD_37HGQSBTAECG Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_3NFPWDG1T28G,CON_1CYTWE8SJGQ0,10 Volume 8 - Axis Church vs. Eris Church PRD_3NFPWDG1T28G Arnie Pantoja CON_1CYTWE8SJGQ0 10  
PRD_3WJHTKCE20EG,CON_1CYTWE8SJGQ0,10 Volume 9 - Crimson Fate PRD_3WJHTKCE20EG Arnie Pantoja CON_1CYTWE8SJGQ0 10  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE product_contributors (
      product_id TEXT NOT NULL,
      contributor_id TEXT NOT NULL,
      role INTEGER NOT NULL,
      name_override TEXT,
      PRIMARY KEY (product_id, contributor_id, role),
      FOREIGN KEY (product_id) REFERENCES products(id),
      FOREIGN KEY (contributor_id) REFERENCES contributors(id)
    );
CREATE INDEX idx_product_contributors_contributor ON product_contributors(contributor_id);
Powered by Datasette · Queries took 8.894ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS