database: products: 14 rows where series_id = "CNT

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

14 rows where series_id = "CNT_00QMZE2BHH9G"

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_0MY7S9BR514G	CNT_2EP71HEMTD3G	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 9	[]	Kasane Volume 9	With the power of a lipstick that steals faces and the help of her beautiful younger sister, Nogiku, Kasane stars in a stage production of Macbeth, just like her mother once did. As she immerses herself in the role, Kasane is forced to confront the sins she's committed, but Nogiku's supportive words help her recover. But Nogiku resents Kasane, and that support was only her laying the groundwork to bring down the hammer of revenge upon Kasane right when her career is at its peak. In the end, whose head will the blessed lights shine down on?		01KGA2DYJAHKNCCWC1QJ50T3SB	9.0	2017-12-25T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 9	(C) Daruma Matsuura / Kodansha Ltd.	2018-01-16T08:00:00.000Z
PRD_0WY10GD6D180	CNT_13A483G8ZPA0	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 13	[]	Kasane Volume 13	Kasane's lipstick can steal faces--but she's declared that Lady of the Dawn, written and directed by Habuta, will be the last play she ever stars in, and the last she ever uses the lipstick. Unable to understand why she's doing this, Habuta looks into what she might really want. Reading Nagi Kaidou's notebook, which was in Nogiku's posession, he learns the secret of the permanent exchange. Beyond the tangled morass of all their various motives, the truth finally comes to light.		01KGA52S6M08KHEEPK0QNPKQP9	13.0	2018-08-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 13	(C) Daruma Matsuura / Kodansha Ltd.	2018-08-18T07:00:00.000Z
PRD_0YBDSNNFHC5G	CNT_1KAJAWN06NRG	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 4	[]	Kasane Volume 4	Ugly Kasane's mother left her a lipstick with the power to steal faces, and Kasane has made up her mind to use this power to steal everything the beautiful have. She meets the gorgeous Neena Tanzawa, pushes her to madness and finally succeeds in stealing her face. Now with true beauty in her grasp, Kasane gains fame in the world of theater. But unbeknownst to her, new disaster looms...		01KG9Z6P9FV8688YYRDDFCVKM7	4.0	2017-07-10T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 4	Daruma Matsuura / Kodansha Ltd.	2017-08-01T04:00:00.000Z
PRD_187FDNH5CJD0	CNT_1S2YG961QEA0	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 11	[]	Kasane Volume 11	With the power of a lipstick that steals faces and her beautiful sister Nogiku's face, Kasane shines brilliantly in the world of theater. Iku Igurashi, a girl whose face Kasane once stole in high school, shows up to share a role with Kasane in a double-cast production of A Stardrop. Where will this coincidence, this trick of fate, lead Kasane? Then during the final rehearsal, the day before the show and in the middle of her best performance yet, Kasane sees something...		01KGA3A6TZBEZE64AD3ZYCZAWY	11.0	2018-03-12T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 11	(C) Daruma Matsuura / Kodansha Ltd.	2018-03-20T07:00:00.000Z
PRD_1NQ5G6ZGJFXG	CNT_0T9XCB7STATG	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 10	[]	Kasane Volume 10	With the power of a lipstick that steals faces and her beautiful sister Nogiku's face, Kasane rules the world of theater. Now that Kasane has surpassed her mother and is blessed with the light, there is no longer anything to block her path. This is when Habuta tells her about the tragic fate of Kasane's mother, Izana, and Sukeyo Fuchi, the beautiful women whose face Izana stole. With the past revealed to Kasane, finally, things come to converge in the present...		01KGA3000BJMT4HARJM5TY38NT	10.0	2018-02-12T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 10	(C) Daruma Matsuura / Kodansha Ltd.	2018-02-20T08:00:00.000Z
PRD_1PZJ0M9H1PE0	CNT_3FCDSR22A070	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 7	[]	Kasane Volume 7	Kasane is ugly. But her mother left her a tube of lipstick with the power to steal faces, and Kasane makes the decision to use this power to rob the beautiful of everything they have. When Kasane encounters the gorgeous Neena Tanzawa, she steals Neena's face and uses her good looks to become a success in the world of theater. But when Kasane's half-sister Nogiku shows up, everything changes. Kasane, Neena, Nogiku: beauty has made sport of each of their fates, leading them to one tragic conclusion...		01KG9VW4PCJ33GS1JBA2409BAY	7.0	2017-11-13T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 7	(C) Daruma Matsuura / Kodansha Ltd.	2017-11-21T08:00:00.000Z
PRD_25SP7Q20BTDG	CNT_31VPFGQ1740G	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 6	[]	Kasane Volume 6	Kasane is ugly. But her deceased mother has left her a tube of lipstick with the power to steal faces. Kasane makes the decision to use this power to rob the beautiful of everything they have. When she encounters the gorgeous Neena Tanzawa, she drives the other woman to the edge to steal her face and identity, and uses Neena's good looks to become a star on the stage. But when Kasane's half-sister Nogiku shows up, everything changes. Will Nogiku bring Kasane hope...or disaster?		01KG9VQACABZP0B5ZPZX5SYMH9	6.0	2017-09-18T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 6	Daruma Matsuura / Kodansha Ltd.	2017-10-17T04:00:00.000Z
PRD_27QQF43S7AV0	CNT_2NMK52WN93A0	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 3	[]	Kasane Volume 3	Using a mysterious lipstick with the power to steal faces and the cooperation of the gorgeous Neena Tanzawa, ugly Kasane comes to stand beneath the dazzling spotlight. Kasane walks down the path of the actress, just as her mother once did. But this choice brings fresh disaster...		01KG9Z6K8YWMDV7QJM5GV47BSK	3.0	2017-07-03T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 3	Daruma Matsuura / Kodansha Ltd.	2017-07-18T04:00:00.000Z
PRD_2ANAH02XHBFG	CNT_148F8RKNY0BG	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 12	[]	Kasane Volume 12	With the power of a lipstick that steals faces and her beautiful sister Nogiku's face, Kasane shines brilliantly in the world of theater. But then Iku Igurashi, the girl whose face Kasane once stole in high school, helps Nogiku escape, and Kasane disappears. Now, Kasane returns to see Habuta, Nogiku and Iku, offering Nogiku the lipstick that is essentially her life. Each of these four actors shoulders their own unique destinies as they begin to move forward. But where will their paths lead?		01KGA4JAKJW3ZABE78PTWA1RWC	12.0	2018-05-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 12	(C) Daruma Matsuura / Kodansha Ltd.	2018-05-29T07:00:00.000Z
PRD_2RQ15DRNEECG	CNT_1N7SQBDV06G0	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 8	[]	Kasane Volume 8	A lipstick with the power to steal faces. With that power and the cooperation of her beautiful younger sister Nogiku, Kasane is ready to stand at the heights as an actress, just as she always dreamed she would. But behind the scenes, Nogiku is plotting her downfall. Kasane is the daughter of the woman who made Nogiku's own mother miserable, and this fact makes Nogikus heart burn with the dark desire for revenge. In the end, will Kasane surpass her mother and grab hold of the dazzling lights, or will she fall into the abyss? The curtain rises on the final show...		01KGA18DNA2WSDWV6M2CENKD1K	8.0	2017-12-05T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 8	(C) Daruma Matsuura / Kodansha Ltd.	2017-12-19T08:00:00.000Z
PRD_2WBTYPV86W7G	CNT_1Y9XAS671H3G	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 14	[]	Kasane Volume 14	Kasane's face-stealing lipstick was what enabled her to shine on stage--but she threw that power away, and now she tells Habuta she wants to be on stage with her real face. Habuta laughed that proposal down before, but after reading Izana's letters and learning of her feelings for him, he decides to star the real Kasane in a production. Lady of the Dawn starts up again--but what performance will Kasane give on stage? The shocking final volume of Kasane ...?the story of a woman whose life was at the mercy of beauty and ugliness.	Final volume!	01KGA5JTZBWG6RN56EGJ1RS5PJ	14.0	2019-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 14	(C) Daruma Matsuura / Kodansha Ltd.	2019-01-08T08:00:00.000Z
PRD_2WGNJY4CZCN0	CNT_2K08T5G4F580	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 2	[]	Kasane Volume 2	Ugly Kasane's mother left to her a tube of lipstick that hides a secret -- it gives her the power to steal faces. Kasane has made up her mind to use this power to steal everything the beautiful.Then she meets the unbelievably gorgeous Neena Tanzawa...		01KG9Z6NVV2YCJTMB3EJ64F0DT	2.0	2017-06-27T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 2	Daruma Matsuura / Kodansha Ltd.	2017-07-04T04:00:00.000Z
PRD_34YY64P6TGT0	CNT_2KAC08X8DSB0	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 5	[]	Kasane Volume 5	Using the power of a mysterious lipstick that can steal faces, Kasane acquires the face of a beautiful woman named Neena Tanzawa. Freed from her former ugliness, Kasane uses Neena's beauty and her own natural talent as a actress to stand under the shining spotlights on stage. But when she encounters her blood sister, Nogiku, everything changes...		01KG9VNABQ8NGT37GVZGGBNW6E	5.0	2017-09-11T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 5	Daruma Matsuura / Kodansha Ltd.	2017-09-19T04:00:00.000Z
PRD_3MZ7M8YMCB9G	CNT_3QV7ZMK8ZN4G	Kasane CNT_00QMZE2BHH9G	CNT_00QMZE2BHH9G	2	1	1	Volume 1	[]	Kasane Volume 1	Kasane's face is so hideous, you couldn't bear to look twice at her, and her ugliness has forced her to walk a harsh path in life. But her mother left her something--a tube of lipstick. The power of this lipstick will change everything about her downtrodden life.		01KG98NN9N5DC1E9P5EAAGZV1E	1.0	2017-05-22T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Kasane Volume 1	(C) Daruma Matsuura / Kodansha Ltd.	2017-05-30T05: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);