database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_0Z603YNZ726G"

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_13DVMVGPT5C0	CNT_3F792EKCK870	Tokyo Boys & Girls CNT_0Z603YNZ726G	CNT_0Z603YNZ726G	2	1	1	Volume 2	[]	Tokyo Boys & Girls, Vol. 2	Kazukita drops the bomb and tells Nana to stop acting like his girlfriend. Nana is devastated. Later Mimori, like most teenagers, finds herself at odds with her mom, and after a fight runs out of the house to let off a little steam. While wandering around she finds herself in front of Atsushi's mother's hair salon. While Mimori is deciding what to do, Atsushi's mom drags her into the shop and has Atsushi give her a shampoo. Embarrassed, Mimori rushes home, and in the confusion loses her train pass. When Atsushi finds it and tracks her down to give it to her, she is so grateful she accidentally blurts out something she never meant to tell him!	01KGBHD6SPBJFKHF6F01EA08PA	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Tokyo Boys & Girls, Vol. 2	TOKYO SHONEN SHOJO © 1995 Miki AIHARA/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1DP4E78FA2G0	CNT_30GXC7AE7430	Tokyo Boys & Girls CNT_0Z603YNZ726G	CNT_0Z603YNZ726G	2	1	1	Volume 1	[]	Tokyo Boys & Girls, Vol. 1	The school year starts off well when Mimori befriends the beautiful Nana, but things quickly turn sour for her when she is chosen to be the class representative. Through a series of unfortunate events, she finds herself the focus of attention by three boys and her teachers for all the wrong reasons! Mimori is reunited with Atsushi, a boy she knew in elementary school--and it turns out he despises her for allegedly bullying him in their grade school days. In fact, he plans to exact a little revenge!	01KGBGKQ8147VYYTDHAWSJ8CSE	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Tokyo Boys & Girls, Vol. 1	TOKYO SHONEN SHOJO © 1995 Miki AIHARA/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1WZB98QCY6D0	CNT_1FWW2WX44960	Tokyo Boys & Girls CNT_0Z603YNZ726G	CNT_0Z603YNZ726G	2	1	1	Volume 4	[]	Tokyo Boys & Girls, Vol. 4	Summer is finally here and a hotheaded Kazukita tries to force himself on a confused and frightened Mimori! She barely escapes that harrowing situation only to go home and find another. She has to deal with her parents' impending separation! Finding herself unable to cope with her mother's problems, she escapes with Nana and Ran to Kazukita's apartment only to have Atsushi thrown in the mix! Can she figure out whom she truly loves and deal with her family crisis at the same time?	01KGBHD92C5VRTXZ1768GKEM9Z	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Tokyo Boys & Girls, Girls, Vol. 4	TOKYO SHONEN SHOJO © 1995 Miki AIHARA/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3X4K3H1HW6WG	CNT_2FHJJ5R8ARQG	Tokyo Boys & Girls CNT_0Z603YNZ726G	CNT_0Z603YNZ726G	2	1	1	Volume 3	[]	Tokyo Boys & Girls, Vol. 3	Mimori has finally become Atsushi's girlfriend! At an amusement park Mimori waits several hours in the rain for Atsushi, not knowing that he's been called away and can't return. She eventually collapses and wakes up in a hospital bed with Kazukita at her side!When they go to class, Kazukita announces to the whole class that he was with Mimori at the hospital. Atsushi and Nana are shocked. Nana renounces their friendship and Kazukita goes home, claiming a fever!	01KGBHD79NQ9BPXQQMPJ0492QA	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Tokyo Boys & Girls, Vol. 3	TOKYO SHONEN SHOJO © 1995 Miki AIHARA/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3YP0GY4FG7XG	CNT_0C75JT3ZZSPG	Tokyo Boys & Girls CNT_0Z603YNZ726G	CNT_0Z603YNZ726G	2	1	1	Volume 5	[]	Tokyo Boys & Girls, Vol. 5	Mimori's in for a super-shock when her best friend, Nana, tells her she might be preggers! So Mimori does what any best friend would and goes to talk it over with the guy who might have knocked Nana up--but he doesn't want to hear about it! Then it's time for Mimori to face up to her own boy issues as she struggles with the hard truth that she might have to move away...and break up with her brand-new boyfriend!	01KGBHD9KJPR8QVMGW021Y6MF7	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Tokyo Boys & Girls, Vol. 5	TOKYO SHONEN SHOJO © 1995 Miki AIHARA/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);