product_distributors

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

11 rows where distributor_id = "DST_1SSBM8MBS23G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id distributor_id
PRD_02FC2C2XB060,DST_1SSBM8MBS23G Volume 2 PRD_02FC2C2XB060 DST_1SSBM8MBS23G
PRD_05JFRKY9KE40,DST_1SSBM8MBS23G Volume 4 PRD_05JFRKY9KE40 DST_1SSBM8MBS23G
PRD_06XZD0W7QF50,DST_1SSBM8MBS23G Volume 1 PRD_06XZD0W7QF50 DST_1SSBM8MBS23G
PRD_0MVJVK5F7310,DST_1SSBM8MBS23G Volume 1 PRD_0MVJVK5F7310 DST_1SSBM8MBS23G
PRD_0V8D566H3200,DST_1SSBM8MBS23G Volume 2 PRD_0V8D566H3200 DST_1SSBM8MBS23G
PRD_0ZYXGS0VF170,DST_1SSBM8MBS23G Volume 1 PRD_0ZYXGS0VF170 DST_1SSBM8MBS23G
PRD_20MMMPD290NG,DST_1SSBM8MBS23G Volume 2 PRD_20MMMPD290NG DST_1SSBM8MBS23G
PRD_275769F4NFMG,DST_1SSBM8MBS23G Volume 1 PRD_275769F4NFMG DST_1SSBM8MBS23G
PRD_2N35CXMC53GG,DST_1SSBM8MBS23G Volume 3 PRD_2N35CXMC53GG DST_1SSBM8MBS23G
PRD_2SHNZGHP12QG,DST_1SSBM8MBS23G Volume 3 PRD_2SHNZGHP12QG DST_1SSBM8MBS23G
PRD_2W6493KRD1PG,DST_1SSBM8MBS23G Volume 1 PRD_2W6493KRD1PG DST_1SSBM8MBS23G

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);