product_distributors

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

11 rows where distributor_id = "DST_3K19G0QBEBJ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link product_id distributor_id
PRD_04FC335N6EVG,DST_3K19G0QBEBJ0 Our Secretary's Bedroom Affairs PRD_04FC335N6EVG DST_3K19G0QBEBJ0
PRD_05PY0DWVYZEG,DST_3K19G0QBEBJ0 I Won't Say I Love You PRD_05PY0DWVYZEG DST_3K19G0QBEBJ0
PRD_0BZVQ528AT8G,DST_3K19G0QBEBJ0 This is But a Hell of a Dream PRD_0BZVQ528AT8G DST_3K19G0QBEBJ0
PRD_0N7XW94F32R0,DST_3K19G0QBEBJ0 My Androgynous Mechanism PRD_0N7XW94F32R0 DST_3K19G0QBEBJ0
PRD_1ETDSJ9W9170,DST_3K19G0QBEBJ0 Under My Skin PRD_1ETDSJ9W9170 DST_3K19G0QBEBJ0
PRD_28728FDD8TR0,DST_3K19G0QBEBJ0 Feigning Fox with a Face Full of Flowers PRD_28728FDD8TR0 DST_3K19G0QBEBJ0
PRD_2HSCPR58HF50,DST_3K19G0QBEBJ0 Hatsujo Playroom PRD_2HSCPR58HF50 DST_3K19G0QBEBJ0
PRD_2VF5PKQC11FG,DST_3K19G0QBEBJ0 My Androgynous Syndrome PRD_2VF5PKQC11FG DST_3K19G0QBEBJ0
PRD_3CHG1YNE25JG,DST_3K19G0QBEBJ0 I'm not your hero or anything PRD_3CHG1YNE25JG DST_3K19G0QBEBJ0
PRD_3PA2Q3JNXGEG,DST_3K19G0QBEBJ0 <Special Booklet> PRD_3PA2Q3JNXGEG DST_3K19G0QBEBJ0
PRD_3V3MEYYAGFH0,DST_3K19G0QBEBJ0 The Fallen Alpha PRD_3V3MEYYAGFH0 DST_3K19G0QBEBJ0

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