database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_1J40J5G0E7JG"

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	on_sale_at
PRD_0406Z8ED894G	CNT_0MR274PCY9JG	The Detective Is Already Dead CNT_1J40J5G0E7JG	CNT_1J40J5G0E7JG	2	1	1	Volume 5	[]	The Detective Is Already Dead, Vol. 5	Our most recent death solved and shelved, time to kick back and relax before the next case, right? Psyche, we got another one right off the bat! Luckily, Kimitaka’s new partner is brimming with confidence after confronting the truth about Siesta. Only question is, can she maintain that composure and be an ace detective of her own right?	01KGAXVMT3J2R3ND7AB95SZQBR	5.0	2024-01-09T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Detective Is Already Dead, Vol. 5	2024-06-18T00:00:00.000Z
PRD_1YF0AD618Z80	CNT_0NCT3QJ9YKC0	The Detective Is Already Dead CNT_1J40J5G0E7JG	CNT_1J40J5G0E7JG	2	1	1	Volume 6	[]	The Detective Is Already Dead, Vol. 6	“What could they want with Yui…?”Nagisa Natsunagi and I, Kimihiko Kimizuka, were finally able to uncover the mystery of the Ace Detective Siesta’s death by drawing out Nagisa’s other personality, Hel—and the truth along with her. But I barely had time to process everything before idol extraordinaire Yui Saikawa suddenly showed up at my door and offered me a job as her producer! Of course, it’s not nearly that simple, with the paparazzi on her tail and an unholy alliance of Bat and Seed waiting in the wings…Seems like they also want her for some nefarious purpose?! In fact, it feels like everyone’s after Yui…With enemies on all sides, what revelations will our prologue’s finale have in store?	01KGBBWKSVBTPKYP6YE57E4YP5	6.0	2024-07-12T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Detective Is Already Dead, Vol. 6	2024-12-10T08:00:00.000Z
PRD_247H60NBSH4G	CNT_3KAFCYW6YD0G	The Detective Is Already Dead CNT_1J40J5G0E7JG	CNT_1J40J5G0E7JG	2	1	1	Volume 4	[]	The Detective Is Already Dead, Vol. 4	“I’m going to take up the will of the ace detective.”<BR /><BR /> To celebrate a job well done, I, Kimihiko Kimizuka, have set out on a cruise with the ace detective, Nagisa Natsunagi, and our new ally, Yui Saikawa. However, a detective’s work is never done—not even a dead one’s…For it seems that somewhere, on this very ship, Siesta’s legacy is hidden.We didn’t have the slightest inkling it existed until we got a tip from Siesta’s biggest fan, Charlotte Arisaka Anderson. But no matter how important Siesta is to her, she seems reluctant to help our team in the search. She must still be angry about my year of inactivity. Just what does she want from me? I was only ever the assistant!Unfortunately, we’re not the only ones looking for Siesta’s legacy. After all, we’re competing with S.P.E.S. and, worse yet, a pseudo-human even Siesta couldn’t beat!! He’ll stop at nothing to get his hands on it...	01KGB2PSPTDQNT0SCDT408E2S5	4.0	2022-12-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Detective Is Already Dead, Vol. 4	2023-02-21T00:00:00.000Z
PRD_2MXSF7PG0PV0	CNT_30Z7XWZ5DA5G	The Detective Is Already Dead CNT_1J40J5G0E7JG	CNT_1J40J5G0E7JG	2	1	1	Volume 1	[]	The Detective Is Already Dead, Vol. 1	The dead detective and her assistant come to life in this manga adaptaion!I, Kimihiko Kimizuka, was an ordinary high school student. Sure, I had a penchant for getting dragged into all sorts of trouble, but was otherwise ordinary-until I met her. The detective, Siesta. Her angelically beautiful face and cool disposition in the face of plane hijackers swept me off my feet…and the next thing I knew, I’d spent the next three years off on a whirlwind adventure acting as her assistant. After all, I was the Watson to her Sherlock. But then…she died. It didn’t end there, though. No, our story only really began a year later when I met a bratty, snotty high school girl who seemed oddly familiar…	01KG9G0EA61ASGB4EF1RZ4RRGB	1.0	2021-09-16T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Detective Is Already Dead, Vol. 1	2021-12-14T08:00:00.000Z
PRD_3JX1QWB54XW0	CNT_3T3HCA8ECKAG	The Detective Is Already Dead CNT_1J40J5G0E7JG	CNT_1J40J5G0E7JG	2	1	1	Volume 2	[]	The Detective Is Already Dead, Vol. 2	<P>I just knew it. When I, Kimihiko Kimizuka, agreed to help Nagisa Natsunagi find her heart donor, I should’ve realized I was being dragged into something troublesome. Actually, I had an eerily similar feeling four years ago when I met Siesta on that plane.<BR /><BR />Speaking of which, that was where I first met the old jailbird Bat. I brought Natsunagi to him, hoping he’d be able to identify her donor<B>—</B>but I never expected him to bring up that name again…<BR /><BR />And so, having solved my last case, it was time for me to return to my ordinary high school life<B>—</B>or so I thought. But apparently, Natsunagi still has business with me…What kind of trouble will she drag me into next? Family heirlooms? Spoiled idols?</P>	01KGAF1C6RNCM56MS6AFTPBYP3	2.0	2022-04-06T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Detective Is Already Dead, Vol. 2	2022-07-12T00:00:00.000Z
PRD_3XKCJ56YR5T0	CNT_25SVK8MFB2CG	The Detective Is Already Dead CNT_1J40J5G0E7JG	CNT_1J40J5G0E7JG	2	1	1	Volume 3	[]	The Detective Is Already Dead, Vol. 3	<P>Due to my penchant for getting dragged into things, I, Kimihiko Kimizuka, an ordinary high-school student, suddenly was asked to protect national idol Yui Saikawa's Three-billion-yen sapphire!? </P><P>When there's a detective, there's always a case, and so, another case begins for me and Siesta’s heart’s recipient, Nagisa Natsunagi! </P>	01KGAJD9CW9XBRTVQWVM4KQDGQ	3.0	2022-07-29T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Detective Is Already Dead, Vol. 3	2022-11-01T00: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);