database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_0XCTNQY6Y4V0"

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_04ZT6RRCE2R0	CNT_1K43HJ3764W0	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 6	[]	The Yakuza's Guide to Babysitting Vol. 6	Feeling sentimental, Kirishima pays a visit to the graveyard carrying a bouquet of kalanchoe, his mother's favorite flower. On top of that, there's a raid from big boss Takamatsu, a yakuza-style no-holds-barred game of baseball—and Kaede's dad turns out to be a policeman?!	LAW AND DISORDER	01KGB5ZBGPJ57NQ6CX3YF4NJWP	6.0	2023-03-06T08:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 6	(C) 2020 Tsukiya (C) MICRO MAGAZINE	2023-03-24T07:00:00.000Z
PRD_0AVC7Y9NWGY0	CNT_3WSYGYDDY550	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 3	[]	The Yakuza's Guide to Babysitting Vol. 3	Kirishima has grown accustomed to being a babysitter, the distance closing between his and Yaeka's hearts. But just as he finds himself being changed by Yaeka's innocence, tragedy strikes...and reignites a fire inside him. Will this unexpected turn of events bring the two closer together, or will this be the catalyst to reawaken the Demon of the Sakuragi family?	A GUARDIAN ANGEL OF VENGEANCE	01KGADB1ER5SXH0QAGZR1FMKQT	3.0	2022-01-13T08:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 3	(C) 2020 Tsukiya (C) MICRO MAGAZINE	2022-01-28T08:00:00.000Z
PRD_0C1623SZDQCG	CNT_2ZB2B7P8HT80	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 4	[]	The Yakuza's Guide to Babysitting Vol. 4	Kirishima goes missing without a trace—so it's up to Yaeka and Sugihara to find him. Though the incident that caused Yaeka injury seems to have been settled, it still weighs heavily on Kirishima's heart. But thanks to Yaeka and Sugihara, they might just be able to return to their peaceful everyday lives at last.	BABYSITTER BLUES	01KGAGQ7DVBJW8VRWQS50W9F6G	4.0	2022-05-30T07:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 4	(C) 2020 Tsukiya (C) MICRO MAGAZINE	2022-06-24T07:00:00.000Z
PRD_0E303BB1A9NG	CNT_12CECQE7AWT0	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 2	[]	The Yakuza's Guide to Babysitting Vol. 2	Kirishima Tooru is the right-hand man of the On the surface, he's the babysitter for the boss's only daughter Yaeka, but Kirishima is really a member of the yakuza by trade. Thanks to Kirishima's persuasion, Yaeka finally resolves to visit her mother in the hospital, where she shares the feelings she's built up over the past three years. Join this unlikely pair as they make Valentine's chocolates with the gluttonous high school girl Ayumu, become reunited with Kirishima's own former babysitter, and even meeting Yaeka's first friend!	AN UNLIKELY PAIR!	01KG9FR7KSKYB45JN3ZA476504	2.0	2021-07-26T07:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 2	(C) Tsukiya (C) MICRO MAGAZINE	2021-07-30T07:00:00.000Z
PRD_1C08C51W67JG	CNT_1K4GTBA9RB6G	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 1	[]	The Yakuza's Guide to Babysitting Vol. 1	Kirishima Tooru is the right-hand man of the Sakuragi crime family. For him, the job is a perfect excuse to let his violent instincts run wild, earning him the nickname "the Demon of Sakuragi". It seems like nothing will stand in the way of his vicious nature. But then one day, he receives an assignment like never before from the boss—babysitting his daughter! This is the heartwarming (or is it bloodcurdling?) story of a little girl and her yakuza caretaker!	WHO'S YOUR NANNY?	01KG9E2SKNSFK5PWBXQ8T3FJ4H	1.0	2021-02-01T08:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 1	(C) Tsukiya (C) MICRO MAGAZINE	2021-02-12T08:00:00.000Z
PRD_2EDM32R7CFD0	CNT_25NJP4YBFZS0	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 7	[]	The Yakuza's Guide to Babysitting Vol. 7	The Sakuragi boss has been summoned by his sworn brother Touyama. At their meeting, a shocking revelation shakes the foundations of the Sakuragi family: Survivors from the family responsible for running down the boss's beloved wife are on the loose...	FAMILY MATTERS	01KGAXXNVNYWFWWBA5TW804XNY	7.0	2024-01-19T08:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 7	(C) 2022 Tsukiya (C) MICRO MAGAZINE	2024-02-02T08:00:00.000Z
PRD_3XTA27HNN1X0	CNT_1CTX36R6DY9G	The Yakuza's Guide to Babysitting CNT_0XCTNQY6Y4V0	CNT_0XCTNQY6Y4V0	2	1	1	Volume 5	[]	The Yakuza's Guide to Babysitting Vol. 5	At a meeting with the Sakuragi family's head house, Kirishima has a run-in with his mortal enemy, a man called Mashiro. Faced with someone who knows his true nature and prefers him that way, will Kirishima let his annoyance get the better of him...?	BLAST FROM THE PAST	01KGAJBJSZKH9R0S9C4P9V1FJ8	5.0	2022-07-28T07:00:00.000Z	Kaiten Books LAB_2R8ZVT0JXVF0	GEO_1PQM5BDYSMG0	The Yakuza's Guide to Babysitting Vol. 5	(C) 2020 Tsukiya (C) MICRO MAGAZINE	2022-08-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);