database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_2148STGP6A00"

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_11MX6YS0T140	CNT_2DKXTVS02BTG	Atsumori-kun's Bride-to-Be CNT_2148STGP6A00	CNT_2148STGP6A00	2	1	1	Volume 6	[]	Atsumori-kun's Bride-to-Be 6	Nishiki arranges to meet with Atsumori's father, but her grandfather collapses on the same day, and she's forced to suddenly cancel. Her grandfather is admitted into the hospital owned by Atsumori's family, and when she runs into his father there, he gives her the cold shoulder. Despite her setbacks, Nishiki resolves to get into medical school with Atsumori, and devotes herself to studying for the entrance exams. Meanwhile, Atsumori's brother Yukishika has declared that he'll be the one to take over the family business. Atsumori finds himself feeling deeply conflicted, and runs away on an elopement trip with Nishiki! As Atsumori realizes the depth of his feelings, he officially asks Nishiki to marry him...?! Nishiki and Atsumori's awkward love finally reaches its resolution!	01KG9G45F3CPZTEMRZBSNDXQAW	6.0	2021-06-11T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Atsumori-kun's Bride-to-Be 6	Taamo / Kodansha Ltd.	2021-06-29T07:00:00.000Z
PRD_18ETCWZXTVT0	CNT_0KPJXPSN1WJG	Atsumori-kun's Bride-to-Be CNT_2148STGP6A00	CNT_2148STGP6A00	2	1	1	Volume 4	[]	Atsumori-kun's Bride-to-Be 4	""I'll try harder next time..."" After a brief stint as Atsumori's temporary girlfriend, Nishiki is finally Atsumori's actual girlfriend. Around that time, Nishiki's fiance, Takara-kun, comes to Tokyo and tells Atsumori that he still loves Nishiki! Takara-kun's arrival prompts a shift in Atsumori, who had been struggling to be sure whether or not he loved Nishiki; he's finally able to break through his confusion, and grows even closer to Nishiki... Meanwhile, Kano-chan, who had resolved to continue her one-sided love for Takara-kun, is in disarray after seeing how Takara-kun still has feelings for Nishiki...	01KG9BKAWAMT2B39E092QQFD1K	4.0	2020-03-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Atsumori-kun's Bride-to-Be 4	Taamo / Kodansha Ltd.	2020-03-31T07:00:00.000Z
PRD_1FPY2Z3M6YYG	CNT_3BG9RXRQNFX0	Atsumori-kun's Bride-to-Be CNT_2148STGP6A00	CNT_2148STGP6A00	2	1	1	Volume 3	[]	Atsumori-kun's Bride-to-Be 3	Nishiki is starting to adjust to her new life in Tokyo after she came to school to chase after Atsumori, who had visited her hometown. Atsumori continues to help her out, until one day he invites her to dinner with his family and she becomes his temporary girlfriend! But, during the dinner Nishiki understands Atsumori's loneliness for the first time, and she resolves to always be by his side. And just as she's accepted the end of their temporary relationship, Atsumori kisses her and makes it official. However, Takara-kun, her fiance from back home, is still waiting on her?! Thus begins a heated love triangle!! Don't miss Volume 3 of the awkward romance between a pure country girl and a spoiled Tokyo heir!	01KGA7N4A09HJ2YPRGXJ7S877N	3.0	2019-10-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Atsumori-kun's Bride-to-Be 3	Taamo / Kodansha Ltd.	2019-10-22T07:00:00.000Z
PRD_20D27CSA4D00	CNT_1RWVAKSP22CG	Atsumori-kun's Bride-to-Be CNT_2148STGP6A00	CNT_2148STGP6A00	2	1	1	Volume 5	[]	Atsumori-kun's Bride-to-Be 5	"Let's get married, Nishiki." On their first heart-pounding overnight trip together, Nishiki and Atsumori's feelings will grow even stronger... When Nishiki returns to her hometown over summer break, she shares her new dream of becoming a doctor with her parents. Her father quickly rejects the idea, though, and to make matters worse, things are awkward with Takara and Kano. In the midst of all this, Atsumori, who was supposed to be studying for his college exams in Tokyo, shows up at Nishiki's house! He introduces himself to her parents, and his sincerity makes an impression on Nishiki's skeptical father. Inspired by the meeting, Atsumori invites Nishiki to meet his father, but the night of their appointment, the unthinkable happens...	01KG9D9XJ288AV09933NPS9Q9B	5.0	2020-10-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Atsumori-kun's Bride-to-Be 5	Taamo / Kodansha Ltd.	2020-10-27T07:00:00.000Z
PRD_2WVW72QBS1FG	CNT_1X21ZM5QYXP0	Atsumori-kun's Bride-to-Be CNT_2148STGP6A00	CNT_2148STGP6A00	2	1	1	Volume 2	[]	Atsumori-kun's Bride-to-Be 2	Nishiki has a fiance arranged for her, but when she meets Atsumori, the high school student visiting from Tokyo, she chases after him and enrolls at his school. As Atsumori helps Nishiki adjust to her city, her feelings for him only grow stronger. One day, a surprise rain shower ends with Nishiki going to Atsumori's apartment. But while the two are there, Atsumori's mother suddenly appears! Nishiki is flustered by the rapid development, but then Atsumori introduces Nishiki as his “number one choice for a bride”?! Nishiki's life as a temporary girlfriend begins in Volume 2!	01KGA7HVVHPVGT0VPSY0Y2RZ54	2.0	2019-09-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Atsumori-kun's Bride-to-Be 2	(C) Taamo / Kodansha Ltd.	2019-09-24T07:00:00.000Z
PRD_3X42H71Q0PF0	CNT_25ZAG6H3T2QG	Atsumori-kun's Bride-to-Be CNT_2148STGP6A00	CNT_2148STGP6A00	2	1	1	Volume 1	[]	Atsumori-kun's Bride-to-Be 1	Nishiki, who lives out in the countryside, loves studying. But due to the arranged marriage her parents have planned for her, she's finding her hometown a bit cramped. One day, she happens to meet Atsumori, a high schooler from Tokyo. Motivated by his unique sense of values, Atsumori suggests that Nishiki run away with him and get married! Having grown fond of Atsumori, Nishiki decides to chase after him by getting into a high school in Tokyo...?! A new series from Taamo, author of “House of the Sun.”	01KGA62W29HS3A93AWCCJ0QFZD	1.0	2019-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Atsumori-kun's Bride-to-Be 1	(C) Taamo / Kodansha Ltd.	2019-08-27T07: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);