BookWalker

home / database

product_contributors

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

18 rows where contributor_id = "CON_03XEPSYTWPSG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00E0AYJE2NNG,CON_03XEPSYTWPSG,1 Volume 2 PRD_00E0AYJE2NNG PANDANIA CON_03XEPSYTWPSG 1  
PRD_06Y9AJSR0ZZG,CON_03XEPSYTWPSG,1 Volume 3 PRD_06Y9AJSR0ZZG PANDANIA CON_03XEPSYTWPSG 1  
PRD_076DNHHFNZ6G,CON_03XEPSYTWPSG,1 Volume 2 PRD_076DNHHFNZ6G PANDANIA CON_03XEPSYTWPSG 1  
PRD_0QPV8TVJTDKG,CON_03XEPSYTWPSG,1 Volume 6 PRD_0QPV8TVJTDKG PANDANIA CON_03XEPSYTWPSG 1  
PRD_12MHJKR4V3QG,CON_03XEPSYTWPSG,1 Volume 2 PRD_12MHJKR4V3QG PANDANIA CON_03XEPSYTWPSG 1  
PRD_12WHVBT7B7V0,CON_03XEPSYTWPSG,1 Volume 1 PRD_12WHVBT7B7V0 PANDANIA CON_03XEPSYTWPSG 1  
PRD_15W1A6M4PEFG,CON_03XEPSYTWPSG,1 Volume 8 PRD_15W1A6M4PEFG PANDANIA CON_03XEPSYTWPSG 1  
PRD_1JVNQ9KX230G,CON_03XEPSYTWPSG,1 Volume 7 PRD_1JVNQ9KX230G PANDANIA CON_03XEPSYTWPSG 1  
PRD_1QJJKRB9N230,CON_03XEPSYTWPSG,1 Volume 10 PRD_1QJJKRB9N230 PANDANIA CON_03XEPSYTWPSG 1  
PRD_1Z8WEG6X04VG,CON_03XEPSYTWPSG,1 Volume 1 PRD_1Z8WEG6X04VG PANDANIA CON_03XEPSYTWPSG 1  
PRD_20YHBVDVHQ9G,CON_03XEPSYTWPSG,1 Volume 3 PRD_20YHBVDVHQ9G PANDANIA CON_03XEPSYTWPSG 1  
PRD_29W4REXPZYN0,CON_03XEPSYTWPSG,1 Volume 2 PRD_29W4REXPZYN0 PANDANIA CON_03XEPSYTWPSG 1  
PRD_2CW4AV7JRP5G,CON_03XEPSYTWPSG,1 Volume 1 PRD_2CW4AV7JRP5G PANDANIA CON_03XEPSYTWPSG 1  
PRD_2E54494BNKK0,CON_03XEPSYTWPSG,1 Volume 3 PRD_2E54494BNKK0 PANDANIA CON_03XEPSYTWPSG 1  
PRD_2MSQECF68440,CON_03XEPSYTWPSG,1 Volume 1 PRD_2MSQECF68440 PANDANIA CON_03XEPSYTWPSG 1  
PRD_34C934RHY180,CON_03XEPSYTWPSG,1 Volume 4 PRD_34C934RHY180 PANDANIA CON_03XEPSYTWPSG 1  
PRD_3DT35H68GZHG,CON_03XEPSYTWPSG,1 Volume 5 PRD_3DT35H68GZHG PANDANIA CON_03XEPSYTWPSG 1  
PRD_3RKP2M7EVK50,CON_03XEPSYTWPSG,1 Volume 9 PRD_3RKP2M7EVK50 PANDANIA CON_03XEPSYTWPSG 1  

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 7.964ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS