products

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

3 rows where series_id = "CNT_1V19R43R1VZG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_0A733J1FBPVG CNT_2288ZK23Z1WG Juana and the Dragonewt's Seven Kingdoms CNT_1V19R43R1VZG CNT_1V19R43R1VZG 2 1 1 Volume 2 []   Juana and the Dragonewt's Seven Kingdoms Vol. 2   Despite being from different worlds, dragonewt Nid and human girl Juana have forged a bond. But when Juana catches the eye of a circus showman, she is snatched up while Nid is left adrift in the ocean. Will Nid survive his watery ordeal? And will Juana escape the showman's clutches, or be part of his traveling freak show forever? FREAKS & GEEKS 01KGA3DY2SG7W14WKTY1GW9TXH 2.0 2018-04-12T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Juana and the Dragonewt's Seven Kingdoms Vol. 2 Kiyohisa Tanakaa 2017   2018-05-15T07:00:00.000Z   0 0
PRD_1J6NM5VJDQE0 CNT_3PQB5EZHGCM0 Juana and the Dragonewt's Seven Kingdoms CNT_1V19R43R1VZG CNT_1V19R43R1VZG 2 1 1 Volume 3 []   Juana and the Dragonewt's Seven Kingdoms Vol. 3   Ever since mild-mannered dragonewt Nid met Juana, his life has been one adventure after another. But what exactly is Juana? And how did she manage to survive when her kind supposedly went extinct ages ago? As their search for Juana's family comes to a conclusion, Nid realizes that finding out the truth might mean losing his best friend. END OF THE ROAD 01KGA5FX490WGH23AETRRJS446 3.0 2018-11-06T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Juana and the Dragonewt's Seven Kingdoms Vol. 3 Kiyohisa Tanakaa 2018   2018-11-20T08:00:00.000Z   0 0
PRD_27VX52CASN60 CNT_19MCS33AJDFG Juana and the Dragonewt's Seven Kingdoms CNT_1V19R43R1VZG CNT_1V19R43R1VZG 2 1 1 Volume 1 []   Juana and the Dragonewt's Seven Kingdoms Vol. 1   In a fantastical future ruled by dragonewts, human dominance is a thing of the past. Despite humanity's extinction, Nid, a young dragonewt with a passion for ancient history, makes a startling discovery: a young human girl who calls herself Juana. Together, the unlikely pair sets out to explore the strange world of the Seven Kingdoms. HERE THERE BE DRAGONEWTS 01KGA1HJ6TDMQZ17HDWDFSZ603 1.0 2017-12-19T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Juana and the Dragonewt's Seven Kingdoms Vol. 1 (C) Kiyohisa Tanakaa 2017   2018-01-16T08:00:00.000Z   0 0

Advanced export

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

CSV options: 

CREATE TABLE products (
      id TEXT PRIMARY KEY,
      content_id TEXT NOT NULL,
      series_id TEXT NOT NULL,
      parent_content_id TEXT,
      level INTEGER NOT NULL,
      content_type INTEGER NOT NULL,
      product_type INTEGER NOT NULL,
      title TEXT NOT NULL,
      alt_titles TEXT NOT NULL,
      subtitle TEXT NOT NULL,
      display_title TEXT NOT NULL,
      display_title_short TEXT NOT NULL,
      description TEXT NOT NULL,
      description_short TEXT NOT NULL,
      image_id TEXT NOT NULL,
      display_order REAL NOT NULL,
      listed_at TEXT NOT NULL,
      label_id TEXT NOT NULL,
      geoblock_id TEXT,
      display_name TEXT NOT NULL,
      copyright TEXT,
      on_presale_at TEXT,
      on_sale_at TEXT NOT NULL,
      off_sale_at TEXT,
      add_on INTEGER NOT NULL,
      add_on_campaign_only INTEGER NOT NULL,
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (label_id) REFERENCES labels(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);