database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_2C055JEWAWC0"

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_0RJ6GHMGZDY0	CNT_2NSHQTS3CZN0	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 4	[]	PPPPPP, Vol. 4	Lucky's trying to win against Mimin Otogami by gaining more experience, but when he arrives at the concert hall, he's surprised to see Sorachika! Meanwhile, Meloli wants to protect her world, but to do so, she must...	01KGBH45RZ283MJ1JN10D27CWG	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 4	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_0Z0H24PTVCX0	CNT_0N4EQ4FBVYP0	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 2	[]	PPPPPP, Vol. 2	Lucky takes part in a music audition put on by Wao Niiza. At the venue, he performs "Ode to Joy" for his classmate Rokku Maki, hoping that his music will grant Rokku's wish. But Lucky is also competing against his brother Reijiro, whose titanic sounds will prove quite the challenge to beat!	01KGBH43E0CTRZH92ZPG06K5ZN	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 2	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1MYDW971ZN60	CNT_38D9G476MQX0	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 6	[]	PPPPPP, Vol. 6	The four-on-four piano battle begins with Reijiro's victory! Things take a turn for the worse in the next round for Lucky's team, however, as Meloli comes up with a devious plan to make Mimin hate the piano. Can Mimin overcome her confusion and make a comeback?!	01KGBH3NPADFZ1N5BVJ8NCMV31	6.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 6	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1ZYKHFV2H56G	CNT_1ZH2V6HVZQXG	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 3	[]	PPPPPP, Vol. 3	Mimin plans to dominate every competition in Japan so that no one can ever again tell her how she should play the piano. But Lucky and friends are determined to stop her, so they go on a retreat to strategize. Their plans go awry, however, when Mimin unexpectedly shows up!	01KGBH4K71GMT804J5SBCAHZ8N	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 3	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2QMECM89NEFG	CNT_3JTE469PRH4G	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 7	[]	PPPPPP, Vol. 7	The four-on-four piano battle begins with Reijiro's victory! Things take a turn for the worse in the next round for Lucky's team, however, as Meloli comes up with a devious plan to make Mimin hate the piano. Can Mimin overcome her confusion and make a comeback?!	01KGBH478KC83VAES01FSXAFZH	7.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 7	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2TAYY75KHDEG	CNT_1J4V7HZZ7G5G	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 5	[]	PPPPPP, Vol. 5	Lucky's trying to win against Mimin Otogami by gaining more experience, but when he arrives at the concert hall, he's surprised to see Sorachika! Meanwhile, Meloli wants to protect her world, but to do so, she must...	01KGBH469P0BR30PA52XFWAR9C	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 5	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2X9SVD1ZSBCG	CNT_1MS57DAG0E7G	PPPPPP CNT_2C055JEWAWC0	CNT_2C055JEWAWC0	2	1	1	Volume 1	[]	PPPPPP, Vol. 1	With one exception, the septuplets of the Otagami family are considered genius pianists. As they grow up, the family separates, and only Lucky, the mediocre sibling, goes to live with his sickly mother rather than perform alongside their talented father. As time passes, Lucky promises his dying mother to become a pianist, but how will someone regarded for so long as talentless achieve success?	01KGBGJDQH0H8Q0DNAGR1GJPEN	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	PPPPPP, Vol. 1	PPPPPP © 2021 by Mapollo 3/SHUEISHA Inc.	2024-11-26T08: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);