database: products: 17 rows where series_id = "CNT

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

17 rows where series_id = "CNT_16H26YC7BDYG"

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_0E9STRM70BA0	CNT_2S6YF70ED720	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Blue Period	[]	Blue Period	Yatora's back on campus for year two and suprises abound. He's greeted by an old friend and then gets bombarded with new friends, instructors, and assignments! But one day, when Yatora encounters an artists' commune, he begins to question if TUA is really the right place for him...	01KGB41WG6CY58QMPJR9Y0HDHB	12.0	2023-01-03T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period	Tsubasa Yamaguchi/Kodansha Ltd.	2023-01-24T08:00:00.000Z
PRD_0SSSHKQ0ZQGG	CNT_293JK9Y55V0G	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 2	[]	Blue Period 2	Art has changed the course of Yatora's once dull life, and now he's aiming for Japan's most competitive art school. With entrance exams a year away, he'll need to expand his limited eye for art, and quickly. He turns to new peers and the masters to envision pieces only he can produce, and soon dives into his first competition–the same one where his Art Club role model nearly scored last place. Among geniuses and lifelong art kids, does Yatora even stand a chance...?	01KG9DHWMXWSGSWZ71Z8BP2FKW	2.0	2020-12-02T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 2	Blue Period Tsubasa Yamaguchi / Kodansha Ltd.	2021-01-05T08:00:00.000Z
PRD_0WE0NCZBESFG	CNT_2VNEGM05GRE0	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 17	[]	Blue Period 17	The final project for the second-year students was a "two-person show," where students chose an artist to create an exhibition with. Yatora eventually chose Andy Warhol as his partner and dove into Kabuki-cho nightlife for research. His host club billboard piece was well-received, and his yearning to become an artist now grows even stronger...	01KH2X5YNA40KRWKK2AJ1NNMCD	17.0	2026-01-16T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 17	Tsubasa Yamaguchi/KODANSHA LTD.	2026-02-03T08:00:00.000Z
PRD_0XCX9WHVM4BG	CNT_3Z072AFQJ8M0	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 4	[]	Blue Period 4	Yatora now has new materials in his tool box and a wider range of expression under his belt. But a week before the first exam, Ooba-sensei says he's missing a crucial edge... With so much at stake, Yatora's self-doubt brings him lower than ever before. Still, he has his fire, his resilience—and he might just get a lucky break, too.	01KG9FRNHF7YY3E3JX4N5J4YJ4	4.0	2021-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 4	Blue Period Tsubasa Yamaguchi / Kodansha Ltd.	2021-08-17T07:00:00.000Z
PRD_0Y8TCMYEXK2G	CNT_2K0C89NEQ810	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 1	[]	Blue Period 1	Yatora is the perfect high school student, with good grades and lots of friends. It's an effortless performance, and, ultimately...a dull one. But he wanders into the art room one day, and a lone painting captures his eye, awakening him to a kind of beauty he never knew. Compelled and consumed, he dives in headfirst — and he's about to learn how savage and unforgiving art can be!	01KG9CCMDTR531PTHEXK9XFYNP	1.0	2020-09-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 1	Blue Period Tsubasa Yamaguchi / Kodansha Ltd.	2020-10-06T07:00:00.000Z
PRD_14FF2VWWRVAG	CNT_1RJSTEE78FN0	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 5	[]	Blue Period 5	SELF-PORTRAIT Yatora makes the best of a bad situation during TUA's first exam, and he must surpass these efforts for the second. But after all he's gone through, Yatora is feeling a little out of sorts. To get back on track, he'll have to step out of the studio and into new lighting... With the help of an old friend, Yatora bares his soul and some skin to take on his latest challenge: the nude self-portrait.	01KG9HBYB8SBPKN99Z87C7D71J	5.0	2021-10-27T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 5	Blue Period Tsubasa Yamaguchi/Kodansha Ltd.	2021-11-30T08:00:00.000Z
PRD_18SJMJDNK8E0	CNT_0RMQSTG4WBFG	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 9	[]	Blue Period 9	MOSAIC Summer whizzes by like a typhoon, and Yatora has learned that large-scale pieces—in production and concept—only come together with elbow grease and teamwork. TUA opens its gates once more for the second term and Yatora's back at it... But he hasn't picked up a brush in months!	01KGAJ4V42EK9QPB1TDWF2WC5Y	9.0	2022-06-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 9	Blue Period Tsubasa Yamaguchi/Kodansha Ltd.	2022-08-16T07:00:00.000Z
PRD_1FPMNY4V35VG	CNT_0GCFRYHNXV20	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 7	[]	Blue Period 7	FIRST TRY Tokyo University of the Arts is now Yatora's campus, where each new encounter with colleagues, professors, and assignments challenges everything he's ever known! Self-doubt and life's hardships still lurk around every corner, but running into an old friend may just turn things around.	01KGAF10ZEQK9H32RWRG3W4T5T	7.0	2022-05-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 7	Blue Period Tsubasa Yamaguchi/Kodansha Ltd.	2022-05-31T07:00:00.000Z
PRD_1X1N7PCV84M0	CNT_2T45SSYH4EAG	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 3	[]	Blue Period 3	Relief is short-lived for Yatora after his first competition, where his piece was higher ranked than he expected, but far from his dream school's standards. While he's prepared to give Ooba-sensei's challenges everything he's got...what if all he's got is still not enough? With 100 days until university exams, he must seize what's beyond—beyond his singular drive, learned technique, and hard work—to produce an answer only he can.	01KG9E0BE6RA239MDBTET224D7	3.0	2021-03-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 3	Blue Period Tsubasa Yamaguchi / Kodansha Ltd.	2021-04-27T07:00:00.000Z
PRD_28QZE13404D0	CNT_338TB2SPQQ8G	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 8	[]	Blue Period 8	CITYSCAPE After a disappointing first assignment, Yatora is encouraged by Maki and is determined to move forward. His next assignment is a scenery of Tokyo. As he takes on new materials and methods, he also becomes exposed to new ways of seeing the city he thought he knew so well. Can Yatora finally evolve beyond the "exam art" that got him into art school...?	01KGAGSTVBSKD8XNXKW3DP8D9Z	8.0	2022-06-09T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 8	Blue Period Tsubasa Yamaguchi/Kodansha Ltd.	2022-07-26T07:00:00.000Z
PRD_2G0DYVS77CMG	CNT_0YQTADT0ZVQ0	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 14	[]	Blue Period 14	For their second summer at TUA, Yatora and his art school friends stay at Momoyo's family temple. There, Yatora enters an art contest with hopes for the cash prize and a professional debut. However, as he works on his piece, he learns of Yakumo's friend Machiko-a remarkable young artist whose flame was extinguished too early.	01KGAY4WYC1PHVZ1GXMMQEHB8V	14.0	2024-03-05T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 14	Tsubasa Yamaguchi/Kodansha Ltd.	2024-03-26T07:00:00.000Z
PRD_2HSW5X0AJBF0	CNT_11M91RJ3ARZG	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 10	[]	Blue Period 10	ART-MAKING Yatora prepares for the first-year show, where he'll have to pass an open review from intimidating professors and celebrity guest lecturers. To make matters worse, the self-directed nature of the assignment is more stifling than freeing, and he's no longer sure: Does he even like art? Why did he ever start? An all-nighter in Shibuya may hold the answer, but Yatora's not with his usual boys...	01KGAJR7FGYH8C7BJ4EMWA0NC1	10.0	2022-10-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 10	Blue Period Tsubasa Yamaguchi/Kodansha Ltd.	2022-11-08T08:00:00.000Z
PRD_2YZA2PG7EY90	CNT_1S8CFRD7HJ30	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 15	[]	Blue Period 15	As they continue their stay in Hiroshima and work on their competition and exhibition pieces, Yatora and his classmates grapple with the legacy of Machiko Sanada's untimely death. While Yatora struggles in his mind and on the canvas, Yakumo and the others contend with the specter of the person who brought them together. However, through these challenges come surprising outcomes that set Yatora and Yakumo down paths of artistic and spiritual growth. New students no longer, they forge ahead on the journey toward adulthood.	01KGBBZ79CHWDQXZQGCYGRV3W1	15.0	2024-07-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 15	Tsubasa Yamaguchi/Kodansha Ltd.	2024-08-20T07:00:00.000Z
PRD_2ZMTE28JF44G	CNT_0VGQ1XC1ACQG	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 16	[]	Blue Period 16	Despite placing in his first-ever art competition with the work he completed in Hiroshima, Yatora continues to struggle with his skills and identity, even going so far as to question his future in the art world. This is only made worse by a new assignment where he must set up a show with an artist of his choice. However, never one to back down from a challenge, Yatora decides to prepare by working part-time in a seemingly foreign world where "drowning" may be just what he needs to succeed...	01KGC15Y7ZDETJGCBPM6Q77N5Y	16.0	2025-10-27T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 16	Tsubasa Yamaguchi/KODANSHA LTD.	2025-11-11T08:00:00.000Z
PRD_2ZRPPMN157JG	CNT_2W09H9WX6BHG	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 6	[]	Blue Period 6	SECOND EXAM A surprising setback before the second exam shakes Yatora up, but after everything he's been through, he must persevere. This time, the subject turns out to be something both new and familiar... But does an average guy like Yatora stand a chance against the geniuses and prodigies vying for a spot in the nation's most competitive art school?	01KGAENTEEG3XP50SBR1FVBBPD	6.0	2022-02-01T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 6	Blue Period Tsubasa Yamaguchi/Kodansha Ltd.	2022-02-15T08:00:00.000Z
PRD_35HK3YWF5HM0	CNT_3V96PJXKZKG0	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 13	[]	Blue Period 13	Thanks to the influence of the guru-like leader of NO MARKs, Yatora is ready to return to TUA with a fresh perspective and renewed love for art-until a series of jarring events makes Yatora question his recent choices. But as he considers what is right or wrong in his pursuit of art, he finds the inspiration to take a bold new approach to his assignment on "guilt."	01KGB6E045WB0EEFCRM9RJ6TXG	13.0	2023-05-09T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 13	Tsubasa Yamaguchi/Kodansha Ltd.	2023-05-30T07:00:00.000Z
PRD_3NM0QHR5RFJG	CNT_3VXVDSM6PTAG	Blue Period CNT_16H26YC7BDYG	CNT_16H26YC7BDYG	2	1	1	Volume 11	[]	Blue Period 11	CHILD'S PLAY Yatora's first year at TUA has left his soul and his bank account drained. To recover, he takes a part-time job at a community art class, working for none other than his former mentor, Saeki-sensei. However, teaching painting to young students is a creative challenge on its own!	01KGB2AKM18JQYEJGNM8Q0X1MA	11.0	2022-11-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Blue Period 11	Tsubasa Yamaguchi/Kodansha Ltd.	2022-11-22T08: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);