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

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	on_sale_at
PRD_0E4CPXXPSJ50	CNT_0E14VRFA0NE0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 3	[]	The Asterisk War, Vol. 3	The Festa begins! At long last, the largest fighting tournament in the world gets under way! Ayato and Julis blast through the tag team Phoenix event with their sights set on the semifinals, along with Saya and Kirin. But time is not on their side, as each passing match risks revealing Ayato's greatest weakness--the time limit on his power. And when he's facing opponents like Le Wolfe's Irene and Priscilla Urzaiz, he needs all the help he can get...	01KG9Z01AX94QTKFGYY6BM5JGG	3.0	2017-04-17T15:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 3	2017-04-17T15:00:00.000Z
PRD_17JS51DXAZYG	CNT_3JG6NP0081YG	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 17	[]	The Asterisk War, Vol. 17	The long battle comes to an end! As Julis faces off against Orphelia in the final Lindvolus match, Ayato takes on Madiath behind the scenes. The Golden Bough Alliance has been sowing the seeds of chaos in Asterisk, but Claudia and the others are hot on their trail. It’s time to decide the final victor—and when all is said and done, will Ayato be able to face his precious friends, including Julis? The heroes of Asterisk come together one last time in this final volume!	01KGB611Z524D3HHE2H6CF0WRD	17.0	2023-03-14T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Asterisk War, Vol. 17	2023-09-12T00:00:00.000Z
PRD_182YH8GHSNV0	CNT_3THXPHBP99Z0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 7	[]	The Asterisk War, Vol. 7	"Remember this, Ayato Amagiri. You will ask me for my help, sooner or later..."Hilda, the infamous Magnum Opus, contacts Ayato and asks for his help in exchange for treating his sister, Haruka. When he refuses, she gives him an ominous warning...Meanwhile, at Seidoukan Academy, our heroes begin training for the upcoming Gryps, and Claudia pulls back the curtain on the Pan-Dora and her own intentions. With the arrival of spring, Ayato and the others advance into their second year and start preparing for the school fair-when Sylvia calls Ayato to demand he make good on his promise and take her on a date...!	01KGA51QD7SWW8VDFDBAW4M6G2	7.0	2018-08-21T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 7	2018-08-21T07:00:00.000Z
PRD_1F7WD8P3AQ7G	CNT_2M5FKS1B5KE0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 10	[]	The Asterisk War, Vol. 10	After what happened with Claudia, Team Enfield is closer than ever, but what awaits them in the Gryps semifinals...?	01KGA73HZXHSBRH28EGN40G1GT	10.0	2019-06-18T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 10	2019-06-18T07:00:00.000Z
PRD_1JT8PC0ZHFHG	CNT_1PDHRHNVA6K0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 5	[]	The Asterisk War, Vol. 5	Not everyone in the Phoenix fights fair... At long last, Ayato and Julis have reached the final matches of the Phoenix...but Flora Klemm has been kidnapped! Not only that, but Ayato can't use his greatest weapon-or her captors will do their worst. If he and Julis want to rescue their friend and win the tournament, they'll need their wits, allies, and more than a little good luck!	01KGA187XT2JBKQNFW47TCWT9Y	5.0	2017-12-19T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 5	2017-12-19T08:00:00.000Z
PRD_1Y92GT4R13RG	CNT_0N41HH8FNWNG	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 4	[]	The Asterisk War, Vol. 4	Ayato and Julis have made it to the final rounds of the Phoenix, but now that Ayato's greatest weakness is public knowledge, they'll need some clever strategies to stay on top. Unfortunately, that's when Ayato makes contact with Le Wolfe's Tyrant, Dirk Eberwein, and learns more about his missing sister, Haruka. With newfound doubts and old insecurities clouding his mind and heart, will Ayato be ready for the next match? Or is his winning streak about to come to an end...?	01KG9ZA2AFG8X97EXSV24SBYYZ	4.0	2017-08-21T15:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 4	2017-08-21T15:00:00.000Z
PRD_23C5RD6Y20QG	CNT_0AQETN9MN4KG	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 8	[]	The Asterisk War, Vol. 8	After the school fair ends and summer begins, Team Enfield starts special training to prepare for the five-against-five Gryps. Ayato and his friends are a favorite in the competition, but Galaxy is about to make its move...	01KGA5GZSXD7KT32NGE5SR9C4P	8.0	2018-12-11T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 8	2018-12-11T08:00:00.000Z
PRD_258EJKX6VBZ0	CNT_3RPDD5JMFF90	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 15	[]	The Asterisk War, Vol. 15	Who will be the four strongest fighters in all of Asterisk?<BR />The Lindvolus is reaching its climax, and Round Six is here. Julis has already advanced to the semifinals, but there are still three matches to decide the remaining semifinalists: Ayato vs Fuyuka, Saya vs Lenaty, and Sylvia vs Orphelia. Even if Ayato wins his match, though, he’ll still have to compete against his trusted partner for a shot at the ultimate prize. Meanwhile, Elliot and Noelle of St. Gallardworth Academy say they’ve been asked to help Haruka…but why?	01KG9DM4D6BRQB7AKDAFZYAXEF	15.0	2020-12-16T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1G5EK0KH20W0	The Asterisk War, Vol. 15	2021-01-19T00:00:00.000Z
PRD_25QD8C2DNPB0	CNT_3B4K93H4Z81G	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 13	[]	The Asterisk War, Vol. 13	The greatest Festa in history begins!One year has passed since the fierce battles of the Gryps tournament, and now all the schools are preparing for the decisive moment of the Lindvolus, the Festa of Festas. Ayato is taking part to save Haruka’s life; all his training has led up to this. Meanwhile, his previous partner, Julis, has her own reasons why losing is not an option. The two parted ways when Julis decided training together would be unwise, and their relationship hasn’t yet recovered. With such a strong field of competitors, Madiath Mesa declares this will be the greatest Lindvolus in history…!	01KGA91YZ1AC9068VXCYK7A10J	13.0	2020-04-22T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 13	2020-05-26T07:00:00.000Z
PRD_28CDCXNC2PQG	CNT_1VEZJ28HSHNG	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 16	[]	The Asterisk War, Vol. 16	The finals are almost here!<BR /><BR /> Julis advances to the finals of the Lind-volus, and there is still one match left to determine her opponent: Saya vs. Orphelia. Before it can even begin, Saya approaches Orphelia with a surprising request—rather than fighting, Saya wants to talk instead. What could she possibly want to discuss? Meanwhile, behind the scenes, Ayato and his friends become more entangled with the Golden Bough Alliance, and the two groups may finally face their last battle…	01KGB2C2Y6S3TVVERJRYDKNRWJ	16.0	2022-11-01T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	The Asterisk War, Vol. 16	2022-11-22T00:00:00.000Z
PRD_2CDQF6CM7JMG	CNT_11PVB1AE94ZG	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 2	[]	The Asterisk War, Vol. 2	Having formed their tag-team partnership, Ayato and Julis begin polishing their skills and their teamwork in preparation for the Festa. But soon Ayato meets another girl--Kirin Toudou. She has long, silver hair and a petite charm--and despite her thirteen years of age, she's one of the strongest fighters of Seidoukan Academy. She seems to like Ayato, but that's not going to stop her from challenging him to a duel...	01KG9Z00KV0569YGFACW61V14P	2.0	2017-04-10T15:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 2	2017-04-10T15:00:00.000Z
PRD_2MZ4PG4CDYTG	CNT_0GENGBDB09V0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 9	[]	The Asterisk War, Vol. 9	"You probably don't know...just how long I've been waiting for this..."The Lindvolus has reached its conclusion, and Team Enfield would be ready to prepare for future battles if they weren't missing a crucial member-Claudia! With confidential information about the integrated enterprise foundation Galaxy, she's become a target for their troops, and when Ayato desperately searches for her, his roommate, Eishirou Yabuki, stands in his way. Claudia's Orga Lux, Pan-Dora, has allowed her to foresee this turn of events, but Ayato has to find her before it's too late...The day of destiny has arrived!	01KGA6JS744XBEHZ4NGSEEFN8T	9.0	2019-03-19T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 9	2019-03-19T07:00:00.000Z
PRD_3F8BG707G3YG	CNT_3X0N3CM884X0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 12	[]	The Asterisk War, Vol. 12	Family matters aren't so simple.After confronting his father about Haruka, Ayato decides to visit Magnum Opus’s lab to awaken his sister from the deep slumber she has been trapped in for several years. But the happy reunion lasts only so long, as Haruka tells Ayato of her past and her connection to Lamina Mortis. Meanwhile, realizing Haruka has been resurrected, the Golden Bough Alliance moves forward with their plan in the shadows...But first, Ayato will have to deal with Madiath’s threats on both his life and Haruka’s!	01KGA7V8RPVV4W837T6EB18FMC	12.0	2020-01-09T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 12	2020-01-21T08:00:00.000Z
PRD_3HTXCFM5DFPG	CNT_2V30D5G9RKX0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 14	[]	The Asterisk War, Vol. 14	The best of the best are in one place!At long last, the main battles of the Lindvolus have begun! Sixteen formidable fighters are set to vie for the glory of the championship, and there’s plenty of competition. In the Lindvolus’s fifth round, Ayato will have to face Le Wolfe Black Institute’s number two, while Ayato’s friends and previous teammates Julis and Saya have their work cut out for them. This tournament has everyone buzzing, and the stakes are high—can Ayato take home the crown? And will his friends find what they’re seeking at the Lindvolus…?	01KG9D6GAZKMQ27QN3C7SV7ST4	14.0	2020-09-18T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 14	2020-11-24T08:00:00.000Z
PRD_3KTG14YQAZC0	CNT_2FKAZFDG0BB0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 6	[]	The Asterisk War, Vol. 6	Things are heating up in Liesentania!At long last, the Phoenix is over, and New Year's Eve approaches. For winter vacations, Julis invites Ayato to visit her home in Lieseltania. As the king throws lavish parades and parties in their honor, Ayato comes to understand Julis's concerns for her country. To make matters worse, the king insists that Ayato and Julis marry each other! After the ruckus at their welcome party, another visitor makes her appearance--the Witch of Solitary Venom. She sets her sights on the pair, and Julis seems to know more than she's letting on...	01KGA3CT1JRPG5DEXMP7SH42CC	6.0	2018-04-24T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 6	2018-04-24T07:00:00.000Z
PRD_3MRQH9Q9PQVG	CNT_2VCE8J19XJT0	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 11	[]	The Asterisk War, Vol. 11	Team Enfield may have won, but that doesn’t mean they have all the answers…Despite some injuries suffered in the semifinals, Ayato and his friends emerge as the winners of the Gryps tournament. With the conclusion of the competition, Kirin’s father is released, and after his safe return, he wishes to thank Team Enfield personally. However, each member of the team must fight their own battles. Julis, Saya, and Claudia all have personal matters to attend to, which leaves Ayato alone to meet the Toudou family. But first, Ayato takes Kirin to his home, where the two of them realize they have a lot to learn about each other—and themselves.	01KGA7GD64R9VD8B1BEAPXW7D2	11.0	2019-09-02T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 11	2019-10-15T07:00:00.000Z
PRD_3TKBQ24ZY77G	CNT_0NQNAWMNJTCG	The Asterisk War CNT_14HYE2F2X8J0	CNT_14HYE2F2X8J0	2	2	1	Volume 1	[]	The Asterisk War, Vol. 1	The school-city of Rokka-also known as "Asterisk." Here boys and girls of the Starpulse Generation all compete in the Seibusai-the "star battle festival," fighting for glory on the greatest combat entertainment stage of the world. Ayato Amagiri has just arrived at one of these academies at the express invitation of its student council president, but when he begins his career by making a dangerous enemy, his life on Asterisk is off to a rough start!	01KG98KNESWC6RDJRQ2CPYM329	1.0	2017-03-02T15:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Asterisk War, Vol. 1	2017-03-02T15: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);