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_0TWGES7K1ZP0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_04SBS249F32G	CNT_2QVCNQM77Z30	My Pink is Overflowing CNT_0TWGES7K1ZP0	CNT_0TWGES7K1ZP0	2	1	1	Volume 1	[]	My Pink is Overflowing 1	Himari's a waitress with terrible luck with men, always getting compared to other women and cast aside by those she falls in love with. Thanks to a weakness for men in white dress shirts, though, she can't help but be attracted to her handsome manager. However, sick of being heartbroken, she vows instead to only date inexperienced men so she won't be compared to other women. She goes to a mixer and gets acquainted with someone she thinks could be the one, but it turns out he's only got one thing on his mind ... Then she has an unexpected encounter with her manager on the street, and the two of them end up at a love hotel, where she discovers ...		01KGA5W6GA9AC2SM056HJBJB21	1.0	2019-03-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Pink is Overflowing 1	(C) Yuki Monou / Kodansha Ltd.	2019-04-09T07:00:00.000Z
PRD_1DXFNZ2PYCB0	CNT_3XF7ASAW88BG	My Pink is Overflowing CNT_0TWGES7K1ZP0	CNT_0TWGES7K1ZP0	2	1	1	Volume 2	[]	My Pink is Overflowing 2	Himari is a cafe waitress who has terrible luck with men. She has a weakness for handsome men in white dress shirts, so she just can't help but be attracted to her manager. In an unexpected turn of events, she discovers that her crush is actually a virgin, and she decides to date him!! Everything is going well, and they seem like a proper couple, but as they get closer to having sex for the first time, problems start to pop up. Problems such as Himari's ex-boyfriend, and the manager's condom dilemma!!	The second volume of the big hit My Pink is Overflowing is here!	01KGA7D7EASB82NEBPQMKDY54F	2.0	2019-07-24T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Pink is Overflowing 2	(C) Yuki Monou / Kodansha Ltd.	2019-08-06T07:00:00.000Z
PRD_1JTR6JZSJBVG	CNT_11006B0Y1PT0	My Pink is Overflowing CNT_0TWGES7K1ZP0	CNT_0TWGES7K1ZP0	2	1	1	Volume 3	[]	My Pink is Overflowing 3	The third volume of the big hit My Pink is Overflowing is here! Himari is a cafe waitress who has terrible luck with men. She has a weakness for handsome men in white dress shirts, so she just can't help but be attracted to her manager. In an unexpected turn of events, she discovered that he is actually a virgin. She then decided to date him!! Their relationship was progressing smoothly, and they couldn't stop thinking about their “first night.” Their first hot spring trip was filled with heart-throbbing passion. During the trip, the two finally decided to go all the way…!!		01KGA7F8G99Q8Z3PTDHTHRM9SN	3.0	2019-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Pink is Overflowing 3	(C) Yuki Monou / Kodansha Ltd.	2019-09-03T07:00:00.000Z
PRD_26H5SF487WKG	CNT_04PR76CXAFW0	My Pink is Overflowing CNT_0TWGES7K1ZP0	CNT_0TWGES7K1ZP0	2	1	1	Volume 5	[]	My Pink is Overflowing 5	Himari is a café waitress who has terrible luck with men. She has a weakness for handsome men in white dress shirts, so she just can't help but be attracted to her manager. In an unexpected turn of events, she discovered that he is actually a virgin. She then decided to date him!! The two of them had a romantic six-month anniversary, and Himari also got to meet the manager's parents. Is this a sign that those two will finally get married?! However, Himari later found herself in a dilemma!		01KG9FTB92FPKF2PH6ADMYZ62D	5.0	2021-09-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Pink is Overflowing 5	My Pink Is Overflowing Yuki Monou/Kodansha Ltd.	2021-10-12T07:00:00.000Z
PRD_2EV6H0K8EQPG	CNT_2FAJG0FW2SP0	My Pink is Overflowing CNT_0TWGES7K1ZP0	CNT_0TWGES7K1ZP0	2	1	1	Volume 6	[]	My Pink is Overflowing 6	Himari has always had terrible luck with men. Through an unexpected turn of events, she discovered that Ichiya, her handsome boss, is actually a virgin, and ended up dating him! While Himari is considering marriage, Ichiya goes overseas for his training. In his absence, her co-worker Hasumi confesses that he's genuinely in love with her! Himari and Ichiya have overcome various "firsts" together, and now, they'll finally get their happy ending!		01KGAGKTDMP9HAB5AVD4GWFG82	6.0	2022-05-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Pink is Overflowing 6	My Pink Is Overflowing Yuki Monou/Kodansha Ltd.	2022-05-31T07:00:00.000Z
PRD_3MBG95D8XG80	CNT_0YX6ZWZR02CG	My Pink is Overflowing CNT_0TWGES7K1ZP0	CNT_0TWGES7K1ZP0	2	1	1	Volume 4	[]	My Pink is Overflowing 4	Himari and her boss can't see each other since they work different shifts, much to Himari's dismay. When Himari comes to help out a sister cafe, she encounters a student named Hasumi, who's also working there. He's also handsome ... in a white dress shirt ... and when Himari lays eyes on him, her longing for her boss just grows even stronger … !!		01KGA7M3FFMJRNB699K6V7ED6T	4.0	2019-10-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Pink is Overflowing 4	(C) Yuki Monou / Kodansha Ltd.	2019-10-08T07: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);