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_0K9RT94F2GK0"

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_05K7J24CES9G	CNT_3FRFM220KS10	Ogi's Summer Break CNT_0K9RT94F2GK0	CNT_0K9RT94F2GK0	2	1	1	Volume 2	[]		Ogi's Summer Break, Volume 2		For Haurto Ogi, there's nothing more painful than unrequited love. After agreeing to date Tago, the handsome, vision-impaired boy who boldly proposed a relationship for the length of summer break, Ogi can't help worrying about the inevitable future heartbreak. When Tago's older brother insinuates Ogi only pursued his brother because Tago can't see the feminine, eccentric way Ogi dresses, Ogi decides to change. If he can make himself look "normal," maybe their relationship won't be questioned and maybe... maybe Tago will fall in love with Ogi for real. A quirky and gentle story about overcoming fears and loving yourself and others for who they truly are.		01KGB6G3XYRW5CCAT88PQK9M99	2.0	2023-05-15T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Ogi's Summer Break, Volume 2			2023-05-17T07:00:00.000Z		0	0
PRD_0GB618ZC10B0	CNT_27PNEJSC0XB0	Ogi's Summer Break CNT_0K9RT94F2GK0	CNT_0K9RT94F2GK0	2	1	1	Volume 1	[]		Ogi's Summer Break, Volume 1		It's love at first sight for Haruto Ogi when he befriends Tago, a vision-impaired high school student who navigates the world with a cane and and a carefree, forthright attitude. But when Tago proposes that they go out for the summer, Ogi is torn between excitement and a deep-seated certainty that the connection between them isn't meant to last.Behind Ogi's flinching uncertainty is a deeper fear of rejection, and Tago's casual approach toward their relationship only makes him more self conscious. For the first time, Ogi feels like he can be himself, because Tago can't see his appearance and judge him by his 'eccentricities.' But does Tago really care for Ogi as his boyfriend, or does he just want to keep Ogi's friendly presence by his side?A quirky and gentle story about overcoming one's fears and loving yourself and others for who they truly are.		01KG9KSD5HKQ640QZW7S2WEKMA	1.0	2023-02-06T08:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Ogi's Summer Break, Volume 1			2023-02-08T08: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);