products

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

4 rows where series_id = "CNT_3EHGYHP4N8TG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_order, listed_at, geoblock_id, on_sale_at, 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_0ECP5PTJD0KG CNT_16NXJXGD2TQ0 Another Novel CNT_3EHGYHP4N8TG CNT_3EHGYHP4N8TG 2 2 1 Another Episode S / 0 []   Another Episode S / 0   Summer, 1998. Mei Misaki, age fifteen, has gone with her family to their seaside vacation home. There she meets the ghost of Teruya Sakaki, her classmate from Yomiyama North Middle School Class 3-3 who, like Mei, witnessed the mysterious events that had transpired at the school. There begins an adventure of memory and mystery as they search for the ghost's body and his memories alike.   01K5GB5HBYH4AT2J59HRYXH36W 2.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Another Episode S / 0     2016-06-30T15:00:00.000Z   0 0
PRD_0WDK2BJGP0JG CNT_0CDB02X2GTG0 Another Novel CNT_3EHGYHP4N8TG CNT_3EHGYHP4N8TG 2 2 1 Volume 2 []   Another, Vol. 2   Summary of the first book: In the spring of 1998, Kouichi Sakakibara transfers to Yomiyama North Middle School. In class, he develops a sense of unease as he notices that the people around him act like they're walking on eggshells, and students and teachers alike seem frightened. As a chain of horrific deaths begin to unfold around him, he comes to discover that he has been placed in the cursed Class 3 in which the student body head count is always one more than expected. Class 3 is haunted by a vengeful spirit responsible for gruesome deaths in an effort to satisfy its spite. To stop the vicious cycle gripping his new school, Kouichi decides to get to the bottom of the curse, but is he prepared for the horror that lies ahead...?   01K5G9WRRATWHTZ6TNC0PAQZDB 2.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1P6A9KWCPCY0 Another, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_1RWFC7ED6GM0 CNT_0CJ5EC0Y5VG0 Another Novel CNT_3EHGYHP4N8TG CNT_3EHGYHP4N8TG 2 2 1 Another 2001 []   Another 2001   IT HAS BEEN THREE YEARS since the “calamity” of 1998 that claimed the lives of many students in Yomiyama North Middle’s Class 3. After Sou Hiratsuka, an acquaintance of 1998 survivor Mei Misaki, discovers that he’s being placed into the cursed class, he and his peers develop a series of countermeasures to avert a new tragedy. But when Sou’s classmates and their family members begin dying in a series of horrific “accidents,” he and Mei realize that the calamity has taken hold of their town once again. To stem the tides of death, the pair will be forced to reckon with Yomiyama’s deepest mysteries…   01KGB2QZPFTJB60BYA0XCR8BEX 3.0 2022-12-07T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG Another 2001     2022-12-13T00:00:00.000Z   0 0
PRD_2WD79NA63FV0 CNT_0J3C5YT881R0 Another Novel CNT_3EHGYHP4N8TG CNT_3EHGYHP4N8TG 2 2 1 Volume 1 []   Another, Vol. 1   In the spring of 1998, Kouichi Sakakibara transfers to Yomiyama North Middle School. In class, he develops a sense of unease as he notices that the people around him act like they're walking on eggshells, and students and teachers alike seem frightened. As a chain of horrific deaths begin to unfold around him, he comes to discover that he has been placed in the cursed Class 3 in which the student body head count is always one more than expected. Class 3 is haunted by a vengeful spirit responsible for gruesome deaths in an effort to satisfy its spite. To stop the vicious cycle gripping his new school, Kouichi decides to get to the bottom of the curse, but is he prepared for the horror that lies ahead...?   01KG931P7KBJNT8S1BXB2Y1FGT 1.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1P6A9KWCPCY0 Another, Vol. 1     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);