BookWalker

home / database

product_contributors

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

38 rows where contributor_id = "CON_286GRTGPC6GG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id contributor_id role name_override
PRD_0BFDFPGHXAQG,CON_286GRTGPC6GG,1 Chapter 3 PRD_0BFDFPGHXAQG Airi Katsura CON_286GRTGPC6GG 1  
PRD_0C0XRH5NBWP0,CON_286GRTGPC6GG,1 Chapter 13 PRD_0C0XRH5NBWP0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_0FXXS9JVS9PG,CON_286GRTGPC6GG,1 Chapter 4 PRD_0FXXS9JVS9PG Airi Katsura CON_286GRTGPC6GG 1  
PRD_0HH29P2Z6KF0,CON_286GRTGPC6GG,1 Chapter 5 PRD_0HH29P2Z6KF0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_0ND8QAYGJ3H0,CON_286GRTGPC6GG,1 Chapter 2 PRD_0ND8QAYGJ3H0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_0NHC2BH2AR4G,CON_286GRTGPC6GG,1 Chapter 17 PRD_0NHC2BH2AR4G Airi Katsura CON_286GRTGPC6GG 1  
PRD_0RC0Z3W8E4T0,CON_286GRTGPC6GG,1 Chapter 18 PRD_0RC0Z3W8E4T0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_0RMD6XYBEHD0,CON_286GRTGPC6GG,1 Chapter 6 PRD_0RMD6XYBEHD0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_0YT2AFB0QDRG,CON_286GRTGPC6GG,1 Chapter 16 PRD_0YT2AFB0QDRG Airi Katsura CON_286GRTGPC6GG 1  
PRD_0Z9CSAYZP2PG,CON_286GRTGPC6GG,1 Chapter 9 PRD_0Z9CSAYZP2PG Airi Katsura CON_286GRTGPC6GG 1  
PRD_117SX1R188VG,CON_286GRTGPC6GG,1 Chapter 7 PRD_117SX1R188VG Airi Katsura CON_286GRTGPC6GG 1  
PRD_1195EV6YTQ3G,CON_286GRTGPC6GG,1 Chapter 10 PRD_1195EV6YTQ3G Airi Katsura CON_286GRTGPC6GG 1  
PRD_11NTAQ765CZ0,CON_286GRTGPC6GG,1 Chapter 14 PRD_11NTAQ765CZ0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_15917QY39SM0,CON_286GRTGPC6GG,1 Chapter 16 PRD_15917QY39SM0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_1HXBF33KB0CG,CON_286GRTGPC6GG,1 Chapter 8 PRD_1HXBF33KB0CG Airi Katsura CON_286GRTGPC6GG 1  
PRD_1JQFSB6K3RNG,CON_286GRTGPC6GG,1 Chapter 17 PRD_1JQFSB6K3RNG Airi Katsura CON_286GRTGPC6GG 1  
PRD_1MPM2Q50XYH0,CON_286GRTGPC6GG,1 Chapter 12 PRD_1MPM2Q50XYH0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_1QTQG70AD0M0,CON_286GRTGPC6GG,1 Chapter 12 PRD_1QTQG70AD0M0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_1S3XWS194J90,CON_286GRTGPC6GG,1 Chapter 15 PRD_1S3XWS194J90 Airi Katsura CON_286GRTGPC6GG 1  
PRD_1YBVHNAJJ9XG,CON_286GRTGPC6GG,1 Chapter 8 PRD_1YBVHNAJJ9XG Airi Katsura CON_286GRTGPC6GG 1  
PRD_1ZJ8FWHP8ZC0,CON_286GRTGPC6GG,1 Chapter 18 PRD_1ZJ8FWHP8ZC0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_1ZNQZX1D5WQ0,CON_286GRTGPC6GG,1 Chapter 10 PRD_1ZNQZX1D5WQ0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_21JZRDEQAXB0,CON_286GRTGPC6GG,1 Chapter 3 PRD_21JZRDEQAXB0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_22WMQ5PFQE60,CON_286GRTGPC6GG,1 Chapter 20 PRD_22WMQ5PFQE60 Airi Katsura CON_286GRTGPC6GG 1  
PRD_243EB08SPWA0,CON_286GRTGPC6GG,1 Chapter 4 PRD_243EB08SPWA0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_28NJ1NXDBHWG,CON_286GRTGPC6GG,1 Chapter 9 PRD_28NJ1NXDBHWG Airi Katsura CON_286GRTGPC6GG 1  
PRD_29MN0Z3PV970,CON_286GRTGPC6GG,1 Chapter 1 PRD_29MN0Z3PV970 Airi Katsura CON_286GRTGPC6GG 1  
PRD_2C55KKXS7860,CON_286GRTGPC6GG,1 Chapter 2 PRD_2C55KKXS7860 Airi Katsura CON_286GRTGPC6GG 1  
PRD_2MSD1BG5MB10,CON_286GRTGPC6GG,1 Chapter 19 PRD_2MSD1BG5MB10 Airi Katsura CON_286GRTGPC6GG 1  
PRD_2VX1WNBJZPSG,CON_286GRTGPC6GG,1 Chapter 15 PRD_2VX1WNBJZPSG Airi Katsura CON_286GRTGPC6GG 1  
PRD_2X00SV7Z7MZG,CON_286GRTGPC6GG,1 Chapter 11 PRD_2X00SV7Z7MZG Airi Katsura CON_286GRTGPC6GG 1  
PRD_2YB3V6BZW17G,CON_286GRTGPC6GG,1 Chapter 6 PRD_2YB3V6BZW17G Airi Katsura CON_286GRTGPC6GG 1  
PRD_2YF76729N7V0,CON_286GRTGPC6GG,1 Chapter 14 PRD_2YF76729N7V0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_331JNJQSWQC0,CON_286GRTGPC6GG,1 Chapter 7 PRD_331JNJQSWQC0 Airi Katsura CON_286GRTGPC6GG 1  
PRD_3J91GJ2Z0C90,CON_286GRTGPC6GG,1 Chapter 11 PRD_3J91GJ2Z0C90 Airi Katsura CON_286GRTGPC6GG 1  
PRD_3P6ZNCR6GA8G,CON_286GRTGPC6GG,1 Chapter 5 PRD_3P6ZNCR6GA8G Airi Katsura CON_286GRTGPC6GG 1  
PRD_3P9C8ET3ZY1G,CON_286GRTGPC6GG,1 Chapter 13 PRD_3P9C8ET3ZY1G Airi Katsura CON_286GRTGPC6GG 1  
PRD_3S5YKJQJR8EG,CON_286GRTGPC6GG,1 Chapter 1 PRD_3S5YKJQJR8EG Airi Katsura CON_286GRTGPC6GG 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 11.754ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS