database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_1GHYM69YSC9G"

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_0DB1QHFR759G	CNT_0BVJHB60GJW0	Island in a Puddle CNT_1GHYM69YSC9G	CNT_1GHYM69YSC9G	2	1	1	Volume 3	[]	Island in a Puddle 3	A CHILDHOOD IN THE UNDERWORLD Evading police, suspicious neighbors, jealous boyfriends, and the traitorous co-conspirator after his body, Minato is tracked down by the mysterious Dodokai and asked to do their bidding. His plans to return home and figure out what happened to his body, now occupied by the mind of the murderer whose body he occupies, are becoming harder and harder to realize.	01KGAJBNX2WHFKNWYSDNN5GGR1	3.0	2022-07-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Island in a Puddle 3	Island in a Puddle Kei Sanbe/Kodansha Ltd.	2022-08-02T07:00:00.000Z
PRD_22X10HZH5P4G	CNT_1JJ3RMXWR3H0	Island in a Puddle CNT_1GHYM69YSC9G	CNT_1GHYM69YSC9G	2	1	1	Volume 4	[]	Island in a Puddle 4	BETWEEN A ROCK AND A HARD PLACE Mistaken for Kuromatsu, a ruthless killer known in the underworld as "The Neck Breaker," Minato finds himself caught between rival Yakuza factions and thrust into a situation he can't run from. Meanwhile, the real Kuromatsu (a.k.a. the fake Minato) plots his next move against the man who set him up—a detective who happens to be an acquaintance of the Myojin siblings. Kuromatsu sends a video that threatens to expose the detective, but Minato has a surprise in store for both of them. The conclusion draws near in this gripping thriller from Kei Sanbe!	01KGB1TMFM7VKZSQW115B0X0P8	4.0	2022-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Island in a Puddle 4	Island in a Puddle Kei Sanbe/Kodansha Ltd.	2022-10-11T07:00:00.000Z
PRD_2PFZT29XB9H0	CNT_0WF7K2PM2Z5G	Island in a Puddle CNT_1GHYM69YSC9G	CNT_1GHYM69YSC9G	2	1	1	Volume 2	[]	Island in a Puddle 2	NO SECOND CHANCES Tension mounts as Minato, who's mind was mysteriously swapped into the body of a wanted man on the run for murder, tries to figure out his next move. Stranded, alone, he starts to formulate a plan to get to his younger sister, who's now in the care of the man whose body he swapped with, without suspicion. However, it's not only the police after the man whose body he now occupies—a shadowy organization called the Dodokai is closing in, too...	01KGAG457GEVTFW581VQ8GGQBV	2.0	2022-04-26T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Island in a Puddle 2	Island in a Puddle Kei Sanbe/Kodansha Ltd.	2022-07-12T07:00:00.000Z
PRD_2SVSVPD8D2EG	CNT_35H8S72GYRZ0	Island in a Puddle CNT_1GHYM69YSC9G	CNT_1GHYM69YSC9G	2	1	1	Volume 1	[]	Island in a Puddle 1	A CHILDHOOD IN THE UNDERWORLD Minato's tiny apartment might as well be on a deserted island. Despite being in elementary school, it falls on his shoulders to care for his little sister Nagisa, who never stops asking when their mother will make one of her infrequent visits home. One day when she stops by, their mother takes them to an amusement park, only to give Minato some cash and leave them on the Ferris wheel. However, as they reach the top of the ride, lightning strikes their car— but what Minato finds when he awakens is not the grim tragedy he expected...	01KGAF34VJZ9YZZHN2M0164J61	1.0	2022-02-22T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Island in a Puddle 1	Island in a Puddle Kei Sanbe/Kodansha Ltd.	2022-03-15T07:00:00.000Z
PRD_3G49NEWRBB70	CNT_1NRV6C1P2RF0	Island in a Puddle CNT_1GHYM69YSC9G	CNT_1GHYM69YSC9G	2	1	1	Volume 5	[]	Island in a Puddle 5	THE FINAL SHOWDOWN Reunited with Nagisa, Minato (in Kuromatsu's body) suddenly finds himself at the scene of a deadly clash between secret criminal mastermind Tsubaki and one of Tsubaki's fellow detectives. Futaba confirms beyond a doubt that something is terribly wrong with the Myo^jin boy, while Kuromatsu quietly tightens his grip on her, setting the stage for this exciting conclusion to Island in a Puddle!	01KG9KGA31N5B1N14CE3GMVHAQ	5.0	2023-01-24T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Island in a Puddle 5	Kei Sanbe/Kodansha Ltd.	2023-02-14T08: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);