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

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_00SXJHC7F1ZG	CNT_0JEN7TFWXM4G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 9	[]	Your Lie in April 9	COMBINED FORCES ""Want to commit double suicide with me?"" Kaori’s words echo in Kosei’s mind. What can he do for her now, while she is still hospitalized? At the Aiza home, Nagi sees her brother Takeshi fall deeper and deeper into a slump and wonders how to cheer him up. Amid their worries, the teacher and student form a surprise duo for Kurumigaoka Middle School’s festival. What will happen with two pianists on one piano?!	01KG992M46CMF31JC7ESJHR4B9	9.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 9	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_07ECW4E9B0YG	CNT_2NS274458K5G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 7	[]	Your Lie in April 7	MOVING ON With Kaori nowhere to be seen at the gala concert, Kosei is forced to perform alone. As he plays, he confronts painful memories and finds a link connecting him t the audience, his late mother, and even himself. Meanwhile, Tsubaki struggles to find truth within her complicated feelings for Kosei?is he like a little brother to her, a childhood friend, or something more…?	01KG992K41BA2T7VXJH42KY122	7.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 7	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0BWZFQBKQFXG	CNT_0N3Z6QTDQJ6G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 5	[]	Your Lie in April 5	The music competition is in full swing, with both of Kosei’s old rivals ? the genius Takeshi Aiza and unstable prodigy Emi Igawa ? energized by his return. When it’s finally Kosei’s turn, he lives up to his reputation, playing precisely and flawlessly ? at first. But before too long, the phantom of his mother reappears, casting him back into the dark, uncertain abyss. Can Kosei feel his way back to hearing the music again?	01KG992HNAQ52S7A56JPW84K94	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 5	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0D3Y4X7ZZD3G	CNT_0QRS1K6YHG0G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 1	[]	Your Lie in April 1	A LIFE IN MONOTONE Kosei Arima was a piano prodigy until his cruel taskmaster of a mother died suddenly, changing his life forever. Driven by his pain to abandon piano, Kosei now lives in a monotonous, colorless world. Having resigned himself to a bland life, he is surprised when he meets Kaori Miyazono, a violinist with an unorthodox style. Can she bring Kosei back to music, and back to life? Praise for the hit anime ""Your Lie in April is about two things: loss and love... A sight to behold."" -Kotaku ""A happy melody... about the power of music to inspire, to energize, to bring sunshine back into a life that's lost it."" - Anime News Network	01KG936GGCSC67016MVF8HZH2F	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 1	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0EDFSA5NKEWG	CNT_2MEC61GP2H7G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 3	[]	Your Lie in April 3	SCARS AND EGG SANDWICHES Kosei's return to the stage as Kaori's accompanist was a complete disaster. He couldn't hear the music, he lost track of the tempo, and they stopped and restarted the piece. But it did accomplish one thing: It reminded him of the thrill of playing for an eager audience. Now Kaori's demanding Kosei enter a piano competition solo, but he's terrified that, alone on the bench, the ghost of his abusive mother will paralyze him yet again...	01KG992GMB3H7QBRTZ82Z6HPQN	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 3	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2114BVZ4D0F0	CNT_1J4BQ39123M0	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 8	[]	Your Lie in April 8	Kosei Arima was a piano prodigy until his cruel taskmaster of a mother died suddenly, changing his life forever. Driven by his pain to abandon piano, Kosei now lives in a monotonous, colorless world. Having resigned himself to a bland life, he is surprised when he meets Kaori Miyazono, a violinist with an unorthodox style. Can she bring Kosei back to music, and back to life?	01KG992KMJ3ZG9X1JWERMBFVXG	8.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 8	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_25QMNESE9FE0	CNT_3NERQEZ9H2N0	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 6	[]	Your Lie in April 6	GALA MODE Spirits are still high after the Maiho Music Competition when Kaori receives a letter in the mail: There’s going to be a gala concert to celebrate the winners, and even though Kaori and Kosei didn’t advance, they’re invited to perform! Confident they can leave a lasting impression, Kaori seizes the chance to order Kosei back onto the stage with her. The ultimate duo that moved an entire audience’s hearts will perform once more, and people are buzzing with anticipation. Yet Kosei seems listless and uninterested in the festivities. Can Kaori and Kosei get their act together in time?! SEE LESS	01KG992J583237TBAZHH7G4MN2	6.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 6	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_284701TGNED0	CNT_1MRNPRNHW1P0	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 4	[]	Your Lie in April 4	A LIFE IN MONOTONE Kosei Arima was a piano prodigy until his cruel taskmaster of a mother died suddenly, changing his life forever. Driven by his pain to abandon piano, Kosei now lives in a monotonous, colorless world. Having resigned himself to a bland life, he is surprised when he meets Kaori Miyazono, a violinist with an unorthodox style. Can she bring Kosei back to music, and back to life? Praise for the hit anime ""Your Lie in April is about two things: loss and love... A sight to behold."" -Kotaku ""A happy melody... about the power of music to inspire, to energize, to bring sunshine back into a life that's lost it."" - Anime News Network	01KG992H30PT70JZRAGBJWAW0V	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 4	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2BP8XZ8Z0MXG	CNT_16MT96QYD76G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 11	[]	Your Lie in April 11	THE LAST MOVEMENT Kaori undergoes surgery even as Kosei performs in his competition， each of them as vulnerable as ever， but finally embracing the courage to take these ultimate risks. As their journey together draws to a close， the music of their hearts lays bare the truth of their friendship?a friendship that may have begun with an April lie， but which has changed their lives and the lives of everyone around them. FINAL VOLUME!	01KG9YQ99V7APMMS22PC4WTX69	11.0	2016-12-05T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 11	(C) Naoshi Arakawa/ Kodansha Ltd.	2016-12-26T15:00:00.000Z
PRD_2CTQKMMTHDC0	CNT_3M32PABTB0Q0	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 2	[]	Your Lie in April 2	RONDO CAPRICCIOSO After the death of his mother, child prodigy Arima Kosei gave up the piano forever - or so he thought. That vow turned out to be no match for the persistence of sprightly violinist Kaori Miyazono, who's roped Arima back into the world of competitive classical music. But after so many years, will Arima be able to sit down at the ivories again like nothing happened? Or will history repeat itself, with Arima crumbling under the pressure?	01KG992G5DM54TX39MMBZY8R9C	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 2	(C) Naoshi Arakawa / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_3Z6KXKETNTAG	CNT_05M9TJX7XX9G	Your Lie in April CNT_29HZ5Q1CZHN0	CNT_29HZ5Q1CZHN0	2	1	1	Volume 10	[]	Your Lie in April 10	OUT OF THE COLD…? Kosei and Nagi’s duet has carried thoughts and feelings to the most precious people in the musicians’ lives. The words， ""please play with me again"" from Kosei give Kaori a small ray of hope. As Kosei competes to qualify for the Eastern Japan Piano Competition in December， Kaori begins her difficult rehabilitation. Each of them starts a challenging walk forward. Will the coming winter bring healing or hardship?	01KG9YN6RVJS0GGNB260NPZCDK	10.0	2016-10-20T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Your Lie in April 10	(C) Naoshi Arakawa/ Kodansha Ltd.	2016-11-04T15: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);