products

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

4 rows where series_id = "CNT_3H21GNZSEMKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_12CXDXYAVR3G CNT_3Q43AKX8PVSG Spy Classroom Short Story Collection CNT_3H21GNZSEMKG CNT_3H21GNZSEMKG 2 2 1 Volume 3 []   Spy Classroom Short Story Collection, Vol. 3   Avian, the elite spy team made up of the top academy students, has run into trouble in the Fend Commonwealth, and their boss, “Flock” Vindo, realizes they might not make it out alive. As his companions fall one by one to the unexpected attack, what comes to his mind are his memories of the month spent with Lamplight. After the mission in Longchon, Avian suffers a crushing defeat at the hands of Klaus, and in the pursuit of revenge accidentally become stalkers!? Of course, Lamplight can’t just stand by and watch, and the two teams soon descend into chaos. Sometimes fighting, sometimes challenging each other, these young spies live out their youth in a way only they can; this is the story of their unforgettable honeymoon.   01KGBC07JWAZ4J59DA9DYK3GC9 3.0 2024-07-23T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 Spy Classroom Short Story Collection, Vol. 3     2024-12-17T08:00:00.000Z   0 0
PRD_15352C7ZB8DG CNT_2NJMVSM1C3EG Spy Classroom Short Story Collection CNT_3H21GNZSEMKG CNT_3H21GNZSEMKG 2 2 1 Volume 2 []   Spy Classroom Short Story Collection, Vol. 2   “Klaus —s you.” Before her death, Hearth, the leader of the legendary spy team Inferno, bequeathed a key of unknown purpose to Thea after saving her from the brink of despair. Years later, Thea has finally discovered a box the key can open. Inside, she finds Hearth’s last testament—but it’s missing a crucial word. Soon, misunderstanding begets misunderstanding as everyone in Lamplight gets sucked into uncovering the mystery of Hearth’s note!   01KH3G5J1YPRK8Z39ZY4RJRWXZ 2.0 2023-08-21T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG Spy Classroom Short Story Collection, Vol. 2     2023-12-12T00:00:00.000Z   0 0
PRD_2X0A6W2ZVD2G CNT_1PFQDRHA2HC0 Spy Classroom Short Story Collection CNT_3H21GNZSEMKG CNT_3H21GNZSEMKG 2 2 1 Volume 4 []   Spy Classroom Short Story Collection, Vol. 4   IT’S TIME TO FLY THE COOPAfter completing her job in the Fend Commonwealth, Lan suddenly declares she won’t work anymore and holes herself up in the Heat Haze Palace. If Lamplight wants this now-permanent guest to get out of their headquarters, they’ll have to find Cloud Drift somewhere new to work…   01KG9QG7V88S57KZE91QY97P85 4.0 2025-04-07T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PQM5BDYSMG0 Spy Classroom Short Story Collection, Vol. 4     2025-09-16T07:00:00.000Z   0 0
PRD_3KD8PQVGA410 CNT_1YQM7CQDJFV0 Spy Classroom Short Story Collection CNT_3H21GNZSEMKG CNT_3H21GNZSEMKG 2 2 1 Volume 1 []   Spy Classroom Short Story Collection, Vol. 1   Klaus reveals he is married to a member of Lamplight, but the identity of the bride remains unknown. In an effort to uncover the truth behind this strange secret, the girls review some of their recent smaller adventures to find any revelatory clues—until the investigation descends into a full-on battle royale! Get a peek into the girls’ daily lives in this collection of vignettes!   01KGB2ZXYSJHW7X3TWW13HJ3C0 1.0 2022-12-07T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1KB2KYDQ0JGG Spy Classroom Short Story Collection, Vol. 1     2023-04-18T00: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);