product_distributors

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

10 rows where distributor_id = "DST_1XA6J6E65WB0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id distributor_id
PRD_0B5XJKATCM9G,DST_1XA6J6E65WB0 Volume 1 PRD_0B5XJKATCM9G DST_1XA6J6E65WB0
PRD_0HPRWN7Y2T40,DST_1XA6J6E65WB0 Volume 1 PRD_0HPRWN7Y2T40 DST_1XA6J6E65WB0
PRD_0S9V6E15HFG0,DST_1XA6J6E65WB0 Volumes 1-2 PRD_0S9V6E15HFG0 DST_1XA6J6E65WB0
PRD_133WYWP2N050,DST_1XA6J6E65WB0 ALTERNATIVE PRD_133WYWP2N050 DST_1XA6J6E65WB0
PRD_1WDDK9MR9160,DST_1XA6J6E65WB0 Great Metal God PRD_1WDDK9MR9160 DST_1XA6J6E65WB0
PRD_220HK5F7KKZ0,DST_1XA6J6E65WB0 Princess Da Haung and Other Tales PRD_220HK5F7KKZ0 DST_1XA6J6E65WB0
PRD_2ZH3RRGAZE7G,DST_1XA6J6E65WB0 Volume 1 PRD_2ZH3RRGAZE7G DST_1XA6J6E65WB0
PRD_31B4Q517K0MG,DST_1XA6J6E65WB0 First Time In Taiwan: A Delicious Adventure PRD_31B4Q517K0MG DST_1XA6J6E65WB0
PRD_32TM5J7XQ1NG,DST_1XA6J6E65WB0 BONDS PRD_32TM5J7XQ1NG DST_1XA6J6E65WB0
PRD_3Y45TZ5VB2PG,DST_1XA6J6E65WB0 Volume 1 PRD_3Y45TZ5VB2PG DST_1XA6J6E65WB0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE product_distributors (
      product_id TEXT NOT NULL,
      distributor_id TEXT NOT NULL,
      PRIMARY KEY (product_id, distributor_id),
      FOREIGN KEY (product_id) REFERENCES products(id),
      FOREIGN KEY (distributor_id) REFERENCES distributors(id)
    );
CREATE INDEX idx_product_distributors_distributor ON product_distributors(distributor_id);