BookWalker

home / database

product_contributors

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

37 rows where contributor_id = "CON_34CT2TVEBDD0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

Link product_id contributor_id role name_override
PRD_07PGGZ75FQMG,CON_34CT2TVEBDD0,1 Volume 6 PRD_07PGGZ75FQMG Hiroyuki CON_34CT2TVEBDD0 1  
PRD_09XYG2N74DK0,CON_34CT2TVEBDD0,1 Two-Timing Fair and Square PRD_09XYG2N74DK0 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_0BB7QK370VS0,CON_34CT2TVEBDD0,24 Volume 8 PRD_0BB7QK370VS0 Hiroyuki CON_34CT2TVEBDD0 24  
PRD_0D4A9E4C3YMG,CON_34CT2TVEBDD0,24 Volume 3 PRD_0D4A9E4C3YMG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_0EG9HG82TR40,CON_34CT2TVEBDD0,1 Volume 5 PRD_0EG9HG82TR40 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_0HDYDT7F2TXG,CON_34CT2TVEBDD0,24 Volume 2 PRD_0HDYDT7F2TXG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_0Q6YZ8ZNDVN0,CON_34CT2TVEBDD0,1 Volume 10 PRD_0Q6YZ8ZNDVN0 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_12C0SN38P2A0,CON_34CT2TVEBDD0,2 Volume 14 PRD_12C0SN38P2A0 Hiroyuki CON_34CT2TVEBDD0 2  
PRD_12C0SN38P2A0,CON_34CT2TVEBDD0,24 Volume 14 PRD_12C0SN38P2A0 Hiroyuki CON_34CT2TVEBDD0 24  
PRD_1ACEAS3PM9HG,CON_34CT2TVEBDD0,1 Volume 7 PRD_1ACEAS3PM9HG Hiroyuki CON_34CT2TVEBDD0 1  
PRD_1DG6MME62N0G,CON_34CT2TVEBDD0,1 Volume 9 PRD_1DG6MME62N0G Hiroyuki CON_34CT2TVEBDD0 1  
PRD_1KCV9NTY6MN0,CON_34CT2TVEBDD0,2 Volume 12 PRD_1KCV9NTY6MN0 Hiroyuki CON_34CT2TVEBDD0 2  
PRD_1KCV9NTY6MN0,CON_34CT2TVEBDD0,24 Volume 12 PRD_1KCV9NTY6MN0 Hiroyuki CON_34CT2TVEBDD0 24  
PRD_1M2G5BVTZK20,CON_34CT2TVEBDD0,2 Volume 15 PRD_1M2G5BVTZK20 Hiroyuki CON_34CT2TVEBDD0 2  
PRD_1M2G5BVTZK20,CON_34CT2TVEBDD0,24 Volume 15 PRD_1M2G5BVTZK20 Hiroyuki CON_34CT2TVEBDD0 24  
PRD_1R6JKSVF4GBG,CON_34CT2TVEBDD0,24 Volume 10 PRD_1R6JKSVF4GBG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_1RGR9RN3DPJG,CON_34CT2TVEBDD0,1 Volume 11 PRD_1RGR9RN3DPJG Hiroyuki CON_34CT2TVEBDD0 1  
PRD_1SVQFYZ7PWMG,CON_34CT2TVEBDD0,2 Volume 16 PRD_1SVQFYZ7PWMG Hiroyuki CON_34CT2TVEBDD0 2  
PRD_1SVQFYZ7PWMG,CON_34CT2TVEBDD0,24 Volume 16 PRD_1SVQFYZ7PWMG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_20QDHN2W6R7G,CON_34CT2TVEBDD0,24 Volume 1 PRD_20QDHN2W6R7G Hiroyuki CON_34CT2TVEBDD0 24  
PRD_24DP61BECB0G,CON_34CT2TVEBDD0,1 Volume 8 PRD_24DP61BECB0G Hiroyuki CON_34CT2TVEBDD0 1  
PRD_273N441CQGZ0,CON_34CT2TVEBDD0,1 Of Girls, Love, and Money PRD_273N441CQGZ0 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_2CFKMTMC7200,CON_34CT2TVEBDD0,1 Volume 3 PRD_2CFKMTMC7200 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_2HC7MDGR582G,CON_34CT2TVEBDD0,24 Volume 6 PRD_2HC7MDGR582G Hiroyuki CON_34CT2TVEBDD0 24  
PRD_2KYTXKNV24TG,CON_34CT2TVEBDD0,1 Angel Girl PRD_2KYTXKNV24TG Hiroyuki CON_34CT2TVEBDD0 1  
PRD_2Z3P7PH5BJC0,CON_34CT2TVEBDD0,1 Volume 4 PRD_2Z3P7PH5BJC0 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_34QMK588BEK0,CON_34CT2TVEBDD0,2 Volume 13 PRD_34QMK588BEK0 Hiroyuki CON_34CT2TVEBDD0 2  
PRD_34QMK588BEK0,CON_34CT2TVEBDD0,24 Volume 13 PRD_34QMK588BEK0 Hiroyuki CON_34CT2TVEBDD0 24  
PRD_3ABETSTHB4QG,CON_34CT2TVEBDD0,24 Volume 4 PRD_3ABETSTHB4QG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_3C1369XQ101G,CON_34CT2TVEBDD0,1 Volume 1 PRD_3C1369XQ101G Hiroyuki CON_34CT2TVEBDD0 1  
PRD_3KA01K8S0EEG,CON_34CT2TVEBDD0,24 Volume 7 PRD_3KA01K8S0EEG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_3NF1K3G7EKV0,CON_34CT2TVEBDD0,2 Volume 11 PRD_3NF1K3G7EKV0 Hiroyuki CON_34CT2TVEBDD0 2  
PRD_3NF1K3G7EKV0,CON_34CT2TVEBDD0,24 Volume 11 PRD_3NF1K3G7EKV0 Hiroyuki CON_34CT2TVEBDD0 24  
PRD_3Q8W5RE6XFP0,CON_34CT2TVEBDD0,1 Volume 12 PRD_3Q8W5RE6XFP0 Hiroyuki CON_34CT2TVEBDD0 1  
PRD_3R4Q7JX69HEG,CON_34CT2TVEBDD0,1 Volume 2 PRD_3R4Q7JX69HEG Hiroyuki CON_34CT2TVEBDD0 1  
PRD_3RVM46W80ADG,CON_34CT2TVEBDD0,24 Volume 5 PRD_3RVM46W80ADG Hiroyuki CON_34CT2TVEBDD0 24  
PRD_3RYP3B2N85N0,CON_34CT2TVEBDD0,24 Volume 9 PRD_3RYP3B2N85N0 Hiroyuki CON_34CT2TVEBDD0 24  

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