database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_0PZVBC33DP30"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_019VDE1JY2RG	CNT_24R9YG3CCCKG	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 8	[]	Tokyo ESP Vol. 8	The Final Curtain Rises Once the board members of Ares have gathered, Claudia uses Touko to awaken the Messiah and receive its benediction- a massive magnification of her ESP- just as Rinka, Kobushi, Minami and Nadja storm in, setting off the biggest ESP battle in Tokyo's history. Then an old enemy shows up, and alliances are strained as allegiances are tested. Can Rinka and her friends take down the power-drunk Claudia before Tokyo is wiped off the map...?	01KH3H6XK2EVVQHE7BTD240SXM	8.0	2021-01-05T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 8	Hajime SEGAWA	2021-01-05T08:00:00.000Z
PRD_0CYRD7QNZHR0	CNT_3B6G1W2A2BK0	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 1	[]	Tokyo ESP Vol. 1	There's a New Heroine in Town. Rinka Urushiba's world is turned upside down when she wakes up one day-after falling right through the floor. Encouraged by another ESPer who believes that Rinka's destiny is to become a hero of justice, she soon learns to use her powers for good. And not a moment too soon, as those with less-than-admirable ambitions descend on Tokyo with their own sets of superpowers. As the mysterious glowing fish flitting through the city skies gift powers seemingly at random, foes become friends and alliances are made and broken. And what about that flying penguin?	01KH3GADDAT44156JS466EFKBR	1.0	2020-11-17T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 1	Hajime SEGAWA	2020-11-17T08:00:00.000Z
PRD_0F07X87C8X30	CNT_1J7HHT6147R0	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 2	[]	Tokyo ESP Vol. 2	The Professor Appears Schools of flying, glowing fish, a flying penguin, now a flying hippo? As Murasaki wrestles with how to effectively use her newfound powers, Rinka and Kyotaro continue to train with the wise (and wicked) Youdani, who introduces a boy with a unique type of precognition, which is put to the test when he has to make a difficult decision when a conservative family member is threatened by supernatural powers. The enigmatic Professor, the ringleader of delinquent superhumans, appears with a tantalizing piece of the ESP puzzle and an invitation to the other side...	01KH3H5M3BGTBKPZX6M7RVFYV6	2.0	2020-11-24T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 2	Hajime SEGAWA	2020-11-24T08:00:00.000Z
PRD_1KN0GW81VA7G	CNT_112Z90Y5254G	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 7	[]	Tokyo ESP Vol. 7	The True Wire-Pullers The Macabre Lady and the rest of the major players in Ares Security, a global PMSC, set their sights on Kozuki, who has squirreled away the Ark, and Ren, whose ESP is the key to unlocking the Ark itself. Rinka teams up with her old frenemy Kobushi (and even forms a tentative alliance with Minami) to take down Ares from the inside. And Murasaki's ESP may turn out to be just the thing they need to win the battle, before the Messiah is reawakened...	01KH3H4MQ28KMED6V7DPC1HMYN	7.0	2020-12-29T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 7	Hajime SEGAWA	2020-12-29T08:00:00.000Z
PRD_27NWFSR32ZDG	CNT_0KXH6M0C5TEG	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 6	[]	Tokyo ESP Vol. 6	Thicker than Blood The battle in Hong Kong's black market tournament culminates with Rinka facing off with someone very close to the big bad boss… and Rinka winds up having to face some harsh truths about the choices she has made up until this point. Meanwhile, Kobushi makes a decision about her path in the criminal world with potentially fatal consequences. Back in Tokyo, Ren had expected life at the ESP Academy to return to normal, except a certain student has gone missing, and another classmate finds herself swept up by the immense aura of a new evil presence that has set foot in the metropolis…	01KH3H5RAJRPFMXSD1CYQ6KDJW	6.0	2020-12-22T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 6	Hajime SEGAWA	2020-12-22T08:00:00.000Z
PRD_2AACSCT5EYCG	CNT_2K8E67PMGSFG	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 4	[]	Tokyo ESP Vol. 4	A New Generation of ESPers… Nearly a year and a half after the battle with The Professor where countless glowing fish filled the skies of Tokyo, 20% of the population in the Kanto region are now superhumans. As society grapples with the dramatic changes in the populace, a special ESP Academy is established so superhumans can attend school. Among the students is one Ren Jomaku, a girl who can create blocks of ice- and perhaps something much darker...	01KH3H5PPCF7RFQZHEB3XQW07Z	4.0	2020-12-08T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 4	Hajime SEGAWA	2020-12-08T08:00:00.000Z
PRD_2EZ8C0ZTHCH0	CNT_2E3BYCEREPA0	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 5	[]	Tokyo ESP Vol. 5	Old Allies, New Enemies Rinka, who had gone missing, arrives back in Tokyo to put a stop to the plans of a terrorist organization that threatens Tokyo with a dangerous weapon, and rescue Ren and Marume from their evil clutches. But where had Rinka been that whole time? And what had she been doing? The truth is darker than the White Girl could have imagined...	01KH3H4Q1WQRXYRH4Z5PC0YQVJ	5.0	2020-12-15T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 5	Hajime SEGAWA	2020-12-15T08:00:00.000Z
PRD_39NA3A02Q5TG	CNT_38G02EF8NFHG	Tokyo ESP CNT_0PZVBC33DP30	CNT_0PZVBC33DP30	2	1	1	Volume 3	[]	Tokyo ESP Vol. 3	The White Girl is Dead. Long Live the White Girl! Rinka is targeted by The Professor's minions at school, with life-threatening consequences. Azuma wakes up, alone, on a deserted island, too far to help anyone. After we get a glimpse of The Professor's past and the true nature of the stone that creates the glowing fish, the terrorist gang's hijacking of the Diet building (by sending it flying through the skies) further enrages the government, which has already created a detention center for everyone with ESP. The Professor's ultimate act will have long-lasting repercussions, as the trap he set closes in on himself…	01KH3H571AT6MG97Z7BENHEBQZ	3.0	2020-12-01T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Tokyo ESP Vol. 3	Hajime SEGAWA	2020-12-01T08:00:00.000Z

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);