database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_26VCE58NYBYG"

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_0QYYJBHC34M0	CNT_1TSD8G9HGEZG	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 7	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 7	Words Dreams on the menu in this volume: a treasure's whereabouts depicted in a manga, a destiny controlled by the roll of the die, a nursery rhyme that is more than just words, a neighbor whose walls keep crashing in, a dog being tormented, a girl who isn't sure of her true self, and a haunting photo that isn't what it seems.	01KG95MXN89NBWGKV8M008M5BN	7.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 7	2016-06-30T15:00:00.000Z
PRD_0TF9XYJPF3V0	CNT_3T3T83ZSZDRG	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 5	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 5	Darkness Dreams on the menu in this volume: A woman struggling with her appearance and another trapped in darkness, a man with a sinister childhood secret, a cocoon that is more than mere silk, a delusional dream with no happy ending, a man who can not let go of past regrets, and a child's imagination that is not as innocent as it seems.	01KG95MWG78K44KQK10427PBZD	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 5	2016-06-30T15:00:00.000Z
PRD_0XJ8T4E2Q1S0	CNT_3WR4BZAASBTG	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 1	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 1	For those who suffer nightmares, help awaits at the Silver Star Tea House, where patrons can order much more than just Darjeeling. Hiruko is a special kind of private investigator. He's a dream eater. And he'll rid you of your darkest visions...for a price.Lost ThingsDreams on the menu this volume: a restless soul, a murderous beauty, a woman afraid of falling apart, a grieving lover, an unforgiving son, a suicidal actress and a mysterious voice on the other end of a lonely young man's phone.	01KG6ZG29HV6FKMAR42J1QB31Q	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 1	2016-06-30T15:00:00.000Z
PRD_0YXR8HCRB2T0	CNT_1XDQ8DM2ACSG	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 3	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 3	The Wall Dreams on the menu in this volume: an amnesiac with a misplaced sister, a voice actor who can no longer be heard, a wall that blocks true love, an author with a mystical case of writer's block, and a boy who literally masks his feelings.	01KG95MSTM2H8XY5PAQEVJTN8A	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 3	2016-06-30T15:00:00.000Z
PRD_2DXX6TGR5CCG	CNT_0HQF5TWGKQP0	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 9	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 9	Dreams on the menu in this volume: a different perspective on Chitose's past, Azusa's return as a Baku, a dream so horrible it corrupts all other dreams, and the final dream where only one Baku can survive the truth.	01KG95MHAZ3M35A3S5APC6XBMS	9.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 9	2016-06-30T15:00:00.000Z
PRD_2HHPS16F544G	CNT_0V3PSFEDBZE0	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 8	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 8	Madness Dreams on the menu in this volume: a childhood friendship that has lost its innocence, Kairi caught up in his own delusion, a sinister trap set for a Baku, an inn with deadly secrets, a sea of drowned memories, a mother's forgotten item, a man confined to an elevator, and Hifumi's family affairs.	01KG95MY508PY7T6MB841F3XAR	8.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 8	2016-06-30T15:00:00.000Z
PRD_2M614M3H13BG	CNT_2TE3RS4NPYF0	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 6	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 6	Recollection Dreams on the menu in this volume: a woman tied to a burden she can't escape and another being watched from afar, a fantastic ordeal for Hiruko's briefcase, a girl who no longer feels like herself, a rival Baku who makes nightmares worse, the truth of Hiruko's past, Mizuki's childhood memories, and Hifumi's terrible blunder.	01KG95MWY9D8W84TDQFHZ6BX11	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 6	2016-06-30T15:00:00.000Z
PRD_2RMHP8XVD2AG	CNT_0XRGR4TY5X80	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 4	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 4	Shadows Dreams on the menu in this volume: a man and woman trapped on a malevolent streetcar, a mysterious woman with a possible key to Hiruko's past, letters in a bottle that aren't the usual call for help, a young girl who dreams of a miserable future, a boy being chased by shadows, and a nightmare in which Hiruko himself disappears!	01KG95MTFDYA14D88XNHS5MMZP	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 4	2016-06-30T15:00:00.000Z
PRD_2Z501VZX919G	CNT_2X3DVPF6GW90	Nightmare Inspector: Yumekui Kenbun CNT_26VCE58NYBYG	CNT_26VCE58NYBYG	2	1	1	Volume 2	[]	Nightmare Inspector: Yumekui Kenbun, Vol. 2	The Lodger Dreams on the menu in this volume: a telephone operator who may be the girl of another patron's dreams, a blind girl whose hearing is driving her mad, a missing fiancé who may be trapped in his own painting, and a mysterious lodger intent on discovering Hiruko's private past.	01KG95MS7R6GMWPBS83YHBKYVC	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Nightmare Inspector: Yumekui Kenbun, Vol. 2	2016-06-30T15: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);