BookWalker

home / database

product_contributors

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

36 rows where contributor_id = "CON_17TY4SZDMH50"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_01ZN55TP0D5G,CON_17TY4SZDMH50,1 Taiwan, Chapter 9 PRD_01ZN55TP0D5G Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_04C5GRMRCC4G,CON_17TY4SZDMH50,1 Taiwan, Chapter 6 PRD_04C5GRMRCC4G Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_0B2M2BP28BBG,CON_17TY4SZDMH50,1 Taiwan, Chapter 5 PRD_0B2M2BP28BBG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_0FK7DYG4MAAG,CON_17TY4SZDMH50,1 Taiwan, Chapter 2 PRD_0FK7DYG4MAAG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_0TD1DDCY9CBG,CON_17TY4SZDMH50,1 Malaysia III, Chapter 10 PRD_0TD1DDCY9CBG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_0XETVJSC4E6G,CON_17TY4SZDMH50,1 Taiwan, Chapter 10 PRD_0XETVJSC4E6G Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_0YRA8ZZ9RF7G,CON_17TY4SZDMH50,1 Taiwan, Chapter 12 PRD_0YRA8ZZ9RF7G Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_10H5CFQJK89G,CON_17TY4SZDMH50,1 Taiwan, Chapter 11 PRD_10H5CFQJK89G Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_10WX5HEMK3J0,CON_17TY4SZDMH50,1 Hong Kong, Chapter 1 PRD_10WX5HEMK3J0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_133EDJP7SHQG,CON_17TY4SZDMH50,1 Malaysia III, Chapter 4 PRD_133EDJP7SHQG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_17HYZ5GA5GPG,CON_17TY4SZDMH50,1 Malaysia III, Chapter 2 PRD_17HYZ5GA5GPG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1J400JNT77F0,CON_17TY4SZDMH50,1 Hong Kong, Chapter 11 PRD_1J400JNT77F0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1NB3XRH6F5D0,CON_17TY4SZDMH50,1 Malaysia III, Chapter 11 PRD_1NB3XRH6F5D0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1PSDT6ZF9NKG,CON_17TY4SZDMH50,1 Malaysia III, Chapter 12 PRD_1PSDT6ZF9NKG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1PTGJ5QW36E0,CON_17TY4SZDMH50,1 Hong Kong, Chapter 9 PRD_1PTGJ5QW36E0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1SSJFBK8B4C0,CON_17TY4SZDMH50,1 Hong Kong, Chapter 5 PRD_1SSJFBK8B4C0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1SWCQCTVHKHG,CON_17TY4SZDMH50,1 Malaysia III, Chapter 8 PRD_1SWCQCTVHKHG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1WE2TYCJQ4K0,CON_17TY4SZDMH50,1 Hong Kong, Chapter 3 PRD_1WE2TYCJQ4K0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_1WJZ2ZMXXJGG,CON_17TY4SZDMH50,1 Malaysia III, Chapter 6 PRD_1WJZ2ZMXXJGG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_23PDCVBH2EP0,CON_17TY4SZDMH50,1 Taiwan, Chapter 8 PRD_23PDCVBH2EP0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_264XYE5VEDN0,CON_17TY4SZDMH50,1 Taiwan, Chapter 7 PRD_264XYE5VEDN0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_29BWMM17PBV0,CON_17TY4SZDMH50,1 Taiwan, Chapter 3 PRD_29BWMM17PBV0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_2ANC917XACM0,CON_17TY4SZDMH50,1 Taiwan, Chapter 4 PRD_2ANC917XACM0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_2DRF6739JAT0,CON_17TY4SZDMH50,1 Taiwan, Chapter 1 PRD_2DRF6739JAT0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_2H9QHE9DFKCG,CON_17TY4SZDMH50,1 Hong Kong, Chapter 12 PRD_2H9QHE9DFKCG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_2RT97QZ3QCV0,CON_17TY4SZDMH50,1 Malaysia III, Chapter 9 PRD_2RT97QZ3QCV0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3118PTPEAMW0,CON_17TY4SZDMH50,1 Malaysia III, Chapter 5 PRD_3118PTPEAMW0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_318P6V157G70,CON_17TY4SZDMH50,1 Malaysia III, Chapter 3 PRD_318P6V157G70 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_32QAK8ZQN32G,CON_17TY4SZDMH50,1 Hong Kong, Chapter 2 PRD_32QAK8ZQN32G Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_35S6GE3F3Z60,CON_17TY4SZDMH50,1 Malaysia III, Chapter 1 PRD_35S6GE3F3Z60 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3GD8SV4Z57YG,CON_17TY4SZDMH50,1 Hong Kong, Chapter 10 PRD_3GD8SV4Z57YG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3Q3VBE6116XG,CON_17TY4SZDMH50,1 Hong Kong, Chapter 8 PRD_3Q3VBE6116XG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3VDSE1RR6QZ0,CON_17TY4SZDMH50,1 Hong Kong, Chapter 7 PRD_3VDSE1RR6QZ0 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3VGBP10BD5WG,CON_17TY4SZDMH50,1 Hong Kong, Chapter 6 PRD_3VGBP10BD5WG Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3Y5Q9N5RZJ10,CON_17TY4SZDMH50,1 Malaysia III, Chapter 7 PRD_3Y5Q9N5RZJ10 Yap Zhuo Yong CON_17TY4SZDMH50 1  
PRD_3Y6T1M2D943G,CON_17TY4SZDMH50,1 Hong Kong, Chapter 4 PRD_3Y6T1M2D943G Yap Zhuo Yong CON_17TY4SZDMH50 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 13.823ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS