database: products: 2 rows where series_id = "CNT

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

2 rows where series_id = "CNT_1CCME3T8VAW0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	subtitle	display_title	display_title_short	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_presale_at	on_sale_at	off_sale_at	add_on	add_on_campaign_only
PRD_05ZEQTJS1JFG	CNT_3HY8R3ETF54G	Love on the Horizon CNT_1CCME3T8VAW0	CNT_1CCME3T8VAW0	2	1	1	Volume 1	[]		Love on the Horizon 1		Art university student Nagi Kitagawa is hopelessly in love with Yu Yamasaki, his senpai in the folk song club who also happens to be his next door neighbor. Yu seems to have it all-good looks, a great personality, and he's also super popular-so Nagi can't help but think he'd never fall for a shy, innocent country bumpkin like him. One night, after drinking too much at one of their club get-togethers, Nagi helps a drunk Yu get home safe-but before he can go back to his own apartment, Yu wraps Nagi in his arms and falls asleep, trapping Nagi in his embrace. Nagi sneaks out the next morning, careful to not wake Yu up, and vows to keep the incident a secret. But when Nagi finds himself growing closer and closer to Yu, his unrequited feelings only grow stronger...but could it be his love isn't as one-sided as he thinks it is...?		01KGBGN61DTSG8HZ7QA5QHA2YJ	1.0	2024-12-17T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love on the Horizon 1	Machi Yamashita/Ichijinsha Inc.		2025-01-07T08:00:00.000Z		0	0
PRD_3YV63G3WR1SG	CNT_1G0ASSJ84N50	Love on the Horizon CNT_1CCME3T8VAW0	CNT_1CCME3T8VAW0	2	1	1	Volume 2	[]		Love on the Horizon 2		Shy, naïve Nagi Kitagawa has now been dating his next-door neighbor, the popular yet kind Yu Yamasaki, for over half a year. Though their relationship started by Nagi helping a drunk Yu return home, then sleeping next to him in his bed, they now take things at their own pace, allowing the connection between them to blossom little by little as they spend their everyday lives together. While dating in general is new to Nagi, Yu is overwhelmed by his first feelings of true love. Both boys attend an arts university in Tokyo, although Yu will be graduating soon. Will their love be able to stand the test of time once they no longer go to the same school?		01KG9QJ7HDDP5E7CVQMJQ8293P	2.0	2025-04-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Love on the Horizon 2	Machi Yamashita/Ichijinsha Inc.		2025-05-06T07:00:00.000Z		0	0

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);