product_external_ids

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

5 rows where product_id = "PRD_2XDW4AQ97YMG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, external_id

id ▼ product_id source type external_id external_id_original
CID_1A7DZDEA864G Master of the Desert PRD_2XDW4AQ97YMG content 1 99359987-154a-4ebb-9a7e-95431a5c3ffb  
PID_04JKD3WMAWTG Master of the Desert PRD_2XDW4AQ97YMG product 4 59668880C00002942920  
PID_2ECA3AQ2FYH0 Master of the Desert PRD_2XDW4AQ97YMG product 3 9784596688804  
PID_2JGMYW9Y1V40 Master of the Desert PRD_2XDW4AQ97YMG product 7 9784596688804  
PID_3GE0HJBRK0QG Master of the Desert PRD_2XDW4AQ97YMG product 2 bwg_migration.2962934  

Advanced export

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

CSV options: 

CREATE TABLE product_external_ids (
      id TEXT PRIMARY KEY,
      product_id TEXT NOT NULL,
      source TEXT NOT NULL,
      type INTEGER NOT NULL,
      external_id TEXT NOT NULL,
      external_id_original TEXT NOT NULL,
      FOREIGN KEY (product_id) REFERENCES products(id)
    );
CREATE INDEX idx_product_external_ids_product ON product_external_ids(product_id);