database: products: 11 rows where series_id = "CNT

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

11 rows where series_id = "CNT_2FNNXYG4GYAG"

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_0FPZ389C40FG	CNT_3GABC36S64G0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 8	[]	Sweat and Soap 8	Now that Kotaro and Asako have met each other's families, things should be smooth sailing from here on out—right? But there's still their ﬁrst company trip as a couple, not to mention some unexpected... gains...of romantic bliss to navigate. With their inner weirdos rearing their freaky heads, can Kotaro and Asako keep their ship aﬂoat?	01KG9GJS8QFHCFD34JVMHNXPKF	8.0	2021-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 8	Kintetsu Yamada / Kodansha Ltd.	2021-08-31T07:00:00.000Z
PRD_0M489QAB1MW0	CNT_0G94TFD1D8CG	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 9	[]	Sweat and Soap 9	Now that Kotaro and Asako have gotten used to living together, they've started to think about what their future holds. It's an exciting—and somewhat terrifying—prospect, one made all the more difﬁcult when the haunting reappearance of a ghost from Asako's past threatens their happily ever after...	01KG9GX6XEQBAP524DX05XD6Z3	9.0	2021-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 9	Kintetsu Yamada / Kodansha Ltd.	2021-09-21T07:00:00.000Z
PRD_0PYQ2594M8VG	CNT_2HWXCCEDSSG0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 2	[]	Sweat and Soap 2	Asako Yaeshima and Kotaro Natori's scent-sual relationship is going well, though they've decided to keep it a secret from their coworkers for now. However, Kotaro's protégé, Korisu Ichise, can sense something's going on between the two of them... but what? And when Asako tells her family about her new beau, her brother decides Kotaro needs to be put to the test. Because a playboy like Kotaro must spell doom for his sister... right?	01KGA90XX1W11E825K7R4WGK0T	2.0	2020-04-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 2	Kintetsu Yamada / Kodansha Ltd.	2020-04-28T07:00:00.000Z
PRD_1DJJQDCR72P0	CNT_15D205TSKP20	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 5	[]	Sweat and Soap 5	With great effort, the notorious workaholic Natori has managed to carve out a real holiday break, with time away from the office to spend with his girlfriend Asako. But that doesn't mean he's been able to tear himself away long enough to get her a proper present, and by the time he starts looking for a Christmas reservation at the restaurant he's had his heart set on, they're full up! For her part, Asako's been completely swamped—the books have to be closed for the end of the year, so 'tis the season to log overtime in the accounting department!	01KG9DMBC6E06P2PVD5H6MAEA8	5.0	2020-12-09T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 5	Kintetsu Yamada / Kodansha Ltd.	2021-01-05T08:00:00.000Z
PRD_1HTTM11PFXVG	CNT_3E59P7F0M7A0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 6	[]	Sweat and Soap 6	Despite all the anxieties and obstacles, Asako and Natori's relationship has proven its staying power. Since deciding to move in together, they've found a home they both like, and a new chapter in both their lives has begun! But now that they've taken this adult step, there's an even bigger one looming further up the staircase...but can Asako even think about marriage without breaking a sweat?	01KG9F8HKKGSD45ZDV010B2W08	6.0	2021-05-12T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 6	Kintetsu Yamada / Kodansha Ltd.	2021-06-01T07:00:00.000Z
PRD_1PMHNNYV54TG	CNT_1RGFSMQZK5H0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 1	[]	Sweat and Soap 1	Don't miss a romcom manga like no other! In an office romance, there's a fine line between sexy and awkward ... and that line is where Asako—a woman who sweats copiusly—met Koutarou—a perfume developer who can't get enough of Asako's, er, scent. Asako's living her dream, working at the toiletry maker Lilia Drop. Little do her coworkers know, the reason she loves the company so much is that she's ashamed of her body odor, and their soap is the only thing that does the trick. So when the company's lead product developer, a perfuming genius, approaches her in the lobby and wonders what ""that smell"" is, she's terrified ... but could it be ... that he likes it? And, even more surprising to Yae ... does she like him? The hilarious ups and downs of an office romance at a personal care products company are the subject of this sexy, strange romp. Sweat and Soap combines the odd-couple chemistry of Wotakoi, the ""too real!"" workplace comedy of Aggretsuko, and a heavy dollop of office steaminess!	01KG9BQ8AD6RDAN94ETTDMMWVE	1.0	2020-01-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 1	Kintetsu Yamada / Kodansha Ltd.	2020-02-25T08:00:00.000Z
PRD_1YGPA0QQVJ2G	CNT_0ZJ1B99PYPD0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 11	[]	Sweat and Soap 11	WEDDING BELLS ARE RINGING The ceremony is just around the corner, but there's still a lot to be done: ﬁnalizing the guest list, sending out invitations, picking out wedding favors, ﬁguring out ﬂower arrangements... The tasks are endless and exhausting. Can Asako and Kotaro get everything done in time for their big day?! FINAL VOLUME!	01KGAD4XRDWY7ZV2PF4G5XGZ6B	11.0	2021-11-09T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 11	Sweat and Soap Kintetsu Yamada/Kodansha Ltd.	2021-12-14T08:00:00.000Z
PRD_287R0K7FH6NG	CNT_29NGK13TFTY0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 3	[]	Sweat and Soap 3	The office romance between the quiet and sweet accountant Asako, who's spent her life ashamed of how much she sweats, and rising star of the bath and toiletry world Kotaro got off to a fast and steamy start! Kotaro's status at the company has made her wary of revealing their relationship to their colleagues at Liliadrop, and she's stumbled into the discovery that Kotaro has been mentoring an attractive, young product developer named Korisu. He doesn't seem to have feelings for her, but might she be harboring a secret crush? Awkwardness explodes into anxiety when Kotaro tells her he's scheduled to take a four-day business trip with Korisu–just the two of them! Can Asako's budding relationship survive, and what's Korisu planning to do over three nights with her supposedly-single boss? The hilarious ups and downs of an office romance at a personal care products company are the subject of this sexy, strange romp. Sweat and Soap combines the odd-couple chemistry of Wotakoi, the "too real!" workplace comedy of Aggretsuko, and a heavy dollop of office steaminess!	01KG9CWBGMRN36KTGDE65T5GMT	3.0	2020-07-31T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 3	Kintetsu Yamada / Kodansha Ltd.	2020-08-18T07:00:00.000Z
PRD_2ND38QD7KMC0	CNT_3G0RRN423SGG	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 4	[]	Sweat and Soap 4	Natori and Asako are back from their first trip together, a romantic getaway to Hokkaido. But when Asako returns to the office, her anxiety comes back, too, because it's time to let their secret out and reveal their relationship to their coworkers. Natori sets up a lunch to introduce Asako to his teammates in product development. But this is a far cry from the accounting department, and Natori's coworkers all seem fashionable, ambitious, cool—on a whole different level! Suddenly, those moments spent soaking in the hot spring bath seem so far away! The hilarious ups and downs of an office romance at a personal care products company are the subject of this sexy, strange romp. Sweat and Soap combines the odd-couple chemistry of Wotakoi, the "too real!" workplace comedy of Aggretsuko, and a heavy dollop of office steaminess!	01KG9D67C1WJF2V1ASP7Z7N5MS	4.0	2020-09-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 4	Kintetsu Yamada / Kodansha Ltd.	2020-10-06T07:00:00.000Z
PRD_2TP6XEN3JH5G	CNT_2B0SZGPZZBR0	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 7	[]	Sweat and Soap 7	After a lot of discussion and planning (and so many Post-It notes), Kotaro and Asako move in together, and a new era of their relationship dawns! But will these meticulously-laid plans stand up to the pressures and annoyances of real life? Pressures like...meeting the family? Kotaro's managed to smooth things over with Asako's family so far, but his own relatives haven't had the chance to meet Asako yet. She's excited to see how Kotaro grew into the genius scent designer he is today, but she's also apprehensive. Will she leave the right impression, or will that familiar panic overtake her once again?	01KG9G5MPBGY0GX5SV3R9Z083X	7.0	2021-06-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 7	Kintetsu Yamada / Kodansha Ltd.	2021-07-27T07:00:00.000Z
PRD_32C2Y4CRBD80	CNT_1XQCB2FPWHGG	Sweat and Soap CNT_2FNNXYG4GYAG	CNT_2FNNXYG4GYAG	2	1	1	Volume 10	[]	Sweat and Soap 10	FIRST COMES LOVE, THEN COMES... ...well, a whole lot of stuff. Kotaro and Asako have been through a lot, and now they're ﬁnally ready to take the big plunge. Whatever comes next, they're committed to seeing it through—together.	01KG9H99GD8GRBRYXCYD0XH94B	10.0	2021-10-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweat and Soap 10	Sweat and Soap Kintetsu Yamada/Kodansha Ltd.	2021-11-16T08: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);