products

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

3 rows where series_id = "CNT_0WRHA2B1N37G"

✎ 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_1DG5QJE5NWH0 CNT_1SCDHK3EKPJG PandoraHearts ~Caucus Race~ CNT_0WRHA2B1N37G CNT_0WRHA2B1N37G 2 2 1 Volume 3 []   PandoraHearts ~Caucus Race~, Vol. 3   Caucus race.It may be an endless race, but the runners carry on for the "hope" that lies just ahead. If they do so, then surely......The secrets housed by the four great dukedoms of PandoraHearts spill forth with abandon in the four Jun Mochizuki-illustrated fairy tales contained herein...   01KG95GV4R938NX0XKJG3DERJP 3.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 PandoraHearts ~Caucus Race~, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_26K9E2A0ACJG CNT_16S9B9ZECPG0 PandoraHearts ~Caucus Race~ CNT_0WRHA2B1N37G CNT_0WRHA2B1N37G 2 2 1 Volume 1 []   PandoraHearts ~Caucus Race~, Vol. 1   Within these pages, four fairy tales unfold, each peering into one of the houses of the four great dukedoms: Vessalius, Rainsworth, Barma, and Nightray. Shifting among present, past, and future, these stories link to each other like a wheel, traveling to and fro in a never-ending ring between the everyday and the extraordinary. Inside this ring, the protagonists take off at a gallop. Caucus race: A race that is run within a circle, any which way one likes. A race with no goal. Who will be the winner?Look deeper into the world of PandoraHearts with this first ever novelization based on the work of the New York Times bestselling manga creator Jun Mochizuki, illuminated by special manga shorts drawn by Mochizuki herself...   01KG6ZFNJKG2GMJETQB5T6GEM5 1.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 PandoraHearts ~Caucus Race~, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_2MDSWQTV0XC0 CNT_2GZP0JA8BRQG PandoraHearts ~Caucus Race~ CNT_0WRHA2B1N37G CNT_0WRHA2B1N37G 2 2 1 Volume 2 []   PandoraHearts ~Caucus Race~, Vol. 2   Gaze down into the sunny garden from the veranda. There, children run to and fro, full of life. Two cats chase after them. The sight calls to mind a single thought:They seem to be racing each other.A caucus race.A race with no end.If only this charming sight could continue on tomorrow and ever after...Drawn up from the world of PandoraHearts, these enchanting fairy tales illustrated by Jun Mochizuki throw open the doors of the four great dukedoms once more...   01KG95JH3MMM93K2549JR6EZ0P 2.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 PandoraHearts ~Caucus Race~, Vol. 2     2016-06-30T15: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);