database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_0XF3K0Z6APN0"

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_0RMQHSGB874G	CNT_2MG7VSAJZWF0	Heroine for Hire CNT_0XF3K0Z6APN0	CNT_0XF3K0Z6APN0	2	1	1	Volume 3	[]	Heroine for Hire 3	Shuko, aware of her love for Serizawa-kun, decided that she wants to do her best in love. She gets up the courage to invite Serizawa to the sea during the summer vacation. During the double date with Kazune-chan and Kazuki-sempai, an unexpected word came out of her mouth!? On top of that, She runs into Sakaki-kun, who's the source of Shuko's trauma. Summer vacation and a school festival☆ The excitement is speeding up with the appearance of a new boy, too! This is volume 3 of an unexpected first love first experience story between a super strong girl and a super popular boy!	01KG9DCPNVPVQS4AV2KYBGDPHJ	3.0	2020-11-04T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Heroine for Hire 3	Fuyu Amakura / Kodansha Ltd.	2020-11-17T08:00:00.000Z
PRD_32AQZX67X530	CNT_2JY6QQEY0A1G	Heroine for Hire CNT_0XF3K0Z6APN0	CNT_0XF3K0Z6APN0	2	1	1	Volume 1	[]	Heroine for Hire 1	Shuko Kodakamine is strong-too strong, by the standards of some. She hopes to make a good high school debut, but that plan goes up in smoke almost immediately when she injures the attractive, charismatic Serizawa-kun...and later suplexes him, to boot! But when Serizawa-kun finds himself in hot water with a jealous boyfriend, it's Shuko who comes to his aid...and he comes up with a ridiculosu proposition: If Shuko becomes his bodyguard, he'll make her the most important girl in his world!	01KG9CCAYPQHB5GTC3CDPVZFM1	1.0	2020-09-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Heroine for Hire 1	Fuyu Amakura / Kodansha Ltd.	2020-09-15T07:00:00.000Z
PRD_3AJRMX198JD0	CNT_3HFAP48JKQQG	Heroine for Hire CNT_0XF3K0Z6APN0	CNT_0XF3K0Z6APN0	2	1	1	Volume 2	[]	Heroine for Hire 2	Shuko's impression of Serizawa-kun changes every time she sees his pure, honest side. After their informal date, for some reason, her heart begins to race and she's becoming interested in him! Then, they end up helping out the student council. While they're working together, her feelings for Serizawa-kun steadily begin to strengthen. Are these brand new feelings possibly love?! When she's with him, she starts feeling more and more girly. This is the story of an unexpected first love experience between a super strong girl and a super popular boy! Volume 2.	01KG9D9J2VWXPF23AKA4V7FVJK	2.0	2020-10-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Heroine for Hire 2	Fuyu Amakura / Kodansha Ltd.	2020-10-20T07:00:00.000Z
PRD_3KEDSFNANGA0	CNT_3CQ7C0WVR4Y0	Heroine for Hire CNT_0XF3K0Z6APN0	CNT_0XF3K0Z6APN0	2	1	1	Volume 4	[]	Heroine for Hire 4	Shuko decides to tell Serizawa-kun her feelings at the school festival. While she was nervous and couldn't say it, she was taken around by her childhood friend Sakaki-kun. On the other hand, the relationship between Kazune and Kazuki-sempai has also made some considerable progress...?! What is the end for the love story between a super strong girl and a super popular hero? "I can be the best girl in the world" -The final volume of excitement!	01KG9DHGF4D77FDRZTNXH071AT	4.0	2020-12-02T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Heroine for Hire 4	Fuyu Amakura / Kodansha Ltd.	2020-12-15T08: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);