database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_2C13070BPBG0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0BVYYAHYS8D0	CNT_184DR04K0REG	Thompson CNT_2C13070BPBG0	CNT_2C13070BPBG0	2	1	1	Volume 1	[]	Thompson: Volume 1	Urban legends have come to life, manifesting as phenomena called "Folklore." The mysterious Thompson Agency is dedicated to identifying and capturing these beings to minimize their harm to humanity. Thompson agents Emma and Yuliya are assigned to a sleepy branch in the countryside. While horrific atrocities are committed by Folklore in Tokyo, our heroes clean basements and fix the locals' toilets. However, it is in Folklore's nature to appear wherever humans gather. Myths, rumors, and fairy tales enter the minds of the public, then grow into fears that manifest on the streets, in the dark, and around every corner. When a factory owner calls upon the Thompson Agency to investigate a strange occurrence, he believes his workers are being superstitious. But Emma and Yuliya discover that something dangerous might have arrived to lick its wounds in their sleepy town—and it won't stay weak for long...	Urban legends have come to life, manifesting as phenomena called "Folklore." Only the mysterious Thompson Agency, dedicated to identifying and capturing these beings, can keep humanity safe.	01KH3EP20KMBFD18ND49BTZWDV	1.0	2023-07-18T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Thompson: Volume 1	Copyright ©Harayasu 2019	2023-07-26T07:00:00.000Z
PRD_0CS9WCJQGX20	CNT_0GVSY8VB7DM0	Thompson CNT_2C13070BPBG0	CNT_2C13070BPBG0	2	1	1	Volume 3	[]	Thompson: Volume 3	While searching for Busby's stoop chair, Emma and Yuliya find themselves attacked by a pair of mysterious serial killers. As our Thompson agents lose the upper hand, they're rescued just in time by Saisse, a man who claims to be their supervisor. There seems to be more to the story, however, as Saisse's return to Tokyo heralds a frenzy of Folklore activity—the novemdiales. Pray our heroes make it out alive as they face the coach of the dead once more, and find out their deepest secrets in the final volume of Thompson!	Saisse claims to be Emma and Yuliya's supervisor, but his return to Tokyo heralds a frenzy of Folklore activity—the novemdiales. Learn Emma and Yuliya's deepest secret as they meet the coach of the dead once more in Thompson's final volume!	01KG9PKYFM2DHVX625R0584S0Z	3.0	2024-01-16T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Thompson: Volume 3	Copyright ©Harayasu 2020	2024-03-06T08:00:00.000Z
PRD_11XQ1CA70X80	CNT_3DB24THP9870	Thompson CNT_2C13070BPBG0	CNT_2C13070BPBG0	2	1	1	Volume 2	[]	Thompson: Volume 2	Invincible-class Folklore are the rarest kind, and Thompson agents Emma and Yuliya are now face-to-face with one. The coach of the dead has no known weaknesses and leaves no survivors, but it's about to cross to the next life with their kind and clumsy manager inside. Their sleepy countryside Thompson Agency branch is now facing Folklore far beyond their abilities, and they are woefully underprepared. Can Emma and Yuliya rescue their boss and be the first survivors of the coach of the dead, or is it already too late?	The coach of the dead has no known weaknesses, and it's about to cross to the next life with Emma and Yuliya's kind manager inside. Can they rescue their boss and be the coach's first survivors, or is it already too late?	01KGAT0MSNGRQPP7TBF6H7G2QF	2.0	2023-10-24T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Thompson: Volume 2	Copyright ©Harayasu 2020	2023-11-01T07: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);