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_37Y86EPGFBEG"

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_07QPFRP9JR4G	CNT_29WVPW57BNH0	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 3	[]	The Shadows of Who We Once Were 3	During the 52 hours of human experimentation that drew out the weak and ugly sides of humanity, the first day comes and goes, leaving the students and teacher in a sleepless night to the second day. Between the growing bonds and deepening discord, the simple but cruel truths behind their time as children are uncovered. Those who are needed will be chosen, those who are unnecessary will be cut off. A terrifying reality awaits for the arrogant masses as they question who is deemed worthy and who is to be abandoned.	01KGAJBZ0PYXC23M1SMCDH89NF	3.0	2022-07-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 3	The Shadows of Who We Once Were Yae Utsumi/Kodansha Ltd.	2022-08-09T07:00:00.000Z
PRD_1CAM3HAP9B1G	CNT_3HY2YGGJS8M0	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 4	[]	The Shadows of Who We Once Were 4	The true nature of humanity is exposed in confinement. In this new experiment, the students are to choose who is deemed "most unnecessary," and the individual will suffer countless injuries. As the experiment ramps up to a terrifying conclusion, Mikio Yumesaki finally reveals the truth of his goals and the greatest experiment that will test the goodness in humanity. "Can you kill me?"	01KGB1TT7YDQJECBTHNCANJ0DZ	4.0	2022-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 4	The Shadows of Who We Once Were Yae Utsumi/Kodansha Ltd.	2022-09-13T07:00:00.000Z
PRD_1T2QFJHFGZ5G	CNT_18G67V2ZBJ70	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 2	[]	The Shadows of Who We Once Were 2	When the 27 students who graduated from class 6-2 of Shinozuka Elementary gather for their class reunion years later, they were locked in the now-abandoned school by their classmate, Mikio Yumesaki. He conducts trials and experiments, all for the sake of "testing one's goodness under extreme circumstances." 26 high school students and one teacher are locked up in an abandoned school building. The culprit is Mikio Yumesaki, a psychopath trying to "experiment" on the goodness of people's hearts and the weakness in their will. No one saw it coming when one of the 27 turned on their allies and killed a student. Cornered and scared, the students decided to take justice into their own hands, but the outcome was something no one would have been able to predict.	01KGAJ5VZPN2ZD11X8PYE23GDK	2.0	2022-07-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 2	The Shadows of Who We Once Were Yae Utsumi/Kodansha Ltd.	2022-07-26T07:00:00.000Z
PRD_1VM84C34CJAG	CNT_1N6APSFYXE2G	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 7	[]	The Shadows of Who We Once Were 7	Twenty-seven former classmates of Shinozuka Elementary School have gathered for a reunion only to find themselves being locked in the old school building. The man behind this crime is none other than Mikio Yumesaki, with a goal to test the goodness in humanity. On the second day of the tragic experimentation, the students are greeted by the last morning of their confinement. Hidden among the young girls and boys is a cold-blooded murderer... Until the truth is revealed, until that "evil" is punished, they will not stop doubting each other. Threatened at gunpoint, using fear as a tool, "he" desperately searches for the truth. How much blood must be shed before it finally ends?	01KGB3V730A9MP7Y1D1ZRC7AWX	7.0	2022-12-02T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 7	Yae Utsumi/Kodansha Ltd.	2022-12-13T08:00:00.000Z
PRD_1VXB8TBB6E20	CNT_0VJHX2FAZ9T0	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 6	[]	The Shadows of Who We Once Were 6	27 former students of the Shinozuka Elementary school have gathered for a reunion only to find themselves being locked in the old school building. The man behind this crime is none other than Mikio Yumesaki, with a goal to test the goodness in humanity. On the second day of their 52 hour-long experiment, the heinous crime claims its tenth victim. For power, for revenge, an unknown assailant attempts to rise up and take over the experiments. With their thoughts scattered in confusion, three tragedies occur simultaneously as a young man's "good" turns to "evil."	01KGB2ANNC5B3MSC9SC5BETP4Y	6.0	2022-10-26T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 6	Yae Utsumi/Kodansha Ltd.	2022-11-08T08:00:00.000Z
PRD_2MAP9RCWHB50	CNT_31765PV0YR90	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 8	[]	The Shadows of Who We Once Were 8	Twenty-seven former classmates of Shinozuka Elementary School year 6 class 2 gathered at their elementary for a reunion but was locked into the building, unable to escape. The man behind it is Mikio Yumesaki, with the sole purpose to test the goodness in humanity under extreme circumstances... Thus begins an immoral experiment to expose the good and evil of humanity at a fake reunion. Two years after the 52 hours of confinement, the surviving students meet again. And standing on the land where they lost everything, they make a vow in the face of the many sacrifices and countless sins they've committed. They swear to never allow themselves to be swept away by anything and to take a step forward to live their lives...	01KGB45H358FCXS1SXYQ391PJN	8.0	2022-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 8	Yae Utsumi/Kodansha Ltd.	2023-01-11T08:00:00.000Z
PRD_350GPRTDR1S0	CNT_0PDT4GT3VKWG	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 1	[]	The Shadows of Who We Once Were 1	Nezu was looking forward to his elementary school reunion—after all, his class was united by unbreakable bonds. But when his former classmate, Mikio, reveals that this reunion is a very real matter of life and death...suddenly Nezu finds those bonds put to the test. By the author of Until Your Bones Rot!	01KGAGZ7CQA0XBBWJ61QX928XN	1.0	2022-05-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 1	The Shadows of Who We Once Were Yae Utsumi/Kodansha Ltd.	2022-06-07T07:00:00.000Z
PRD_3VSASF8A6HM0	CNT_366RCH2ZTE2G	The Shadows of Who We Once Were CNT_37Y86EPGFBEG	CNT_37Y86EPGFBEG	2	1	1	Volume 5	[]	The Shadows of Who We Once Were 5	On day three of their confinement, the tragedy continues and more deaths emerge as they welcome their second night. For their "last experiment," the captors are to pick several "kings" amongst their friends. The king will have absolute authority over the others, and to ensure the kings' power, they're given a device to make the others submit. But then, the goodness in HIS heart shatters...entranced by the promise of absolute power. The scent of power is always too sweet to resist...	01KGB20804XW6VP7XQ84GFSY5C	5.0	2022-09-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Shadows of Who We Once Were 5	The Shadows of Who We Once Were Yae Utsumi/Kodansha Ltd.	2022-10-11T07: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);