product_external_ids

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

5 rows where product_id = "PRD_2Y55NYRQJCVG"

✎ 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_3YHSX6TB6G9G The Price of Royal Duty PRD_2Y55NYRQJCVG content 1 9b37b2f7-6ca2-44c7-a567-bc4df838011e  
PID_08HXH9KVP73G The Price of Royal Duty PRD_2Y55NYRQJCVG product 2 bwg_migration.2961834  
PID_0WM8CV4Q83PG The Price of Royal Duty PRD_2Y55NYRQJCVG product 4 59626855C00002942864  
PID_26P732ZDD5D0 The Price of Royal Duty PRD_2Y55NYRQJCVG product 3 9784596268556  
PID_3ATHYKHS71G0 The Price of Royal Duty PRD_2Y55NYRQJCVG product 7 9784596268556  

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