database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_3YDF4J8Z3FJ0"

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_08FSARJSNBFG	CNT_3QQSMEP5PEMG	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 4	[]	The Disappearance of Nagato Yuki-chan, Vol. 4	When Yuki is grazed by a car on her way home from school, her minor injuries belie the drastic change that has taken place within her: the "Yuki Nagato" after the accident is not the same person as the Yuki from before. The new Yuki has all of the same memories, but they feel as if they were lived by someone else. How will Yuki's fellow club members react to their new friend? And how will Yuki respond to the lingering impressions of her feelings for Kyon...?	01KG981Z5YGG0MQ6BSKK38TR0B	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 4	2016-06-30T15:00:00.000Z
PRD_0E54BHCTFHP0	CNT_0YS6YQ0ZMTF0	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 10	[]	The Disappearance of Nagato Yuki-chan, Vol. 10	The members of the Literature Club have graduated and are about to go their separate ways! With Asakura going to study abroad in Canada and the others moving on to college, the group says its goodbyes in this final volume!	01KG9VS11XW0N1EKVGRPHRXFF9	10.0	2017-10-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 10	2017-10-31T07:00:00.000Z
PRD_0Q6XT6ZMX15G	CNT_3KSBARMK9MEG	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 3	[]	The Disappearance of Nagato Yuki-chan, Vol. 3	Bit by bit, Yuki gains confidence in herself and is able to relax around Kyon. But now that Yuki has taken her first steps in expressing her feelings, mother-hen Asakura worries that her little girl (?) might start pushing things too quickly. Asakura won't stand for any indecorous romancing on her watch. And she will be watching...	01KG9826BZCYFFSWR20J95Y2GA	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 3	2016-06-30T15:00:00.000Z
PRD_1PMV2PNVRXXG	CNT_2561WJA1M850	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 6	[]	The Disappearance of Nagato Yuki-chan, Vol. 6	When he joins the organization committee for the joint Kouyouen-North High festival, Kyon is reunited with Sasaki, an old friend from middle school. Their renewed friendship draws a confession out of Sasaki that could change everything! A romantic challenger has appeared!!	01KG97T9RVK2HBCM81RYF3KVQV	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 6	2016-06-30T15:00:00.000Z
PRD_26XJE54NGMRG	CNT_38VCBW8WKET0	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 9	[]	The Disappearance of Nagato Yuki-chan, Vol. 9	Now that their relationship has been discovered, Yuki and Kyon must endure the "encouragement" of Asakura and their friends as their relationship continues to blossom. But will the additional scrutiny and pressure push them to the breaking point, or drive them closer together?	01K5G9XZXZNWS0FEJ2G3M1BDRH	9.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 9	2016-06-30T15:00:00.000Z
PRD_2WHHHPDH9XRG	CNT_2009B421A7T0	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 5	[]	The Disappearance of Nagato Yuki-chan, Vol. 5	Yuki- that is, the "Yuki Nagato" from before her accident-has recovered. Before she awakens, however, she is able to meet the Yuki who had taken her place while she slept. Her other self found the courage to tell Kyon her feelings directly. Now that she's back to normal, is it time for this Yuki to do the same...?	01KG981B21PRQWW8BQZ8JS9S16	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 5	2016-06-30T15:00:00.000Z
PRD_2ZQN1YSJZAQG	CNT_0F50RARMMMK0	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 8	[]	The Disappearance of Nagato Yuki-chan, Vol. 8	The heart-stirring ordeals of Christmastime are over. Kyon and Yuki are more conscious of each other than ever, but even now, there's a strange distance between them. As the shrine visits of the new year end and the cold days of school start anew, Yuki finally follows her fortunes...and her heart.	01KG95HPNQCJCYKD82ZTG0BA0Q	8.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 8	2016-06-30T15:00:00.000Z
PRD_33SGBK8G573G	CNT_3ZTX9AH0VT0G	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 2	[]	The Disappearance of Nagato Yuki-chan, Vol. 2	This spin-off of the bestselling Haruhi Suzumiya series takes place in the world of the "Disappearance" arc of the original novels, focusing on the high school life (and romance!) of a tentative and bashful Yuki Nagato quite unlike the one you've come to know and love through the usual exploits of the SOS Brigade...but no less charming!	01KG982DG4J32N48KC1JEJEWPS	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 2	2016-06-30T15:00:00.000Z
PRD_3RTHDDDBWSXG	CNT_3X5KED6G1W6G	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 1	[]	The Disappearance of Nagato Yuki-chan, Vol. 1	This spin-off of the bestselling Haruhi Suzumiya series takes place in the world of the "Disappearance" arc of the original novels, focusing on the high school life (and romance!) of a tentative and bashful Yuki Nagato quite unlike the one you've come to know and love through the usual exploits of the SOS Brigade...but no less charming!	01KG94K2Y7E8PS03XFXT9XGX41	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 1	2016-06-30T15:00:00.000Z
PRD_3VNSPMHSZRQ0	CNT_0F6PWWZ5BJWG	The Disappearance of Nagato Yuki-chan CNT_3YDF4J8Z3FJ0	CNT_3YDF4J8Z3FJ0	2	1	1	Volume 7	[]	The Disappearance of Nagato Yuki-chan, Vol. 7	With Christmas and entrance exams rapidly approaching, everyone is becoming a bit contemplative, but no two more so than Yuki and Kyon. As an eventful year draws to a close, is their relationship the same as ever, or do subtle changes add up over time...?	01KG95KJ6H4330SRW94K0ZDTYZ	7.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Disappearance of Nagato Yuki-chan, Vol. 7	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);