database: products: 16 rows where series_id = "CNT

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

16 rows where series_id = "CNT_3RHWAW7F9YA0"

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_01ZWJ6HQ468G	CNT_1WR0EGT94ARG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 15	[]	GE: Good Ending 15	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! Worrying about Kurokawa, Utsumi ignores a call from Shou to go check on Kurokawa in person. To Kurokawa's chagrin, Utsumi has decided he can't just leave her alone. Suddenly, Kurokawa's ex-boyfriend Toru appears in front of both of them. Utsumi tries to protect Kurokawa as she stands frozen in fear, but Toru tells them that the events that wounded Kurokawa were all a misunderstanding. The truth of Kurokawa's dark past is finally revealed...	01KG9ET3RDZRFKPPSCKMT4PJ37	15.0	2021-02-26T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 15	Kei Sasuga / Kodansha Ltd.	2021-03-16T07:00:00.000Z
PRD_0EM3WBSK8HWG	CNT_0N5R9C68JJZ0	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 4	[]	GE: Good Ending 4	When it comes to his daughter Hime, manga artist Kakushi Gotou is a dyed-in-the-wool worrywart. Between his co-workers at the manga studio and the women in his daily life, it's nothing but trouble for him on a daily basis! Plus: Eight original color pages, continuing the story of 18-year-old Hime as she explores her mysterious past, as well as another batch of Koji Kurume's ""Writing the Truth about the Drawing Business"" essays!	01KGA90JPM8VM56PJPTE2Q7A2T	4.0	2020-04-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 4	Kei Sasuga / Kodansha Ltd.	2020-04-21T07:00:00.000Z
PRD_0F8QM1V83AX0	CNT_3T0MGN24RZ7G	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 6	[]	GE: Good Ending 6	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! It's summer vacation, and Utsumi feels the distance between Kurokawa and himself slowly starting to shrink. But a few days later, he finds out that Kurokawa has gone back to his hometown, and is plunged into anxiety about what might happen there. Utsumi and his friends decide to follow her there, but at the same time, Kurokawa's ex-boyfriend Toru is back in town, too. Which one will meet Kurokawa first?!	01KGA99FK91KTKGX5VYN9ZTAG1	6.0	2020-06-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 6	Kei Sasuga / Kodansha Ltd.	2020-06-16T07:00:00.000Z
PRD_0WE836HAVPQG	CNT_08EFJVMDGT1G	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 12	[]	GE: Good Ending 12	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! Consumed with feelings of guilt, Utsumi tells everyone that he's started dating Shou. Kurokawa calmly congratulates Utsumi, but Eri, who had been secretly rooting for Utsumi and Kurokawa's love, becomes upset and throws the group's friendship into chaos. Have Kurokawa's feelings for Utsumi vanished? And how will Utsumi, Kurokawa, and Shou manage to navigate Valentine's Day...?!	01KG9DHTTXT8F7T829R87FGNEY	12.0	2020-12-02T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 12	Kei Sasuga / Kodansha Ltd.	2020-12-15T08:00:00.000Z
PRD_11NS5N75MJFG	CNT_07BJRZ3TZPSG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 13	[]	GE: Good Ending 13	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! While Utsumi and Shou are celebrating Shou's acceptance into college, they go to see Utsumi's entry into a photography competition. But instead of the picture of Shou he thought would be there, a picture of Yuki is displayed instead! Unable to stand the sight of it, Shou releases all the pent-up frustration she's been keeping inside, and Utsumi is left speechless. He vowed to make Shou happy, but how can he convey those feelings now...?	01KG9DXA0B2GBAQ9SA75EFS0PV	13.0	2021-01-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 13	Kei Sasuga / Kodansha Ltd.	2021-01-19T08:00:00.000Z
PRD_13Q0ARZCWYBG	CNT_2PTBBMFH3JXG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 14	[]	GE: Good Ending 14	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! During a date, Utsumi and Shou run into Kento, Shou's ex-boyfriend. The two of them leave without talking to him, but later, Kento shows up at Utsumi's school to ask for Shou's contact info. Utsumi refuses, but will that be the end of it...? Meanwhile, Utsumi and Kurokawa are managing to preserve their friendship, but when a new member of the tennis team falls in love with Kurokawa at first sight, the delicate balance starts to get shaken up...!!	01KG9EMDDZVEXA6ZPFWXB7DGB4	14.0	2021-02-04T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 14	Kei Sasuga / Kodansha Ltd.	2021-02-16T08:00:00.000Z
PRD_13ZBSHM80CJ0	CNT_1MA6WP4840JG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 7	[]	GE: Good Ending 7	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! While at the tennis training camp, Utsumi and Kurokawa end up getting locked outside for a night. While spending the night with each other, they realize their feelings have finally aligned. But will some unexpected actions by Shou-sempai, Utsumi's first crush, send Utsumi and Kurokawa back to square one? And what shape will Onuma's one-sided crush on Utsumi take next?!	01KG9CTNHM9GTFN6AY9GVCC0EW	7.0	2020-07-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 7	Kei Sasuga / Kodansha Ltd.	2020-07-23T07:00:00.000Z
PRD_1AHDMCZBWJDG	CNT_29HJBV6Q7ME0	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 1	[]	GE: Good Ending 1	From the creator of the surprise-hit romantic comedy Domestic Girlfriend! High school student Eiji is in love with Aki, the head of the tennis team, but he is unable to ask her out. Another student, Yuki, discovers his obsession with Aki, and promises to help him get closer to her ... but Yuki's help comes at a cost, and soon, the analytical, strategic Eiji finds himself deep in the messy turmoil of emotion ...	01KG9BP56RMJQM1DCAGR41ZK3J	1.0	2020-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 1	Kei Sasuga / Kodansha Ltd.	2020-01-14T08:00:00.000Z
PRD_1AP590EF2HYG	CNT_3SPXNBCXPJX0	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 5	[]	GE: Good Ending 5	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! Utsumi has finally made up with Kurokawa after they share a kiss. However, after Utsumi learns that Shou-sempai, his first crush, has feelings for him now, he finds himself unsure how to proceed. And with the arrival of summer vacation, Utsumi tries to find a way to verify how Kurokawa feels about him...	01KGA92XW809ZT25DBA8YVHXGN	5.0	2020-05-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 5	Kei Sasuga / Kodansha Ltd.	2020-05-19T07:00:00.000Z
PRD_1VSMZYNSVWT0	CNT_163K08G20XJG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 3	[]	GE: Good Ending 3	Utsumi is heartbroken after his first love, Shou-sempai, found a boyfriend. When he starts a new part-time job, he meets the other new hire, a girl named Risa Onuma. Around the same time, he finds out that Kurokawa is going on a date with another guy, and he freaks out. Utsumi feels torn between his lingering heartbreak and his blossoming feelings for Kurokawa. A manga for bashful guys who want to make their love dreams come true!	01KGA8TKKJBDPJP62HGDXGEWRF	3.0	2020-03-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 3	Kei Sasuga / Kodansha Ltd.	2020-03-17T07:00:00.000Z
PRD_2CEGT4EFXAC0	CNT_3JEVAVJG9ZGG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 8	[]	GE: Good Ending 8	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! Kurokawa's past romance is weighing heavily on Utsumi. But his love for her lets him overcome his fears, and he confesses his feelings at the school culture festival. Kurokawa accepts his feelings, and they finally become a couple. But the shadow of Kurokawa's ex-boyfriend, Toru, still looms large, and as the new couple deepens their relationship, ripples from the past continue to spread...	01KG9CYBZHVKKNGHXP3HDTD07S	8.0	2020-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 8	Kei Sasuga / Kodansha Ltd.	2020-08-18T07:00:00.000Z
PRD_2JN49BP25JT0	CNT_1RHNJEYG63JG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 2	[]	GE: Good Ending 2	Mega-clutz Seiji Utsumi has been satisfied just to watch from afar his beloved ""tennis court girl,"" Shou-sempai. But once his classmate Yuki Kurokawa finds out, Seiji's love begins to progress quickly!! Can this cowardly boy reach the ""good ending""?! A bible for success in love for all men who want to understand the feminine spirit!	01KGA8K2TPBTMKN024XXKP056A	2.0	2020-02-04T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 2	Kei Sasuga / Kodansha Ltd.	2020-02-18T08:00:00.000Z
PRD_2TWD0KB76Y0G	CNT_0JDN07TRC330	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 10	[]	GE: Good Ending 10	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! Kurokawa has been feeling more and more weighed down by the pressure of Utsumi's kindness and consideration, and when she can no longer bear it, she tells Utsumi she wants to break up. Utsumi is unable to accept this new reality, and hides himself away in the apartment of Mai, a girl he met through his photography seminar. When Kurokawa and the others find out, they head there to confront their friend...	01KG9D9BGH3Z2307BGTZ1ZCAVV	10.0	2020-10-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 10	Kei Sasuga / Kodansha Ltd.	2020-10-20T07:00:00.000Z
PRD_2XJENPWJJ6V0	CNT_1QGBBDVZKASG	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 11	[]	GE: Good Ending 11	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! After randomly running into Kurokawa on Christmas, Utsumi is able to view the light display with her as he'd hoped, and neither of them realizes that Kurokawa's ex-boyfriend, Toru, was there as well. However, Utsumi quickly becomes depressed as the reality sets in that Kurokawa doesn't seem to share his feelings anymore. As he's spending New Year's on his own, his first crush, Shou-sempai, appears to fill the hole in his heart once again...	01KG9DCN194R673T335Y1V3S85	11.0	2020-11-04T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 11	Kei Sasuga / Kodansha Ltd.	2020-11-17T08:00:00.000Z
PRD_3RBJ3S0CE55G	CNT_3V4JE5D4GZR0	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 16	[]	GE: Good Ending 16	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! During the tennis team's customary summer training camp, Kurokawa vanishes from her room in the middle of the night. As Utsumi frantically searches for Kurokawa, he comes face to face with his fear of losing her, and realizes that he still loves her. Then, two days after the camp ends, Utsumi receives word that Kurokawa has gone missing again... Don't miss the moving conclusion to this turbulent love story!	01KG9F13SQMSEGMS0AS801M433	16.0	2021-03-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 16	Kei Sasuga / Kodansha Ltd.	2021-04-13T07:00:00.000Z
PRD_3V7M2QAVN7X0	CNT_2G9WMT2D6C7G	GE: Good Ending CNT_3RHWAW7F9YA0	CNT_3RHWAW7F9YA0	2	1	1	Volume 9	[]	GE: Good Ending 9	Seiji Utsumi was satisfied with just gazing at his beloved Shou-sempai from afar. But when his classmate, Yuki Kurokawa, finds out about his crush, she pushes him to take action, and his one-sided love starts moving rapidly! Kurokawa receives a letter from her ex-boyfriend, Toru, which prompts a fight between her and Utsumi. After Kurokawa brings Utsumi a present and cake for his birthday, the ill-will melts away, and the two find themselves closer than before. But as things heat up, Utsumi finds that Kurokawa's past is still closer than he thought...	01KG9D4JARBKZR0WCG7EEY32SQ	9.0	2020-09-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	GE: Good Ending 9	Kei Sasuga / Kodansha Ltd.	2020-09-15T07: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);