database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_04RJ3R350SG0"

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_0FCQAZ8SYPMG	CNT_0Y0S3HX4G0BG	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 5	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 5	Yoshino's at the end of her rope with her fiancé Kirishima, whose secretive actions during their trip back to her hometown of Osaka has come to bad ends. A group of yakuza with the backing of a trust fund baby with his own goals have come to Osaka to take their revenge, and Yoshino's not about to let them. She only has her wits to protect her, but no one can beat her on her own home turf. Meanwhile, the two most dangerous teenagers in the city, Shouma and Kirishima, are destroying everything in their path to clear her way. When all the dust has settled, to the victor goes the spoils. If Kirishima wins, Yoshino has agreed to finally formally start dating him!	YOU SMILE AS YOU EASE THE GUN FROM MY HAND	01KGASWYJQB0AHN7E4ZK08C8S3	5.0	2023-10-12T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 5	2021 Asuka Konishi	2023-10-24T07:00:00.000Z
PRD_0G4RBAJ2F5R0	CNT_1A146645HGW0	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 1	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 1	Yoshino grew up the sheltered yakuza princess of the largest crime family in Osaka, the Somei. Due to her resting bitch face and dangerous family, no man has ever approached her. When her grandfather signs a truce with the Tokyo-based Miyama crime family, he offers her up as a truce bride to the Miyama leader's grandson! Kirishima Miyama is popular, charming, and seems totally normal. But behind his smile is a violent sadomasochist who thirsts for her dominance even more when she impresses him with her moxie! Even though she knows how bad yakuza can be, she's stunned by Miyama's viciousness. She can't turn him down with the East-West peace treaty on the line...so instead she steels herself to play ball!	Too Much Love Will Kill You	01KGB2VB38VDT3TP6Z2GPVKYW7	1.0	2022-10-24T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 1	2017 Asuka Konishi	2022-12-06T08:00:00.000Z
PRD_1DRGJK734FXG	CNT_3HQX6ZM56HZG	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 3	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 3	Yoshino's life with Kirishima grows increasingly heated after he meets her adopted brother Shouma. Kirishima doesn't recognize his own jealousy until Yoshino points it out to him...and soon, he's not the only one burning up. It seems Osaka's temperatures have followed Yoshino up north when she catches her traditional summer cold. As her fever flares out of control, it's not the first time Kirishima's obsession could have saved her life--and it probably won't be the last!	I'VE GOT A FEVER FOR THAT GIRL	01KGB6A83CF7WEKTKS47JFJ1RV	3.0	2023-04-20T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 3	2019 Asuka Konishi	2023-05-23T07:00:00.000Z
PRD_1NHM917AGNF0	CNT_3CKHH7A245DG	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 7	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 7	As Kirishima's birthday approaches he has a favor to ask from Yoshino: there's someone he'd like her to meet. They make a trip to Kirishima's childhood home, a visit with an old relative far overdue. Yoshino finally has an opportunity to learn more about her enigmatic fiance. Meanwhile, with the Kirigaya Clan deep in murky conspiracies, the mysterious Azami schemes. When the opportunity arises to get Yoshino on her own, Azami's trap is sprung. An ambush from the shadows has Yoshino--will Kirishima get to her before it's too late?	LIFE AND DEATH ARE IN MY HANDS	01KG9PSXV952FX12V3CVMRV1TQ	7.0	2024-02-19T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 7	2023 Asuka Konishi	2024-04-02T07:00:00.000Z
PRD_20T43TA8AS40	CNT_1WX76ZRTH97G	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 4	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 4	Love can make you do some crazy things. For Kirishima, they're all for Yoshino, even an affair with an idol arranged by a spoiled rich kid for blackmail purposes. He's a tiger who has managed to trap the hunters in the cage with him. But as this intricate web of plans arranged by men comes to pass, the truth of the tale of the lady more vicious than even a tiger is revealed. The stress of dealing with Kirishima on her own home turf has made her snap, and now Yoshino is the one ready to move the pieces into the endgame. Perhaps she and Kirishima are better suited than she could ever imagine...	SOME THINGS YOU DO FOR MONEY, SOME YOU DO FOR LOVE	01KH3EJAWC1G79F7N3TQ0JHV80	4.0	2023-06-21T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 4	2020 Asuka Konishi	2023-08-01T07:00:00.000Z
PRD_23CYMVXT22ZG	CNT_1DRV13T4RNXG	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 8	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 8	After Yoshino's harrowing ordeal with the mysterious man with the octopus tattoo, it's Kirishima who now needs help. Wounded from his escape from Azami but otherwise in one piece, it's time that Kirishima share the truth of some of his shrouded past. From his troubled youth emerged a man who relied on no one, only to find his one true weakness in a girl. What happened to shape Kirishima into the man he is today...?	THE PAST OF A MAN WHO HIDES HIMSELF	01KGBCDJ9MVY4QYZMWS34GR2FF	8.0	2024-08-23T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 8	© 2023 Asuka Konishi	2024-09-03T07:00:00.000Z
PRD_2F3QG61T5DQ0	CNT_3M0KJ5RSMQ80	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 6	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 6	Ripples travel out from the battle in Osaka, and Renji is none too happy with Shouma and Kirishima for involving his granddaughter. When a fight breaks out, Yoshino grabs a bat and breaks it up. But corporal punishment is not her style, never mind that Kirishima would absolutely take it and beg for more. Kirishima's punishment is a little more subtle, and he repays her consideration by finally opening up about his life. Then, the ripples begin to splash when the yakuza Yoshino and Kirishima fought start to plan their revenge...	PLEASE DON'T SEND ME BACK TO WHERE I CAME FROM	01KGAV3MQNSV70WBWCT7G5B3GX	6.0	2023-11-20T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 6	2022 Asuka Konishi	2024-01-16T08:00:00.000Z
PRD_2V5BVE8M3KJ0	CNT_29CP5RP4JYA0	Yakuza Fiance: Raise wa Tanin ga Ii CNT_04RJ3R350SG0	CNT_04RJ3R350SG0	2	1	1	Volume 2	[]	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 2	The problems have compounded between Yoshino and Kirishima as their underworld love begins to blossom. Kirishima is charming, handsome, and funny...but his hair trigger for violence and his twisted declarations of masochistic love put Yoshino off-balance. And now a local yakuza princess has disappeared, and Kirishima has to stick with her for her protection! Yoshino knows she's got to find that missing girl as soon as possible so that she can be alone again! But the only person she can ask for help is...Kirishima himself?	WOULD YOU LOOK AT THAT, WE'RE THROWING OFF SPARKS	01KGB42JBDVT18YFN7E3A7QESE	2.0	2022-12-16T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PKAG51AEAQG	Yakuza Fiance: Raise wa Tanin ga Ii Vol. 2	2018 Asuka Konishi	2023-01-31T08: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);