database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_0RK86K7VZ9YG"

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_0KEEZDGKZBM0	CNT_12K07TT8PXF0	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 3	[]	Yakuza Lover, Vol. 3	Reunited at last, Oya and Yuri savor their first night back in each other's arms by making love until Yuri passes out from exhaustion. Later, Yuri returns to her normal life in Japan, but it isn't long before Oya comes to whisk her away. When he takes her to a private villa, Yuri believes it's so the two of them can get a second chance at a carefree summertime romp together. But it soon becomes clear that Oya has something else on his mind.	01KGBHHB2DFNDQ90QKHMB6F8AV	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 3	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_0XG8JS84FQR0	CNT_17WM1KHAASB0	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 1	[]	Yakuza Lover, Vol. 1	After the atack at the party, Yuri goes to see Oya to thank him for saving her and as much as she hates to admit it, she can't deny there's an attraction. However, when tragedy strikes, Yuri attempts to turn her back on Oya and his dangerous lifestyle for good—but will the allure prove too great to resist?	01KGBGM5CC8KHD0JYEB26VZCAC	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 1	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_10Z4CQEP1F0G	CNT_01M5NZ82XHKG	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 8	[]	Yakuza Lover, Vol. 8	Yuri and Oya are about to spend Yuri's birthday on a luxurious private island when an unexpected phone call from Oya's father ruins their plans. A new enemy has appeared—Mao, the boss of the largest Chinese mafia group—and he and Oya have a history. Although danger is imminent, Oya vows to spend whatever time he has left with Yuri. But he can't help but wonder what Mao could possibly want...	01KGBHHJEKWW9WNMY1MGN2V668	8.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 8	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_17DMYA8RDE7G	CNT_20YJNAYB8GWG	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 7	[]	Yakuza Lover, Vol. 7	After Oya rescues Yuri from Jin, a detective who was Yuri's childhood friend, he's enraged and consumed by the desire to claim her body once more, but his injuries get in the way. Jin refuses to give up on Yuri, forcing Oya to take drastic measures to put an end to this love triangle once and for all! Later, with Oya still unable to have sex, Yuri feels compelled to do "something" for him for the very first time!	01KGBHHHF0HRCQG7PHBMR6GRYZ	7.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 7	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1WEN14DC501G	CNT_2EA8ADKTEJJG	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 10	[]	Yakuza Lover, Vol. 10	Oya and Yuri must overcome one last obstacle if they hope to escape the Shéxiē's underwater lair—Oya's older brother Mao. Just as Oya gains the upper hand, nostalgia for the better days with his estranged brother gets the best of him. Can Oya find it in himself to pull the trigger and end this threat once and for all?	01KGBHHMP0K0QWZ0X0K1EVVJM4	10.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 10	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_2ZB0SGS71Q8G	CNT_047XPAP649VG	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 2	[]	Yakuza Lover, Vol. 2	Yuri and Oya's romantic getaway in Shanghai is cut short when sinister Russian mob boss Semilio kidnaps Yuri and tries to make her his own. But Yuri won't be won over so easily and fights off his advances. And then Oya suddenly comes to her rescue! With Yuri finally out of harm's way, Oya charges headfirst into battle against Semilio, leaving Yuri to wonder if he'll make it out alive.	01KGBHH54PWM0X1VQM4NN47CK0	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 2	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_314C51SVFFG0	CNT_119W50372130	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 6	[]	Yakuza Lover, Vol. 6	Unable to shake off the effects of the aphrodisiac he was drugged with, Oya finds an antidote in a passionate night with Yuri. Later, the Oya syndicate packs the banquet hall to celebrate their underboss's birthday. When Oya sees how beautiful and nervous Yuri is, he decides he wants her all to himself and proposes a competition! Meanwhile, Jin, a man from Yuri's past, suddenly appears—and it turns out he's an organized crime detective!	01KGBHHHYT24PS7B6FCW73PYVD	6.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 6	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_32QXTEZH30H0	CNT_31ZF5PEYQ220	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 9	[]	Yakuza Lover, Vol. 9	Yuri has been kidnapped by Mao, Oya's older brother and the cruel leader of China's largest mafia syndicate! In response, the Oya syndicate renounces all ties to Mao and uses the full force of its power to try to save Yuri! Although she's been put up for sale at a black market auction, Yuri never loses hope that she'll return to Oya's warm embrace. Will Oya reach her in time, or will she be sold to the highest bidder?	01KGBHHJZ4PXDDTDY6MRPRWY85	9.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 9	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_35TWGMVXBEQ0	CNT_30M94KSFH0C0	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 5	[]	Yakuza Lover, Vol. 5	Choko, a hostess working at a club under the Oya syndicate's protection, has her sights set on Oya. Determined to have Oya all to herself, the femme fatale arranges for Yuri to be attacked so she can play the hero and use it as an excuse to get closer to Oya. Oya discovers Choko's plot, but it's part of the Oya syndicate's creed to never lay hands on a woman. So how is he going to settle the score with her?	01KGBHHGSFDZG7JX8R6P5T9FFR	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 5	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_38BF27N7QDP0	CNT_13Y64XFQWZD0	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 4	[]	Yakuza Lover, Vol. 4	Yuri and Oya's relationship faces complications when Oya's father, the boss of the syndicate, issues a warning to Yuri, demanding she cut ties with Oya and the yakuza. When Oya finds out, the situation becomes charged. Meanwhile, a mysterious woman enters the fray, soon to add new challenges to the star-crossed couple's growing love.	01KGBHHE20DHY3DVJ0J1EAX62D	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 4	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3GDK014RK3D0	CNT_3CNTVXQX3660	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 12	[]	Yakuza Lover, Vol. 12	Yuri has abandoned her family and friends to be with Oya, the man she loves. But just as it seems the star-crossed pair have managed to achieve their happily ever after, Oya's mother thwarts their plans. Deeming Yuri an unsuitable partner for a yakuza, she demands that Oya enter into an arranged marriage instead. Can Oya and Yuri overcome the objections of the Oya syndicate's absolute authority?	01KGBHHSHR1AT424XYFK7SZ16K	12.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 12	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3Q23KM62Z2C0	CNT_1FZQVFC5E570	Yakuza Lover CNT_0RK86K7VZ9YG	CNT_0RK86K7VZ9YG	2	1	1	Volume 11	[]	Yakuza Lover, Vol. 11	Yuri is back in Oya's arms once more, but their blissful reunion is soured when Yuri's family discovers their forbidden love affair. Even in the face of Yuri's father's fury, Oya refuses to back down or run away. With the pressure mounting, Yuri must make the hardest decision of her life. Will she choose her family and friends, or the man she loves?	01KGBHHRNX3GPX89ABG52N14TT	11.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Yakuza Lover, Vol. 11	KOI TO DANGAN © 2019 Nozomi MINO/SHOGAKUKAN	2024-11-26T08: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);