product_external_ids

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

5 rows where product_id = "PRD_2Z68G2XK6HKG"

✎ 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_0B7M6G96QQHG Hold Back the Dark PRD_2Z68G2XK6HKG content 1 8c097633-a066-4028-b613-41ebe9484e35  
PID_0FHYH4CTGMD0 Hold Back the Dark PRD_2Z68G2XK6HKG product 3 9784596256614  
PID_0KM9CN5PAGG0 Hold Back the Dark PRD_2Z68G2XK6HKG product 7 9784596256614  
PID_1HKN7B7GNP3G Hold Back the Dark PRD_2Z68G2XK6HKG product 2 bwg_migration.2961000  
PID_25P02WRCFJPG Hold Back the Dark PRD_2Z68G2XK6HKG product 4 59625661C00002943381  

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