database: products: 16 rows where series_id = "CNT

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

16 rows where series_id = "CNT_3ZEP4CZ1A99G"

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_15Z499575ARG	CNT_0FWPA6585VK0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 15	[]	Boarding School Juliet 15	Dahlia Academy's second-year class has arrived in the Principality of West for their class trip. From Hasuki getting lost to Inuzuka finding himself on a risky mission to sneak into the girls' bath, the trip is fraught with trouble from day one! But that's nothing in comparison to the hurdle that awaits Inuzuka on the final day of the trip, when he's booked to meet Persia's parents...	01KGA8V0K9C7276Y79WGYXQ9SD	15.0	2020-03-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet 15	Yousuke Kaneda/ Kodansha Lyd.	2020-03-24T07:00:00.000Z
PRD_1CE776R597BG	CNT_35VSB3PQEKCG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 1	[]	Boarding School Juliet Volume 1	At Dahlia Academy, a prestigious boarding school attended by students of two feuding countries--the eastern Nation of Touwa, and the Principality of West--Romio Inuzuka, leader of the dorms' Touwa first-years, wishes for a romance that can never be. For his ladylove is none other than his arch-enemy, Juliet Persia, leader of the dorms' West first-years! Is Inuzuka ready to risk it all to confess his feelings? And even if Persia somehow agrees to go out with them, how long can they keep a forbidden relationship under wraps?!	01KGA3MB6KNVK57JJP8J5A588Z	1.0	2018-04-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 1		2018-04-10T15:00:00.000Z
PRD_1HB8G5S3YATG	CNT_30AX1PN6CNV0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 12	[]	Boarding School Juliet Volume 12	After a river rescue gone awry, Inuzuka has lost his memories! The amnesiac Inuzuka is practically a different person, who proceeds to throw Dahlia Academy into confusion with a myriad of misunderstandings, like mistaking Hasuki for his girlfriend and Maru for his bestie. To get his memories back, mutual arch-enemies Persia and Hasuki will have to do the unthinkable--team up!! Can their love bring the real Inuzuka back in time for the upcoming prefect election?	01KGA7F6YPZGTX0Y951WC8E71Q	12.0	2019-08-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 12	(C) Yousuke Kaneda/ Kodansha Lyd.	2019-09-03T07:00:00.000Z
PRD_1P2W2ZS504K0	CNT_0CSRAY2E7RQ0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 3	[]	Boarding School Juliet Volume 3	Persia's been sabotaged by the scheming Aby and his underling Somali. Inuzuka is desperate to help her recover her reputation, but one wrong move and he stands to lose his own. Then, after the curtain falls on the sports festival, Inuzuka ends up in a series of unpredictable situations--including drawing the attention of the prefects, the school's most powerful students. It seems that the more Inuzuka and Persia's relationship deepens, the harder it will be to protect their secret...	01KGA4QMVMTNFBWP5MDHA6NP0B	3.0	2018-05-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 3	(C) Yousuke Kaneda/ Kodansha Lyd.	2018-06-12T07:00:00.000Z
PRD_1RZ9NFZ8KE40	CNT_20JAS1B0WAAG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 11	[]	Boarding School Juliet Volume 11	Inuzuka and Persia are now second-years, and with the yeoman (and -woman) post comes a new responsibility: they've each been put in charge of monitoring their own batch of new baby first-years! If they want their votes in the upcoming prefect election, the secret lovers will have to win their rebellious charges' hearts and minds. Only, when both of them have no idea what's going through those minds, that's easier said than done… Can Inuzuka and Persia get the new kids under control before yet another battle of the dorms breaks out?	01KGA7BNX3N236GNBZVEG00F00	11.0	2019-07-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 11	(C) Yousuke Kaneda/ Kodansha Lyd.	2019-07-23T07:00:00.000Z
PRD_21XZ83RFPBJG	CNT_0XFMNWBK4ZGG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 8	[]	Boarding School Juliet Volume 8	Inuzuka and Persia have a secret date planned for the final day of the Dahlia Academy Festival, but even the best-laid plans of cats and dogs often go awry, and this time they're dealing with the mother of all complications: Persia's mom is on campus! Can our hapless hero make a good impression? Either way, after Persia's mother drops a bombshell about the school's biggest taboo, their secret love will enter a new stage...	01KGA6DK36PFTVXZ1DFXB1KFVY	8.0	2019-02-05T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 8	(C) Yousuke Kaneda/ Kodansha Lyd.	2019-02-12T08:00:00.000Z
PRD_22AY57ARY1Q0	CNT_2ZWTAS8HMCZG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 9	[]	Boarding School Juliet Volume 9	Inuzuka's back home in the Nation of Touwa for winter break--and Persia's come with him! She's even staying over at his house, disguised as middle school boy Julio. But the Inuzukas' “guard dog” Shuna soon suspects Julio of being a member of the fairer sex, and there's only one way to put her off the scent. That's right--for our Romio and Juliet to bathe together! When in Touwa, Julio will have to do as the Touwanese do!	01KGA6MMFMFPBKAMSXF741FNG2	9.0	2019-03-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 9	(C) Yousuke Kaneda/ Kodansha Lyd.	2019-03-26T07:00:00.000Z
PRD_274QZFP0VXKG	CNT_3JFCCGYX38J0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 10	[]	Boarding School Juliet Volume 10	It's a new school year at Dahlia Academy, and prefect selection season is now in full swing. Inuzuka and Persia are more determined than ever to become prefects and change the school rules, but they still have many walls they'll have to climb first! Not only do they need to gain the confidence of the entire student body, they'll also be up against some powerful rivals, both old and new… The time has come for them to battle the entire school--for love!!!	01KGA72104QW552QGP5TTNP0A1	10.0	2019-05-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 10	(C) Yousuke Kaneda/ Kodansha Lyd.	2019-05-28T07:00:00.000Z
PRD_2BZM5FGYAS4G	CNT_3G8MN0709EEG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 7	[]	Boarding School Juliet Volume 7	Dahlia Academy's first-years are away from their fair campus for a friendly three-day school trip, and surprising no one, it only takes one night for the fierce feud between the White Cats and Black Doggies to blow up yet again. This time, it's leading ladies Persia and Hasuki at each other's throats over Inuzuka's affections. They've vowed to prove once and for all which of them loves their dear Romio the most. As the sparks fly, can Inuzuka find a way to cool these ladies off without anyone getting burned?	01KG9AYRE1CQDQ6JBQ8JCWV3P4	7.0	2019-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 7	(C) Yousuke Kaneda/ Kodansha Lyd.	2019-01-08T08:00:00.000Z
PRD_2CFWSWMCQWQG	CNT_17306QHWNDM0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 14	[]	Boarding School Juliet 14	Inuzuka and Persia are settling into their new posts, and their first big job is to arrange the upcoming class trip—an unprecedented combined White Cat and Black Doggy trip to the Principality of West. The new set of prefects already have a mountain of work on their plates with the logistics alone, but convincing the dorm supervisors, let alone hundreds of individual students, to begin the hard work of truly breaking down the wall between the dorms will be an uphill battle. Luckily, they have some unexpected reinforcements from would-be yeomen Shuna, Kogi, and Amelia. Do the new kids have what it takes to collect enough signatures to get this trip approved? If so, this may just be the first step to changing the world!!	01KGA8CY2RZYGY2ESR73WXAZD0	14.0	2020-01-15T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet 14	Yousuke Kaneda/ Kodansha Lyd.	2020-01-28T08:00:00.000Z
PRD_2DRME7Y9S9DG	CNT_16X9BNY6RYNG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 2	[]	Boarding School Juliet Volume 2	Romio Inuzuka and Juliet Persia are boyfriend and girlfriend attending the same boarding school, but because their respective nations fight like cats and dogs, the persevering pair has gone to comedic lengths to keep their relationship status a secret from anyone and everyone, including their own best friends. When Inuzuka's oldest buddy Hasuki suspects that he's hiding something, Inuzuka is torn between keeping up the lousy lies, or fessing up and jeopardizing his already rocky relationship. Can Inuzuka and Persia's star-crossed connection survive this latest crisis? Actually, if he spills the beans, can Inuzuka himself survive??	01KGA4J7BH9RM67D3ZXC1V8M23	2.0	2018-05-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 2	(C) Yousuke Kaneda/ Kodansha Ltd.	2018-05-29T07:00:00.000Z
PRD_2G52E8KVN250	CNT_0S21H65ARQD0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 5	[]	Boarding School Juliet Volume 5	Inuzuka, Persia, and all the usual suspects hit the beach for a seaside camp, and we all know what that means: a swimsuit Shangri-la! Inuzuka is dying to get Persia alone for a sexy swimsuit date... Only, the daring duo soon find out that Inuzuka's date spot of choice is a little too lonesome when the full tide leaves them stranded--and spending the night together. Is Inuzuka in for the steamiest summer of his life?!	01KGA58XADP1ZD3FQTZJP1313V	5.0	2018-10-02T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 5	(C) Yousuke Kaneda / Kodansha Lyd.	2018-10-09T07:00:00.000Z
PRD_2T0EWK0Z33SG	CNT_20AGSF0WA7SG	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 4	[]	Boarding School Juliet Volume 4	All Romio Inuzuka wants is to wish his secret girlfriend Juliet Persia a happy birthday, but when Inuzuka's authoritarian older brother Airu suspects their relationship, the star-crossed couple's plans--and their confidence in keeping up their mad masquerade--all go down the tubes. Luckily, Persia's big day isn't over yet, and Inuzuka has one last chance to fool his big bro and meet up with her...it just happens to involve roping the Black Doggies into “crashing” Persia's birthday bash at White Cat House! Commence Operation: Pie Persia!	01KGA52TY23A8X4Q61BK2FQETP	4.0	2018-08-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 4	(C) Yousuke Kaneda / Kodansha Ltd.	2018-08-18T07:00:00.000Z
PRD_2VPAKPXBY7NG	CNT_2W2H1MT7EVY0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 16	[]	Boarding School Juliet 16	When Persia's father unexpectedly arrives at the second-years' class trip hotel to forcefully withdraw his daughter from Dahlia Academy, the Black Doggies and White Cats rally behind Inuzuka to rescue the damsel in distress (provided she doesn't rescue herself first)! Inuzuka and Persia's largest obstacle yet serves as a stark reminder that the feud remains alive and well outside of their insulated school, and this harsh reality will truly put their promise to change the world to the test... Will the dramatic final act of this star-crossed love story have a happy ending—or a tragic one?	01KG9CV1FDW491XATQT0QAFCTT	16.0	2020-07-27T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet 16	Yousuke Kaneda/ Kodansha Lyd.	2020-07-28T07:00:00.000Z
PRD_2X75FP1A6Y50	CNT_1NE2X0DJR07G	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 13	[]	Boarding School Juliet 13	At long last, star-crossed lovers Inuzuka and Persia are only one step away from becoming head prefects and tearing down the proverbial wall between the Black Doggy and White Cat dorms. That is, until rival candidate Reon Inugami drops one heck of a last-minute election surprise in front of the entire student body on voting day, shattering the tenacious twosome's hopes in one fell swoop. The cat may finally, irreversibly be out of the bag—and with their whole world seemingly against them, Romio and Juliet may be on the way out of school...	01KGA7R0BDD3VF01BT7XZ78AWS	13.0	2019-11-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet 13	Yousuke Kaneda/ Kodansha Lyd.	2019-11-26T08:00:00.000Z
PRD_35VA5117PF50	CNT_2SV0E0Y3QMD0	Boarding School Juliet CNT_3ZEP4CZ1A99G	CNT_3ZEP4CZ1A99G	2	1	1	Volume 6	[]	Boarding School Juliet Volume 6	Summer vacation is over, and it's the start of a brand-new term at Dahlia Academy. Between flower-viewing picnics, studying for midterm exams, and sneaking in secret dates, Inuzuka's school schedule is more jam-packed than ever. But as he'll soon find out, Inuzuka has a much more important problem on his hands--his best bud Hasuki might still be in love with him, and the feelings she's been holding in are on the verge of exploding!	01KGA5DMVQ3X2VC7EP8J18BGWV	6.0	2018-11-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Boarding School Juliet Volume 6	(C) Yousuke Kaneda / Kodansha Ltd.	2018-11-13T08: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);