database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_3WY8QZFYNGA0"

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_0E49VZXQPCMG	CNT_31NK6SANJQS0	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 4	[]	Our Precious Conversations Volume 4	Nozomi Aizawa carried a torch for Azuma-kun, a boy in her school year, for ages...and she finally worked up the courage to ask him out, but it only made him angry. She didn't know how to feel at first, but the more she sees his thoughtful side, the happier she gets. Azuma-kun, on the other hand, had forgotten all about her confession until just now. But now that he remembers, they're growing closer by the day... So close, in fact, that they're planning on spending every day together over winter break! Volume four of this romantic comedy about a boy and a girl who just can't get through to each other, and the conversations they have along the way, will leave you smiling from ear to ear!	01KGA7F9G1JC2FMYC5N8YK5GFN	4.0	2019-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations Volume 4	(C) Robico / Kodansha Ltd.	2019-09-03T07:00:00.000Z
PRD_0JGE6B4XW630	CNT_0KP02VBK3J3G	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 3	[]	Our Precious Conversations Volume 3	After what felt like an eternity spent carrying a torch for Azuma-kun, another boy in her school year, Nozomi Aizawa works up the courage to ask him out...only to find out he's more eccentric than she could ever have imagined. Undeterred, Nozomi keeps striking up conversation with him, and over time, they grow closer. So much closer, in fact, that Azuma-kun invites her to hang out with him at his favorite place on the school grounds! All this and more in Volume 3 of Robico's hit new romance manga that'll have you smiling and laughing from beginning to end!	01KGA5R3TCZTSTCZHTGS0B6VRP	3.0	2019-07-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations Volume 3	(C) Robico / Kodansha Ltd.	2019-07-04T07:00:00.000Z
PRD_10YJF1HKN0YG	CNT_1XSKRDD171X0	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 6	[]	Our Precious Conversations 6	It took Nozomi Aizawa a long time to work up the courage to ask out Azuma-kun, a fellow second-year high-school student...and not long after she did, he forgot all about it. It's been complicated, but suddenly, Azuma-kun remembers Nozomi had feelings for him, so he works up the courage to ask her out. Once, it seemed they had no chemistry at all, but through all the conversations they've shared at the train station, the school courtyard, the lit club room, and the cafe, they finally seem to be getting close!	01KGA8GA597PSY8DDZSPF3A5X2	6.0	2020-01-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations 6	Robico / Kodansha Ltd.	2020-02-04T08:00:00.000Z
PRD_1K3M556CDAKG	CNT_0DVGFM6X8V80	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 5	[]	Our Precious Conversations 5	Nozomi Aizawa carried a torch for Azuma-kun, a boy in her school year, for ages...and she finally worked up the courage to ask him out, but it only made him angry. She didn't know how to feel at first, but now that Azuma-kun remembers she'd asked him out in the first place, he's beginning to develop feelings for Nozomi. After spending all of winter break together, they're closer than ever...and now that school's back in session, they've started walking home from class together! Volume five of this romantic comedy about a boy and a girl who just can't get through to each other, and the conversations they have along the way, will leave you smiling from ear to ear!	01KGA7PS5ANHT53BE68CGAZYMQ	5.0	2019-10-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations 5	Robico / Kodansha Ltd.	2019-11-05T08:00:00.000Z
PRD_1QMMVQB1FD0G	CNT_24HTQ85CZPXG	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 2	[]	Our Precious Conversations Volume 2	Nozomi Aizawa has kept her feelings for her schoolmate Azuma-kun a secret for quite a while, but when she finally confesses, his bizarre response begins a string of twisted tangents, misunderstandings, and off-topic rants. Undaunted by these conversational hurdles, the two grow ever closer until they finally promise to chat every day at school! Robico, author of hit series “My Little Monster,” brings smiles and laughter once again in this romantic comedy worth talking about!	01KG9Z8EMQMXTTSDAP84PZBSJ6	2.0	2017-07-24T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations Volume 2	Robico / Kodansha Ltd.	2017-08-08T04:00:00.000Z
PRD_2J4T2F6WYAB0	CNT_0PAX93NT7Z9G	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 7	[]	Our Precious Conversations 7	Nozomi had a crush on Azuma-kun for ages, but when she finally worked up the courage to tell him how she felt, things didn't go quite as planned. But she didn't let it get her down, and with every new conversation the two shared, with every new place they went together, little by little, they grew closer. Now, Azuma-kun's finally worked up the courage to tell Nozomi he has feelings for her, too...but he's not ready to ask her out for real just yet.	01KG9D7KB6PZ14BN40QZ6PAE1H	7.0	2020-09-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations 7	Robico / Kodansha Ltd.	2020-10-06T07:00:00.000Z
PRD_32VZC271DNHG	CNT_0GVGESSS9ECG	Our Precious Conversations CNT_3WY8QZFYNGA0	CNT_3WY8QZFYNGA0	2	1	1	Volume 1	[]	Our Precious Conversations Volume 1	Nozomi Aizawa has has kept her feelings for her schoolmate Azuma-kun a secret for quite a while, but the time has come for her to finally confess. His response, though, is far from ordinary! Led in circles by his hilarious tangents, these two awkward teenagers find themselves growing ever closer while muddling through misunderstandings and off-topic rants. When the airheaded stalker Aizawa-san finally connects with the petulant know-it-all Azuma-kun, the result is a romantic comedy worth talking about!	01KG98MNGSR5P70BXQ9WRZZ9KY	1.0	2017-05-08T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Our Precious Conversations Volume 1	(C) Robico / Kodansha Ltd.	2017-05-16T05: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);