BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_1Z5DP9ZENP60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_00VKP6RYVJQG,CON_1Z5DP9ZENP60,1 Chapter 16 PRD_00VKP6RYVJQG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0703S6X7E0YG,CON_1Z5DP9ZENP60,1 Chapter 30 PRD_0703S6X7E0YG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_07821ST17HPG,CON_1Z5DP9ZENP60,1 Chapter 15 PRD_07821ST17HPG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0BYJKCMB3GNG,CON_1Z5DP9ZENP60,1 Chapter 13 PRD_0BYJKCMB3GNG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0E8GPYE1S1Q0,CON_1Z5DP9ZENP60,1 Chapter 12 PRD_0E8GPYE1S1Q0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0EFDYZPDFZMG,CON_1Z5DP9ZENP60,1 Chapter 11 PRD_0EFDYZPDFZMG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0J36H67WFPCG,CON_1Z5DP9ZENP60,1 Chapter 6 PRD_0J36H67WFPCG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0N60EC38QNJG,CON_1Z5DP9ZENP60,1 Chapter 21 PRD_0N60EC38QNJG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0PHHWS16BPKG,CON_1Z5DP9ZENP60,1 Chapter 4 PRD_0PHHWS16BPKG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_0W534KYMZKGG,CON_1Z5DP9ZENP60,1 Chapter 19 PRD_0W534KYMZKGG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_18X3NG967VF0,CON_1Z5DP9ZENP60,1 Chapter 35 PRD_18X3NG967VF0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_195EDATN58Y0,CON_1Z5DP9ZENP60,1 Chapter 9 PRD_195EDATN58Y0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_1DVYRXMZ1QX0,CON_1Z5DP9ZENP60,1 Chapter 7 PRD_1DVYRXMZ1QX0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_1JXW9JKQBYVG,CON_1Z5DP9ZENP60,1 Chapter 1 PRD_1JXW9JKQBYVG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_1NW2YQ7GDEM0,CON_1Z5DP9ZENP60,1 Chapter 3 PRD_1NW2YQ7GDEM0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_1RJX8A1T9DV0,CON_1Z5DP9ZENP60,1 Chapter 20 PRD_1RJX8A1T9DV0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_1VZ3ABQ1NCV0,CON_1Z5DP9ZENP60,1 Chapter 26 PRD_1VZ3ABQ1NCV0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_1WX3RJFM1XJ0,CON_1Z5DP9ZENP60,1 Chapter 28 PRD_1WX3RJFM1XJ0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_22BCDVY30PX0,CON_1Z5DP9ZENP60,1 Chapter 19.5 PRD_22BCDVY30PX0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_2571TZAGZ8R0,CON_1Z5DP9ZENP60,1 Chapter 18 PRD_2571TZAGZ8R0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_25HAT2565G60,CON_1Z5DP9ZENP60,1 Chapter 14 PRD_25HAT2565G60 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_26W97E3GK31G,CON_1Z5DP9ZENP60,1 Chapter 17 PRD_26W97E3GK31G Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_2CMNQ80JDY40,CON_1Z5DP9ZENP60,1 Chapter 10 PRD_2CMNQ80JDY40 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_2G89BGP1DPW0,CON_1Z5DP9ZENP60,1 Chapter 5 PRD_2G89BGP1DPW0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_2GAFF42S67M0,CON_1Z5DP9ZENP60,1 Chapter 29 PRD_2GAFF42S67M0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_2VJBS1NVQJN0,CON_1Z5DP9ZENP60,1 Chapter 33 PRD_2VJBS1NVQJN0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_2ZSEA844B53G,CON_1Z5DP9ZENP60,1 Chapter 2 PRD_2ZSEA844B53G Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_30JRV7SHXNZG,CON_1Z5DP9ZENP60,1 Chapter 32 PRD_30JRV7SHXNZG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_347M2THC5SQG,CON_1Z5DP9ZENP60,1 Chapter 31 PRD_347M2THC5SQG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_39AAETRB5VYG,CON_1Z5DP9ZENP60,1 Chapter 34 PRD_39AAETRB5VYG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3ANV37Y0SWZG,CON_1Z5DP9ZENP60,1 Chapter 36 PRD_3ANV37Y0SWZG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3FJP7K5T3QDG,CON_1Z5DP9ZENP60,1 Chapter 8 PRD_3FJP7K5T3QDG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3K3A0QMW8EDG,CON_1Z5DP9ZENP60,1 Chapter 22 PRD_3K3A0QMW8EDG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3R4BWM66KBAG,CON_1Z5DP9ZENP60,1 Chapter 25 PRD_3R4BWM66KBAG Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3TSQVDZ3WQE0,CON_1Z5DP9ZENP60,1 Chapter 27 PRD_3TSQVDZ3WQE0 Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3VZEDV0J708G,CON_1Z5DP9ZENP60,1 Chapter 23 PRD_3VZEDV0J708G Awaji Nae CON_1Z5DP9ZENP60 1  
PRD_3YWM23GKB3C0,CON_1Z5DP9ZENP60,1 Chapter 24 PRD_3YWM23GKB3C0 Awaji Nae CON_1Z5DP9ZENP60 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.941ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS