database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_11Y6DQ2ZJGA0"

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_04DX9JMYY0P0	CNT_2JWXDS1359F0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 2	[]	Dreamin' Sun Vol. 2	When Shimana fails to work up the courage to ask Asahi out on a date, she decides it's time to get a makeover as part of her self-improvement plan. But when she calls Asahi to come check out her new look, she's too preoccupied with his own crush to pick up the phone. Is her transformation all for nothing? And what are those weird heart palpitations Zen's getting every time he looks at Shimana? It's a full house of unrequited love and self-discovery in volume 2 of this slice-of-life romance!	Home Is Where the Heart Is	01KG9Z46B15B5B9KX73E0CN2D6	2.0	2017-07-11T05:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 2	(C) Ichigo Takano 2007	2017-07-11T05:00:00.000Z
PRD_0BG87266Y0VG	CNT_2NMMJ0YAD4ZG	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 8	[]	Dreamin' Sun Vol. 8	Shimana is still trying to work through her feelings for Taiga, her curmudgeonly landlord. As if that weren't hard enough, almost everyone--from her roommate Zen to Taiga's father--seems determined to keep them apart! Meanwhile, Shimana's biggest ally, Asahi, is suffering heartbreak of his own...	Love will tear us apart, again	01KGA5AAXAT2ZNN9XZBYJXD67Z	8.0	2018-09-24T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 8	Ichigo Takano 2007	2018-10-30T07:00:00.000Z
PRD_0F64MJTMFKVG	CNT_2BYD81AZJTS0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 5	[]	Dreamin' Sun Vol. 5	Things are heating up between Shimana and the landlord. First a confession and then an invitation to the school's Founders' Day Festival! What will the landlord do when Shimana announces her feelings for him on stage, in front of a huge crowd?	I <3 YOU!	01KGA198TRYHA6NZT6ZMPV57E5	5.0	2017-12-19T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 5	(C) Ichigo Takano 2007	2018-01-02T08:00:00.000Z
PRD_0G1DRXGTNNZ0	CNT_25F3E30C19V0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 7	[]	Dreamin' Sun Vol. 7	Shimana and the landlord finally kissed, and now she's even more in love than ever--or is she? The group decides to celebrate both Zen and Shimana's birthdays, but when Miura brings a surprise guest to the party, Shimana's love for the landlord is put to the test.	Love Trial	01KGA4TZV0RB871R6WVB1CNJ0J	7.0	2018-06-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 7	Ichigo Takano 2007	2018-07-31T07:00:00.000Z
PRD_0RKG67MP3X8G	CNT_3879NVKYW9N0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 9	[]	Dreamin' Sun Vol. 9	It's summertime and Shimana is determined to spend as much of it with the landlord as possible! But just as they are enjoying a nice day at the beach, Shimana learns that the landlord is being transferred to another city! Can she find a way to keep him close, or will it be their first and last summer together?	“Let's make some memories.”	01KGA5QVHKA27M83NZRWW30GM3	9.0	2019-05-31T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 9	Ichigo Takano 2007	2019-07-23T07:00:00.000Z
PRD_0XEWGERK6V7G	CNT_2K9AQP6ER7E0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 10	[]	Dreamin' Sun Vol. 10	Despite Shimana trying her hardest to keep the landlord by her side, Taiga is still moving to another city for work. But before he goes, he makes sure to spend the day with Shimana...and promises that he will return. In the final volume of Dreamin' Sun, will Shimana finally see her dream come true and be reunited with the landlord?	Journeys end with lovers meeting	01KGA7FZXRNKTCC3ECCA0SKHJA	10.0	2019-09-02T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 10	Ichigo Takano 2007	2019-10-29T07:00:00.000Z
PRD_1VJTD5GC5AH0	CNT_2Z82EECMN3C0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 3	[]	Dreamin' Sun Vol. 3	When Shimana runs off into a rainstorm, the last person she expects comes to her rescue: Zen! When he gets a fever the next day, Shimana feels responsible and offers to nurse him ?back to health. While caring for him, she learns that he's been hiding something from her - but that's not the only surprise he has in store for her. Zen's got a confession to make and it's getting harder and harder for him to keep it under wraps.	You Are My Sunshine	01KG9ZC01MJ8YAP0GCD1M7ECHS	3.0	2017-08-24T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 3	(C) Ichigo Takano 2007	2017-09-19T04:00:00.000Z
PRD_3J08S6HSAAMG	CNT_224X70K2N5KG	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 6	[]	Dreamin' Sun Vol. 6	When the landlord reconnects with his old flame, Shimana's anxiety about their relationship skyrockets. It's not long before their relationship is on the line and she's thinking about moving out of the house. Is this the end for them?!	Love on the Line	01KGA3ADZPVQRGWXWN20EM91XH	6.0	2018-03-12T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 6	Ichigo Takano 2007	2018-04-03T07:00:00.000Z
PRD_3X8JM6926BX0	CNT_0HVDD0SKVY60	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 1	[]	Dreamin' Sun Vol. 1	Shimana Kameko feels out of place in her own home. Her mother is dead and her father and step-mom only seem to care about Kameko's six-month-old baby brother. When Kameko decides to skip school and runs away to a nearby park, she stumbles upon a mysterious man in a kimono. The stranger, Fujiwara Taiga, offers Kameko a place to stay...on three conditions. The first condition is that Kameko must tell him why she ran away from home. The second is that she must retrieve his missing house key. The third condition is to have a dream and fall in love. Kameko's never been in love or had a dream of her own before, but to secure her own apartment, she's willing to try!		01KG98M0DQFDDAGQSXDE6SWA3J	1.0	2017-05-02T05:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 1	(C) Ichigo Takano 2007	2017-05-02T05:00:00.000Z
PRD_3YEPY5WDT210	CNT_1X6Z0SBJWBW0	Dreamin' Sun CNT_11Y6DQ2ZJGA0	CNT_11Y6DQ2ZJGA0	2	1	1	Volume 4	[]	Dreamin' Sun Vol. 4	Zen's finally confessed his feelings to Shimana! Unfortunately, while she wants to help him pursue his dreams, she doesn't feel the same way about him. Shimana's got her own unreturned feelings to deal with, because she's crushing on the landlord, who treats her just like a child. Determined to get closer, Shimana gets a hold of his high school yearbook--and makes some surprising discoveries.	Crushed!	01KG9VV1AH5SE9JP6BGJKG2XTG	4.0	2017-10-30T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Dreamin' Sun Vol. 4	(C) Ichigo Takano 2007	2017-11-07T08: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);