database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_3KATVG1MDJ5G"

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_0V9PJR6NP0KG	CNT_13SS3BMYX4QG	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 3	[]	He's My Only Vampire, Vol. 3	The "Soiree"-a world you were better off knowing nothing about............ Eve's invitation, Aki agrees to attend the Soiree on his own. However, Kana and Jin aren't far behind, trailing him in secret. Then, at the climax of the blood-drenched ceremonies, Kana's "Awakening" begins at last!	01KGA6B3ZWM1CXMQ8BAN5WY1V4	3.0	2019-01-29T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 3	2019-01-29T08:00:00.000Z
PRD_0ZY1WB0ZJFJG	CNT_333P2N9783GG	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 1	[]	He's My Only Vampire, Vol. 1	You are my "thrall"--mine and mine alone...When Kana, a student at St. Agatha Academy, lays eyes on her long-lost childhood friend Aki amid the throng of the metropolis, the gears of destiny begin to turn!Meeting with an unfortunate accident not long after, Kana finds herself pulled from the arms of death by a vampire--Aki. Now Kana must give herself over to Aki, body and soul, as his "thrall," and soon she is trust into a dangerous game to obtain demonic powers known as "STIGMA," which could very well spell the end for her all over again!	01KG9AZCV1G86RWFD56JMKQ02F	1.0	2019-01-29T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 1	2019-01-29T08:00:00.000Z
PRD_15EAK9Y7X67G	CNT_1886633EJ2E0	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 4	[]	He's My Only Vampire, Vol. 4	"Take care... for your blood...is sweet... " The angels Isuka and Hitaki have been targeting Aki all along! In order to "purge" the pureblood vampire, they bring their Swords of Judgment down upon him! Will Kana be able to help Aki out of what appears to be a life-threatening situation...for them both?!	01KGA6FJDRKFKEWM96CZQA1AAT	4.0	2019-02-26T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 4	2019-02-26T08:00:00.000Z
PRD_16ST1PWXH70G	CNT_38Y96HD673D0	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 6	[]	He's My Only Vampire, Vol. 6	"Forgive me. I can no longer love you prettily......" After Kana regains her memories at Tsubakiin Manor, her feelings for Aki become colored by their shared past. Meanwhile, Aki offers Mishio a certain "deal" in order to rescue Kana. Where will Kana and Aki's rapidly developing destiny lead them?!!	01KGA6FM1G2TZGB3JME3DDT8VS	6.0	2019-02-26T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 6	2019-02-26T08:00:00.000Z
PRD_194R6P6JK3G0	CNT_12ZDS1AP8EYG	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 10	[]	He's My Only Vampire, Vol. 10	Born together and locked in endless struggle...that leaves us but one fate... Envy, the final Stigma appears at last...on Kana! To protect her, Aki resolves to battle Eriya in earnest and sets out for Tsubakiin Manor. The tale of the love and blood red bonds shared by the beautiful vampire twins and their thrall comes to a thrilling conclusion!	01KGA6KMFABTYQ4C55M1GAXKXM	10.0	2019-03-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 10	2019-03-26T07:00:00.000Z
PRD_1AP9V358Q4H0	CNT_33MGSQMDXFXG	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 8	[]	He's My Only Vampire, Vol. 8	"I will restore your love to you......" When Eriya offers to help retrieve Aki's memories, he and Kana begin spending quite a lot of time in each other's company. But seeing the two of them cozily conspiring together, Aki finds himself becoming strangely irritated-despite the fact that he's said to have lost all recollection of his love for Kana. And with that, the threads that bind the three together grow ever more tangled......	01KGA6KNE14SYSB70S0JY097HB	8.0	2019-03-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 8	2019-03-26T07:00:00.000Z
PRD_2SPSB2HTMF30	CNT_23EZKCE33M70	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 2	[]	He's My Only Vampire, Vol. 2	You are bound to each other by a crimson chain. Never, ever forget that. When Dealer Swallow suddenly appears, Kana learns in the ensuing scuffle just what it means to be a pureblood vampire's "thrall." With the lycanthrope Jin now fighting beside Kana and Aki as an ally, the three begin their search for the other Stigmas in a dangerous quest...	01KGA6B3CRSY9CS52CJ1W4JH57	2.0	2019-01-29T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 2	2019-01-29T08:00:00.000Z
PRD_34912TTB941G	CNT_23ZTEES9M0C0	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 9	[]	He's My Only Vampire, Vol. 9	"To think that sharing her with you would let me experience such unthinkable highs...!" At long last, Aki has regained his memory. However, he and Kana are faced with a painful truth--all along, Kana has actually been Eriya's thrall! Amid the chaos, the final Stigma appears, and the bloodred ties that bind the players in the game tighten to a stranglehold!	01KGA6KNWHYK71AQMD3RWSC4TF	9.0	2019-03-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 9	2019-03-26T07:00:00.000Z
PRD_3712TZF2Z7G0	CNT_08KFPT8ADJYG	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 5	[]	He's My Only Vampire, Vol. 5	"Forget about love and thirst only for blood" Acquiring a third Stigma took a heavy toll on Aki's body. To help him recuperate, Kana and the others plan a trip to a cozy hot-spring resort deep in the mist-shrouded mountains. Little do they know, this outing will open the sinister door of Aki's "original sin," and his hidden past will finally come to light!!	01KGA6FKHR56TVDVCZF682JEHP	5.0	2019-02-26T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 5	2019-02-26T08:00:00.000Z
PRD_38ZGCDMDN30G	CNT_039Q9RFJ3ZD0	He's My Only Vampire CNT_3KATVG1MDJ5G	CNT_3KATVG1MDJ5G	2	1	1	Volume 7	[]	He's My Only Vampire, Vol. 7	"You said you loved me, right?" Kana is heartbroken as Aki treats her with cold indifference after losing all memory of her and their time together. Amid this confusion, Eriya--Aki's younger twin brother said to have been put in sleep stasis after being nearly killed by Aki--makes his entrance!! What will happen when the blood-soaked vampire twins finally meet again?!	01KGA6KMYEK7G3R9GE1TSZDBAJ	7.0	2019-03-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PKAG51AEAQG	He's My Only Vampire, Vol. 7	2019-03-26T07: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);