database: products: 19 rows where series_id = "CNT

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

19 rows where series_id = "CNT_3571EGTTE9H0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_082E3B385V20	CNT_2NEZWBE9MQCG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 10	[]	All-Rounder Meguru Volume 10	In his semifinal match against Mitsuya, Meguru's put through the wringer by the beastly former Olympic candidate. He's way behind in points, and things are looking grim, until a well-timed counter at the opportune juncture set's the stage for Meguru's dramatic comeback! Meanwhile, Muroi also manages to climb his way to the finals. However, at the heart of the old dog's thirst for victory lies a shocking tale of one man's struggle to become a strong father...		01KGA71YDYX1P36S5DZGVAK0JZ	10.0	2019-05-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 10	(C) Hiroki Endo / Kodansha Ltd.	2019-05-28T07:00:00.000Z
PRD_08EXB04MTT40	CNT_0S3NWTA6BKS0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 4	[]	All-Rounder Meguru Volume 4	With a spot in the All-Japan Amateur Shooto Championship on the line, the Kanto tournament is finally underway. Meguru, who's obtained power and confidence through training with the pros. Takashi, who's refined his striking technique and grown even more as a fighter. And Yudai, who's concealed his injured right elbow in order to compete. Who will be the one to win the right to move onto the championship?!		01KG9Z7BHEDJ99QECT022ZM6J3	4.0	2017-07-10T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 4	Hiroki Endo / Kodansha Ltd.	2017-07-25T04:00:00.000Z
PRD_0CJRPG49GHX0	CNT_0PCFZHQ0JTG0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 5	[]	All-Rounder Meguru Volume 5	It's the second round of the East-Japan Tourney. As Meguru continues to fight for dear life, battered but unbroken, Ogasawara's spirit is driven into a corner. Meanwhile, an unexpected encounter stirs up Yudai's troubled past while he awaits his semifinal match with the fearsome Takashi.		01KG9Z8TVVHS8C4288PACG740F	5.0	2017-07-24T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 5	Hiroki Endo / Kodansha Ltd.	2017-08-15T04:00:00.000Z
PRD_0D0QSJP35BCG	CNT_27X433B53EQG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 2	[]	All-Rounder Meguru Volume 2	After losing two matches in a row, high-schooler and budding Shooto fighter, Meguru Takayanagi, is plagued with frustration. In order to get stronger, he begins taking part in joint practice with the kickboxing class by the suggestion of striking instructor, Maria. There, he meets a 5'10"" high school girl kickboxer by the name of Maki Kamiya. Their encounter puts the pedal to the metal on this youthful Shooto drama!		01KG9YXXGRTM9RG070Q90JJDS5	2.0	2017-03-20T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 2	(C) Hiroki Endo / Kodansha Ltd.	2017-04-04T05:00:00.000Z
PRD_0EMPEENCX4Q0	CNT_0Z3VXRFRSFZG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 9	[]	All-Rounder Meguru Volume 9	This is Meguru's last chance to win a spot at the nationals. However, the competition in Kansai is just as fierce as Kanto. He'll have to overcome a veteran fighter's desperate last stand and a genius olympic wrestling contender if he hopes to take the top! Fighting tooth and nail each bout, Meguru's potential blooms on the mat!	The Kansai qualifier has has finally begun!	01KGA6HCGZE8Z4P8Q5ACHT2Y26	9.0	2019-02-19T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 9	(C) Hiroki Endo / Kodansha Ltd.	2019-02-26T08:00:00.000Z
PRD_0TNJ970TGKN0	CNT_13A611KY3QZG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 16	[]	All-Rounder Meguru 16	In a tournament dominated by men, two women duke it out with such unbridled aggression that it puts the boys to shame. When the bell rings, who will be the one to face Maki in the finals? And back in the men's block, Meguru comes up against Shu Katori, an elite all-rounder and the favorite to win. Armed with only a working plan and his intuition, how will Meguru make up for the difference in their skill? One thing's certain, this semifinal bout is sure to put all his skills to the test!		01KG9CZ5RCC4GJEBGSH9SYGQQ9	16.0	2020-08-11T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 16	Hiroki Endo / Kodansha Ltd.	2020-09-01T07:00:00.000Z
PRD_174BMPZR8ND0	CNT_13M7P6XCWAN0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 8	[]	All-Rounder Meguru Volume 8	Fighting off fierce competition and fatigue to make it to the Kanto BJJ Open Tournament finals, the only one standing between Momoko and the absolute division title is a fellow throw specialist who isn't about to make things easy for the tiny contender. Meanwhile, Meguru gets back to training for the amateur Shooto regional qualifiers. And amid the hustle and bustle, a certain development pushes Meguru and Maki closer together than ever before--the catalyst being...lunch, of all things?! Don't miss the latest issue of this teen drama fusing school, MMA, and a little romance.		01KGA5GHZTW8PYBAC1RADYXF91	8.0	2018-11-20T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 8	(C) Hiroki Endo / Kodansha Ltd.	2018-11-27T08:00:00.000Z
PRD_191M1F54QZ5G	CNT_21R0T5CK6KKG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 19	[]	All-Rounder Meguru 19	It's the All-Japan Amateur Shooto lightweight final. Meguru and Takashi are both battered, yet neither refuses to give an inch. With their friends, mentors, and rivals watching from the sidelines, who will come out on top? Having captured the hearts of fans and pros alike with realistic depictions of fighting across the board, it's time at last to close the curtain on this epic MMA saga.		01KG9ENJ4EMPE1P30T7F440651	19.0	2021-02-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 19	Hiroki Endo / Kodansha Ltd.	2021-03-02T08:00:00.000Z
PRD_1DYG8XVAV5P0	CNT_3EARQXDN77X0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 3	[]	All-Rounder Meguru Volume 3	After squeezing out a much yearned-for victory in his third amateur Shooter fight, Meguru sets his sights toward the Kanto championships for the right to move on to the All-Japan tournament! However, lacking both conditioning and power, Meguru aims to power up further by adding jiu-jitsu and pro training to the mix! Meanwhile, Meguru's old friend, Takashi, has a startling development in his life... The human drama celebrating the youthful struggles of Shooto fighters hits its third volume!		01KG9YYA0C3TKGWTEFSFHHQEC7	3.0	2017-03-27T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 3	(C) Hiroki Endo / Kodansha Ltd.	2017-05-02T05:00:00.000Z
PRD_1MWRJQDBTQM0	CNT_21M15SDTXBY0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 7	[]	All-Rounder Meguru Volume 7	Maki's long-awaited amateur kickboxing tournament has finally arrived, and she's fired up and ready to go. However, she's in for a surprise when a fighter from the Kansai region, Ayako, gives her a run for her money. Meanwhile, Yudai has yet to show up at the gym since his loss at the Kanto Regional Qualifying Tournament. In an attempt to cheer him up, his underclassman, Momoko, vows that she'll take home first place at an upcoming jiu-jitsu tourney. Let the battle of dainty high school girl fighters begin!		01KGA3J3ZXJB48C91JWWSVQ2JS	7.0	2018-08-02T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 7	(C) Hiroki Endo / Kodansha Ltd.	2018-08-07T07:00:00.000Z
PRD_2PS3MVHPV9K0	CNT_29TFX4BAHA9G	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 13	[]	All-Rounder Meguru 13	Studying, club activites, love ... Of all things for a high-school senior to devote their time and energy to, why would someone choose MMA? At long last, the reason Meguru keeps fighting is finally revealed! The Shooto nationals are here, home to the best of the best from around the country. There's no telling if Meguru will even make it through the first round, or in one piece, at that. But that won't keep him away from the ring. The fated bell has rung, and it's time to throw down!		01KGA8N799H1DC75N0GEQGAH5B	13.0	2020-02-18T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 13	Hiroki Endo / Kodansha Ltd.	2020-03-03T08:00:00.000Z
PRD_2ZY94YJ8MXQG	CNT_2DG0N989MEM0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 12	[]	All-Rounder Meguru Volume 12	After countless hours of sweating in the gym and many hard-won victories, at last, Meguru's earned himself a spot at the Shooto nationals. Having watched him grow day by day, Maki's developed a little crush for the airheaded all-rounder. Thankfully, an opportunity for the two to get cozier soon presents itself when the gang heads out on an inter-gym Tohoku volunteer tour filled with hot springs, partying, grappling, and everything else you could ever want in an MMA romantic comedy!		01KGA7TG482JZZG84QMQTMMG2V	12.0	2020-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 12	Hiroki Endo / Kodansha Ltd.	2020-01-10T08:00:00.000Z
PRD_34FYPE5EZ3JG	CNT_3G45BYZG7YK0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 11	[]	All-Rounder Meguru Volume 11	It's do or die as we reach the climax of the Kansai Qualifier final round! In a last-ditch effort to clinch a comeback KO victory, Muroi invites Meguru to join him in one last melee. With a huge point lead and only seconds left on the clock, how will Meguru respond to the old dog's challenge? Find out in the stunning conclusion to the Kansai tournament arc! Then, we jump back in time four years, to the winter Takashi's grandfather passed away, leaving him an orphan in the care of a children's home. And so, a piece of Meguru's childhood friend and rival's past is finally revealed.		01KGA7EJ5F8E0EYAHCQC1ZPHTG	11.0	2019-08-09T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 11	(C) Hiroki Endo / Kodansha Ltd.	2019-08-13T07:00:00.000Z
PRD_35BGWN5BQTX0	CNT_2V41SY73C5T0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 6	[]	All-Rounder Meguru Volume 6	It's time for the Kanto Amateur Tournament semifinals! Having whittled away his stamina in order to win his way this far, Meguru must now face off against the tournament favorite and highly skilled fighter, Takeshi Kagaya, in a match that is sure to be a grueling trial. The time has come for Meguru put everything he's practiced to the test!		01KGA1EAACX2WTVX4DGSZJ6BAX	6.0	2018-02-26T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 6	(C) Hiroki Endo / Kodansha Ltd.	2018-03-07T08:00:00.000Z
PRD_3NK07XWG3B70	CNT_2NT84BQHE0DG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 17	[]	All-Rounder Meguru 17	At long last, the All-Japan Amateur Shooto Championship is finally reaching its climax. While Meguru and Maki narrowly clinch out a spot in the finals, Takashi blows through the competition with yet another near-instant K.O., dealing a blow to Meguru's confidence in the process. And in a desperate effort to cheer him up, Maki pulls a stunt that surprises both of them! With a fistbump and a promise to bring the win home, the two return to the ring ready to take on the world. And now, let the finals begin!		01KG9DB7DQXKY3KE56BPCM6TDD	17.0	2020-10-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 17	Hiroki Endo / Kodansha Ltd.	2020-11-03T08:00:00.000Z
PRD_3NZGCK6X94RG	CNT_2H7P6A9S388G	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 18	[]	All-Rounder Meguru 18	The women's final between Maki and Aya reaches its stunning conclusion. And now, it's time for Meguru and Takashi to throw down for the first time since volume 1! Two childhood friends, having gone their separate ways, now meet in the MMA ring to do a little catching up...with their fists. The final round of the All-Japan Amateur Shooto Men's Lightweight division is about to begin!		01KG9DWYKNH4G66AEHESYDZFCS	18.0	2020-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 18	Hiroki Endo / Kodansha Ltd.	2021-01-05T08:00:00.000Z
PRD_3P2V4FANNR0G	CNT_2JDRAJYD7V3G	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 1	[]	All-Rounder Meguru Volume 1	High schooler and budding Shooto mixed martial arts fighter, Meguru Takayanagi, reunites with his old friend from grade school, Takashi Segawa, in the ring for the first time in seven years. However, while the two used to be good friends, due to the difference in their upbringings, Takashi now sees Meguru as an enemy. Without a moment of joy to commemorate their reunion, the old friends' match begins... Eden's own Hiroki Endo brings you a new tale of Shooto, MMA, and youth!		01KG98KPE8CE1QZ8NED72TCYB5	1.0	2017-02-27T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru Volume 1	(C) Hiroki Endo / Kodansha Ltd.	2017-03-06T15:00:00.000Z
PRD_3SPPXRD1K3F0	CNT_1JX75JY568NG	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 15	[]	All-Rounder Meguru 15	The All-Japan Amateur Shooto Champtionship, where the best budding fighters in the nation will be crowned king. Yet out of the near 100 participants in attendance, only four fierce ladies make up the women's bantamweight division: Maki Kamiya, Kaoru Nobeoka, Ayako Nagamine, and Erica Barboza Morita. In a world where most float through life avoiding conflict at all costs, how is it that so many people gather together for the sole purpose of knocking each other's lights out? Watch as these scrappy vixens tell the story of their lives and why they fight...through their fists.		01KG9CQF8RW6FHHQHK6AWW4Q1M	15.0	2020-06-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 15	Hiroki Endo / Kodansha Ltd.	2020-07-07T07:00:00.000Z
PRD_3XHBKKT7WEHG	CNT_2XYF2YCVBZA0	All-Rounder Meguru CNT_3571EGTTE9H0	CNT_3571EGTTE9H0	2	1	1	Volume 14	[]	All-Rounder Meguru 14	The All-Japan Amateur Shooto Championship, the pinnacle of budding MMA talent from around the nation. As Meguru, Takashi, and gobs of other gifted fighters gun for the top, one man, the self-proclaimed Masuoka the Mediocre, stands tall as a dwarf among giants. Sporting a second-rate style and only so-so skill, behold as the leglock lunatic puts his heart, soul, and entire fight ideology on the line to take Meguru down!		01KGA915BESQEX7CJEWCPKRVV4	14.0	2020-04-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	All-Rounder Meguru 14	Hiroki Endo / Kodansha Ltd.	2020-05-05T07: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);