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

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_0ACFB29ENV2G	CNT_3WFSXPYMWFPG	BL Metamorphosis CNT_3E1W0PYA6A5G	CNT_3E1W0PYA6A5G	2	1	1	Volume 3	[]	BL Metamorphosis Vol. 3	After a little push from Ichinoi, Urara finally takes a step toward something she has only dreamed about! They might be over fifty years apart, but Urara and Ichinoi prove that age means nothing when it comes to the support of a good friend!	BLFFS	01KG9DF0GFM3A35GJXR0084SK4	3.0	2020-11-13T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	BL Metamorphosis Vol. 3	Kaori Tsurutani 2019	2020-12-22T08:00:00.000Z
PRD_1Z2RGCFTKG3G	CNT_1E78JAEJ8AJ0	BL Metamorphosis CNT_3E1W0PYA6A5G	CNT_3E1W0PYA6A5G	2	1	1	Volume 5	[]	BL Metamorphosis Vol. 5	Comitia is well underway, but Ichinoi is getting overheated and they have yet to sell a single thing! Urara is just about to throw in the towel when a certain someone from the publishing industry shows up at her table! Can true friendship make dreams come true? Find out in the final volume of BL Metamorphosis!	The Power of Friendship...and BL!	01KG9GE93S2S5MPQGSWW3QYWKZ	5.0	2021-07-16T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	BL Metamorphosis Vol. 5	Kaori Tsurutani 2021	2021-09-21T07:00:00.000Z
PRD_2AH9R5PCFSC0	CNT_1PHHSXMKPEGG	BL Metamorphosis CNT_3E1W0PYA6A5G	CNT_3E1W0PYA6A5G	2	1	1	Volume 2	[]	BL Metamorphosis Vol. 2	Urara and Ichinoi have made it to the doujinshi event! Can they survive the crowds and long lines and finally meet Komeda-sensei?	FOR THE LOVE OF BL!	01KGA994DFXDVB0WK7A31RA6FF	2.0	2020-05-28T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	BL Metamorphosis Vol. 2	Kaori Tsurutani 2018	2020-07-28T07:00:00.000Z
PRD_2GR6FTJWZ2MG	CNT_2XGFNK4996CG	BL Metamorphosis CNT_3E1W0PYA6A5G	CNT_3E1W0PYA6A5G	2	1	1	Volume 4	[]	BL Metamorphosis Vol. 4	Under Ichinoi's watchful eye, Urara is diving headfirst into making her first manga! Their friendship began with a shared love of reading--how deep will it grow as they navigate the challenges of spinning a good yarn?!	BL 4 Ever	01KG9EJ57JR53S4K980KWNXAEC	4.0	2021-01-15T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	BL Metamorphosis Vol. 4	Kaori Tsurutani 2020	2021-03-30T07:00:00.000Z
PRD_2S2T9T9D08ZG	CNT_1RT37Y33HSW0	BL Metamorphosis CNT_3E1W0PYA6A5G	CNT_3E1W0PYA6A5G	2	1	1	Volume 1	[]	BL Metamorphosis Vol. 1	Ichinoi, a seventy-five-year-old woman living a peaceful life, unwittingly buys a boys' love manga one day, and is fascinated by what she finds inside. When she returns to the bookstore to buy the next volume, the high school girl working there--Urara, a seasoned BL fan--notices a budding fangirl when she sees one. When Urara offers to help Ichinoi explore this whole new world of fiction, the two dive into the BL fandom together, and form an unlikely friendship along the way.	Boys' Love for the Ages	01KG9BSMD7Z512VVFYEQXWJ0GD	1.0	2020-03-23T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	BL Metamorphosis Vol. 1	Kaori Tsurutani 2018	2020-04-28T07: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);