products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
11 rows where series_id = "CNT_0GAQ8XG7R3B0"
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_07GPNMKWR7CG | CNT_2X36MWVG438G | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 9 | [] | For the Kid I Saw in My Dreams, Vol. 9 | While Senri’s methods have become more methodical over time, Wakazono has abandoned police procedure and the bounds of the law in his pursuit of the “fire” man. Hoping to curb further violence, Enan goes to see Wakazono—but she isn’t the only one who has business with the dirty detective. For the first time, Enan catches a glimpse of Kazuto before he disappears into the night. Whatever mysteries remain, protecting what is precious takes priority for the twins as they find themselves thrown into turmoil by Wakazono’s schemes... | 01KGB2RJ6NA94WK7K8R4123Q38 | 9.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | For the Kid I Saw in My Dreams, Vol. 9 | 2022-12-13T00:00:00.000Z | 0 | 0 | ||||||
| PRD_0CAREXFFV050 | CNT_188AB9Y14X90 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 10 | [] | For the Kid I Saw in My Dreams, Vol. 10 | Discontent to remain in the shadows, Wakazono leaks police documents concerning Three-Eyes’s true identity to the press—including a photo of Senri! While the release forces Senri out of the public eye, Wakazono hopes the threat against him will force Kazuto to act, revealing himself and giving him a chance to kill the “fire” man. Unfortunately for Wakazono, he has no idea just what kind of person he’s been dealing with… | 01KGB4GQDKMHXGPD6A2S7QW170 | 10.0 | 2023-02-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | For the Kid I Saw in My Dreams, Vol. 10 | 2023-05-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_12G3CFFSAVP0 | CNT_3HAAJ5MNPYTG | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 7 | [] | For the Kid I Saw in My Dreams, Vol. 7 | Though the “fire” man’s trap would have forced Senri to join Kazuto as his murderous partner in crime, Senri manages to keep his cool, sparing the person he was meant to kill. Safely reunited thanks to the twins, the rat imposter and his family are able to provide new details about Kazuto-and, more importantly, a handwritten note! Kazuto’s words are the first Senri has heard from his brother in over a decade, but while they confirm some theories, Senri is still no closer to finding out where Kazuto is...or what he might be planning next! | 01KGAD627K6YE0DH4JJX6SG41V | 7.0 | 2021-11-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | For the Kid I Saw in My Dreams, Vol. 7 | 2021-12-07T08:00:00.000Z | 0 | 0 | ||||||
| PRD_15CB4QQ8AFBG | CNT_0M5TG9T16ST0 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 6 | [] | For the Kid I Saw in My Dreams, Vol. 6 | Though Kazuto has lived for years with a bullet lodged in his brain, the childhood injury is starting to take its toll. Uncertainty over his future may explain why he has chosen to reach out to Senri after so long, even if his methods remain frustratingly roundabout. Meanwhile, Senri and Enan are on the cusp of unraveling the events that separated the twins in the first place-but not if the “fire” man has anything to say about it! | 01KG9F5Q2VZY8MGNKFM4VV9CRZ | 6.0 | 2021-04-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | For the Kid I Saw in My Dreams, Vol. 6 | 2021-06-08T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1K5C9EC58B80 | CNT_1CDECGW15EDG | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 8 | [] | For the Kid I Saw in My Dreams, Vol. 8 | Through Kazuto’s eyes, Senri sees more clearly why his brother has begun stepping away from the murderous path laid out for him by the rat. Risking a meeting with Mask Man’s associates, who have their own reasons for wanting to find Kazuto, Senri discloses his suspicions of a Three- Eyes copycat in hopes of uncovering new information that will lead to his twin. What he learns will confirm his theory, but it will also place the threat much closer to home... | 01KGAGVBF31G9YYQMQK333CXER | 8.0 | 2022-06-28T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | For the Kid I Saw in My Dreams, Vol. 8 | 2022-07-26T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1T9JJDCQEMMG | CNT_2QHVZFN54NQ0 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 3 | [] | For the Kid I Saw in My Dreams, Vol. 3 | <DIV>Certain his twin is alive, Senri shifts his goal from avenging his brother to finding him. Enan is happy to join the search, relieved to see her friend's face light up with hope after living in darkness for so long. Following the threads of distant memories, Senri uncovers new clues that suggest his parents' involvement in a tangled plot, one that may well have led to their deaths. And now, as events continue to unfold, Senri fears Kazuto may be wrapped up in the sinister dealings of the city's underworld as well. Has the homicidal "fire" man twisted his kind brother into something unimaginable...?!</DIV> | 01KGA7NHNQXNENXNVJDQA4CQ8H | 3.0 | 2019-09-01T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | For the Kid I Saw in My Dreams, Vol. 3 | 2019-11-26T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1THBF4KGTZN0 | CNT_3RR8C004FHQ0 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 11 | [] | For the Kid I Saw in My Dreams, Vol. 11 | Even though Wakazono’s intentions have been exposed, Senri, the police, and even Kazuto can’t seem to help falling exactly in line with his plans. Detained in protective custody, Senri fears he may lose his brother before they have the chance to reunite, but the twins have always been connected in ways beyond the physical... A climax of vengeance and reconciliation plays out in the final volume of For the Kid I Saw in My Dreams! | 01KGB6FCEEBB7ZXVPDH6V67KKK | 11.0 | 2023-05-08T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | For the Kid I Saw in My Dreams, Vol. 11 | 2023-10-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1XAJY979M7V0 | CNT_2CV7P11ZVVZ0 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 1 | [] | For the Kid I Saw in My Dreams, Vol. 1 | Senri Nakajou's twin brother was his everything, the one who protected him from their abusive father, the one whose pain he felt as his own. That is, until the day thirteen years ago when Senri's entire family was murdered before his eyes. He couldn't have cared less about his parents, but without his brother, his world ended. Ever since, finding the killer and making him pay has been Senri's only goal...and now-finally-he's caught a glimpse of a clue...! | 01KG9AZKBHG6K48HET1AQGHB9C | 1.0 | 2019-01-29T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | For the Kid I Saw in My Dreams, Vol. 1 | 2019-01-29T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3A581A28XVKG | CNT_2SNB8BE316J0 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 2 | [] | For the Kid I Saw in My Dreams, Vol. 2 | For thirteen years, Senri has made it his mission to take revenge on the man with the “fire” scar who took his twin brother from him. Recognizing his pursuit will require a certain amount of funding, Senri has saved and schemed for years, but his latest get-rich-quick con has just been cracked wide open! With his associates in danger, Senri stands to lost everything he’s built. It may be a costly setback, or it may be fate has given him a new avenue for tracking down his brother’s killer! | 01KGA744FZKPC8B25Q26RG4WEQ | 2.0 | 2019-06-18T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | For the Kid I Saw in My Dreams, Vol. 2 | 2019-06-18T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3J8ZD1ENEHJG | CNT_3QFJ334YJ5H0 | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 5 | [] | For the Kid I Saw in My Dreams, Vol. 5 | Senri’s hunt for his twin heats up as a rival criminal group sets Kazuto and the “fire” man’s hideout ablaze mere minutes after he and Enan finish their search. As he draws closer and closer to his brother, the danger only seems to increase, and so too does Senri’s recklessness. He feels sure Kazuto is reaching out to him, yearning to meet as much as he is, but Kazuto has a long history with the “fire” man—and a terrible burden to bear… | 01KG9CNJKZBRFWNVM0G674Y6J7 | 5.0 | 2020-06-23T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | For the Kid I Saw in My Dreams, Vol. 5 | 2020-07-21T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3NMSENJ00A80 | CNT_1NZD82RSDCCG | For the Kid I Saw in My Dreams CNT_0GAQ8XG7R3B0 | CNT_0GAQ8XG7R3B0 | 2 | 1 | 1 | Volume 4 | [] | For the Kid I Saw in My Dreams, Vol. 4 | Desperate to find and stop his brother as soon as possible, Senri reluctantly agrees to meet with Detective Wakazono. The offbeat officer has his own reasons for wanting to find—and finish off—the “fire” man, but Senri is determined to beat him to it. Armed with new information and the few clues surrounding his parents’ deaths, Senri and Ena journey through the countryside, piecing together the past. Each step leads them closer to Kazuto…but they aren’t the only ones hot on his tail…! | 01KGA7XJWG08W72HF4J5E9E8XS | 4.0 | 2020-02-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | For the Kid I Saw in My Dreams, Vol. 4 | 2020-03-31T07: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);