products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_25W33VKSKJ90"
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_0G4S5FQ2S8BG | CNT_2YFXFNN32GE0 | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 10 | [] | Spy Classroom, Vol. 10 | THE LAND WHERE REVOLUTIONS DIETo learn the truth about the Nostalgia Project, Lamplight sets its sights on the Lylat Kingdom, the country where it all began. Separated from the others and leading lonely double lives, Erna and Annette diligently lay the groundwork for a revolution. Unfortunately, they’ve embarked on a mission so difficult, even Inferno once failed to get it done. Lylat is home to a world-class counterintelligence agent who always seems to be right on Lamplight’s heels, and this mission certainly seems impossible. The girls’ resolve and values are put to the test, but it’s far too late to back down now! | 01KP0BC4ZK68JXTP9B0R8W5MWS | 10.0 | 2025-09-17T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 10 | 2026-03-10T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0W3N7HNWVYQ0 | CNT_00ZBWVNC9NV0 | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 9 | [] | Spy Classroom, Vol. 9 | WHAT HAPPENED TO ANNETTE…?After the fierce battles in Fend, the members of Lamplight were granted a two-week vacation to spend on a beautiful island. However, Klaus issues a mysterious order—they have to stay separated except on specific days. And on the final day, Annette is nowhere to be found. After dealing with the island’s pirate legends, a cursed murder case, and a girl claiming to be Klaus’s fiancée, Lamplight must piece together the scattered memories of the previous thirteen days to locate their missing comrade. | 01KGBJP82MMNKCFSD9Y5HQS0GP | 9.0 | 2024-11-20T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 9 | 2025-07-22T00:00:00.000Z | 0 | 0 | ||||||
| PRD_16QSJHW48ZCG | CNT_2YR6CSZ3TBEG | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 8 | [] | Spy Classroom, Vol. 8 | DON’T UNDERESTIMATE THE UNDERDOGLamplight has finally found the mole in the CIM, but they paid far too steep a price. The team is in shambles, and the blame has been placed on Monika, whose whereabouts remain unknown. As despair looms, the weakest member of Lamplight takes a stand and begins her counterattack. | 01KH3P8YFQB96XPNTNHARFFHBJ | 8.0 | 2024-04-02T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 8 | 2024-09-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1A0477YAC3Z0 | CNT_3YP5X548SNYG | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 3 | [] | Spy Classroom, Vol. 3 | Some Things Are Best Left in the Dark<BR />  <BR /> After the mission to take down Corpse, Thea, Monika, Annette, and Erna have earned a break. Unfortunately, their relaxing vacation will have to wait, as they soon find themselves face-to-face with Annette’s mother—although Annette herself has no memories of her past. While the emotional reunion initially brings everyone together, it isn’t long before fissures begin spreading throughout the team… | 01KGAGGRGH1RWYYCMC87966YX6 | 3.0 | 2022-04-25T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 3 | 2022-05-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1AZ6JGPED65G | CNT_2XYKAZWJDBEG | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 2 | [] | Spy Classroom, Vol. 2 | MASTER OF DISGUISE The nascent spy team Lamplight has successfully completed an Impossible Mission-but for their next assignment, they’ll have to dispose of a cold-blooded enemy assassin who rivals Klaus himself. Given the mission’s high stakes and even higher level of difficulty than the last, Klaus selects the strongest members of the group to see it through. Meanwhile, the team’s disguise specialist, Grete, will need to use all her wits to bring them success… | 01KG9HFW3FC8J42V3T95YYDZHA | 2.0 | 2021-12-09T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 2 | 2022-01-25T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1SM9KPRSY8XG | CNT_2QSVW7MNW580 | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 4 | [] | Spy Classroom, Vol. 4 | DOES HOPE HAVE A PLACE AMONG SPIES?<BR /> Klaus finally has a lead on the Empire’s mysterious spy team, Serpent, and Lamplight sets off to a major economic conference hosted in the metropolitan capital of the United States of Mouzaia to strike back. However, what awaits them at their destination is beyond anything they could have imagined—and Thea will have to decide what being a leader means to her. | 01KGAJSBYCKHTX7WH32EES9WTE | 4.0 | 2022-09-30T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 4 | 2022-10-18T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1WCG2H0MS9S0 | CNT_29KGRVSHESD0 | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 7 | [] | Spy Classroom, Vol. 7 | After suffering a devastating betrayal, the spy team Lamplight must pull themselves together and hurry toward the Fend Commonwealth. Meanwhile, one girl is forced to turn the entire world against her... | 01KGAXRZZFAA4B70KMKGCBG2FS | 7.0 | 2023-12-21T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 7 | 2024-05-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_26DKXTDSBFX0 | CNT_1S1CDV4V9K3G | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 1 | [] | Spy Classroom, Vol. 1 | INTELLIGENCE IS THE MOST DANGEROUS WEAPON Following a devastating military conflict, countries fight their wars in the shadows. One unusual spy, Klaus, has never failed on the job despite his quirks, and he is building a team to take on an Impossible Mission-one with over a 90 percent chance of failure. However, his chosen members are all washouts with no practical experience. They’ll have to use every trick in the book (and some that aren’t) to prove they’re up to the task! | 01KG9FX8T8CHBAVWBK2V1P4JTW | 1.0 | 2021-07-27T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 1 | 2021-08-24T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3AGVHESJPN0G | CNT_2P7DM8PQ82EG | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 5 | [] | Spy Classroom, Vol. 5 | LAMPLIGHT’S GREATEST THREAT YET IS…THEIR OLD SCHOOLMATES? The girls of Lamplight may have all washed out of their training at the spy academies, but under their leader, Klaus, they’ve managed to take on Impossible Missions with indisputable success. However, they still have a lot to learn, and in the field, there’s no room for error. To add to the pressure, team Avian, consisting of the best spies from the academies, is in need of a leader—and they’ve got their sights set on Klaus. Is this the end for Lamplight? | 01KGB4F0KQN89F9CFRMB467JJP | 5.0 | 2023-02-07T08:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 5 | 2023-05-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3KHHCM42CFC0 | CNT_0DH1AZMBW280 | Spy Classroom CNT_25W33VKSKJ90 | CNT_25W33VKSKJ90 | 2 | 2 | 1 | Volume 6 | [] | Spy Classroom, Vol. 6 | Lamplight infiltrates the Fend Commonwealth in search of answers about the deaths of a Din Republic spy team. But when Sybilla pushes herself to complete the investigation, she meets unexpected resistance from the leader of Belias, a powerful counterintelligence organization. Can Lamplight avenge their fallen compatriots? | 01KGB6847J1KSJY5ND6DFXYYJ9 | 6.0 | 2023-04-05T07:00:00.000Z | Yen On LAB_0TB60FJ75DX0 | GEO_1KB2KYDQ0JGG | Spy Classroom, Vol. 6 | 2023-08-22T00:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);