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

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_00WBZMQK28CG	CNT_11KKTPB3YMH0	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 2	[]	The Tale of Genji: Dreams at Dawn 2	His loves are countless, but the love Prince Genji seeks is never there. Genji betrays his father and the result of his affair with with Fujitsubo is the conception of their child. Then, his own wife becomes pregnant. Genji sees this coming child as a saving grace, but when one of his lovers finds out, she brings torment to his wife ...	01KGA6J3ZRXVHBYA6F8YMVF5HE	2.0	2019-02-25T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 2	(C) Waki Yamato / Kodansha Ltd.	2019-02-28T08:00:00.000Z
PRD_0BQS8B0DADNG	CNT_1EB67FMD7RR0	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 7	[]	The Tale of Genji: Dreams at Dawn 7	“So this is his recompense for having betrayed his father when he was young...the infidelity of his new wife, and her pregnancy. The marriage between Prince Genji and the Third Princess was nothing more than a formality, and knowing nothing of the joy of love, she began an illicit affair with a certain young man. But the price to pay for their affair was too great for this young man and woman... Read this manga to have a good understanding of The Tale of Genji!”	01KGA7FABCQPPA78P6SV547ZWY	7.0	2019-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 7	(C) Waki Yamato / Kodansha Ltd.	2019-09-03T07:00:00.000Z
PRD_15TTRZ0D2ZS0	CNT_2YYK84F7PV5G	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 4	[]	The Tale of Genji: Dreams at Dawn 4	Prince Genji mourns a lost lover, while unbeknownst to him, his dear wife's heart is in disarray. Having overcome the punishment for his affair, Genji returns to the political sphere. As he spends his time intimately with his beloved wife Murasaki, he thinks back on a woman he loved when he was young, as well as the lover and child he left in Akashi. Meanwhile, the time for his separation with his eternal love comes ever closer...	01KGA76HHEKD6QMN6A468SVBQQ	4.0	2019-05-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 4	(C) Waki Yamato / Kodansha Ltd.	2019-06-04T07:00:00.000Z
PRD_19CZAC1CJD40	CNT_1T5ABFMKX9AG	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 6	[]	The Tale of Genji: Dreams at Dawn 6	Genji has reached the heights of worldly glory, but a new young wife begins to drive his life out of order. Living in an estate with his many wives, Genji wields the highest power in the country, but even so he still continues to search for his ideal woman--so he welcomes a young princess as his wife. Did he truly want this woman so badly, he would even hurt his most beloved Lady Murasaki to have her? Read this manga to have a good understanding of The Tale of Genji!	01KGA7D8E7TKS6EK8W6E2KEEQE	6.0	2019-07-24T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 6	(C) Waki Yamato / Kodansha Ltd.	2019-08-06T07:00:00.000Z
PRD_1C9Z2P4W45WG	CNT_259GV2YD66Z0	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 9	[]	The Tale of Genji: Dreams at Dawn 9	""The descendants of Genji and the sisters from Uji—in the tangle of feelings between these four, love brings about discord. Kaoru, who was raised as the son of the Shining Prince Genji, meets two beautiful sisters in Uji. He falls for the elder, Oigimi, but she means to sacrifice herself for her sister's happiness, and tries to have Kaoru marry her, instead. But then in secret, Prince Nio goes to visit the younger sister... Read this manga to have a good understanding of The Tale of Genji!""	01KGA7RC1PH0YYNSAVAVTR1Q9H	9.0	2019-11-19T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 9	Waki Yamato / Kodansha Ltd.	2019-12-03T08:00:00.000Z
PRD_1W83WEM991ZG	CNT_3TF6R3RRR2W0	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 10	[]	The Tale of Genji: Dreams at Dawn 10	The concluding volume! Despite Kaoru's love, she longs for Prince Nio—even though he's her sister's husband. The sisters of Uji, who so captivated Kaoru and Prince Nio, had yet another younger sister, Ukifune. Kaoru showers her with affection in place of his dead lover, but after just one brief encounter with Prince Nio, her heart is stirred by that moment of passion, leaving her intensely shaken ...	01KGA8GCEHXXDJ9F466Y4C6F9E	10.0	2020-01-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 10	Waki Yamato / Kodansha Ltd.	2020-02-04T08:00:00.000Z
PRD_215KGX6G08W0	CNT_219AAZ68742G	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 1	[]	The Tale of Genji: Dreams at Dawn 1	First published in the 1980s and 90s, Waki Yamato's renowned adaptation of Murasaki Shikibu's 11th-century literary masterpiece is still gorgeous to behold and is considered one of the greatest novel-to-manga adaptations of all time. Prince Genji falls in love with his stepmother, and so begins a forbidden love that will make him suffer his whole life. Genji's love story involves him falling for many women and begins with his love for Princess Fujitsubo--his father's wife, and his stepmother. And Genji will cross that line which he should never cross.	01KG9B2ZESJZ6C6AYWGR7VX0HH	1.0	2019-02-25T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 1	(C) Waki Yamato / Kodansha Ltd.	2019-02-28T08:00:00.000Z
PRD_22Q35A5E49X0	CNT_01YXBDHZR51G	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 3	[]	The Tale of Genji: Dreams at Dawn 3	One of Prince Genji's lovers is the daughter of his political rival as well as the consort of Genji's own brother. Dangerous love sometimes brings tragedy. Though Genji has now married Lady Murasaki, who's grown up to look just like Princess Fujitsubo, his search for the ideal woman continues. He continues to see Oborozukiyo, his brother's wife, in an ongoing affair, but eventually, they're discovered. Suspected of plotting treachery, Genji is ousted from the political world ...	01KGA6J4M6102KX1XDS91AGPFV	3.0	2019-02-25T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 3	(C) Waki Yamato / Kodansha Ltd.	2019-02-28T08:00:00.000Z
PRD_36GF4JCCGBHG	CNT_1AKZAGGXDPW0	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 8	[]	The Tale of Genji: Dreams at Dawn 8	“Genji and Murasaki's eternal farewell... Was his most dearly beloved wife happy, at the end? In his final years, Genji showers his love on Murasaki alone and attempts to make their remaining years fulfilling. But now, his dearest one only wishes to be freed from love life. After a long illness, she leaves the world, and Genji, behind. Read this manga to have a good understanding of The Tale of Genji!”	01KGA7KK6XQRS9DYDVZ0A2XZ33	8.0	2019-09-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 8	(C) Waki Yamato / Kodansha Ltd.	2019-10-01T07:00:00.000Z
PRD_3E3ZMRAVG7W0	CNT_2GBK39NAMK2G	The Tale of Genji: Dreams at Dawn CNT_2P27PX4JSD10	CNT_2P27PX4JSD10	2	1	1	Volume 5	[]	The Tale of Genji: Dreams at Dawn 5	Prince Genji adopts the daughter of his departed lover, but her beauty causes him to lose his good sense. His welcoming this girl, raising her to be a lady and arranging the best marriage for her was supposed to have been done out of parental affection. But heart swept away by her charm, he crosses a line as her adoptive father...	01KGA7AJKTVWAXCH6BGS0CEA4N	5.0	2019-07-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Tale of Genji: Dreams at Dawn 5	(C) Waki Yamato / Kodansha Ltd.	2019-07-04T07: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);