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

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_0T9JCPTFC65G	CNT_3WBX3D36RAA0	My Darling Next Door CNT_2E4A4107T5Y0	CNT_2E4A4107T5Y0	2	1	1	Volume 2	[]	My Darling Next Door 2	The more Ririka gets to know her new neighbor Hinocchi, the more she falls for him. But he's an office worker who's five years older than her! Ririka wants to change her position from little sister to romantic interest, but Hinnochi's unconscious charm keeps her at its mercy...! Check out volume 2 of this love story between a gyaru and her white collar neighbor!!	01KG9GK06EWW1NXWQZ133PB897	2.0	2021-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Darling Next Door 2	My Darling Next Door Rukana/Kodansha Ltd.	2021-08-24T07:00:00.000Z
PRD_1E4PWTMRPCAG	CNT_3Q2QNERGD19G	My Darling Next Door CNT_2E4A4107T5Y0	CNT_2E4A4107T5Y0	2	1	1	Volume 4	[]	My Darling Next Door 4	Just when Ririka works up the nerve to tell Hinocchi how she feels about him, he turns her down. Heartbroken and in shock, Ririka embarks on her school trip to Hokkaido... In a crazy turn of events, she runs into Hinocchi, who's there on a business trip. As they look at out at the nighttime view of the city, they're able to talk frankly about their feelings. Upon returning, Ririka finds that both Hinocchi's birthday and Christmas are quickly closing in... along with the distance between her and Hinocchi!	01KG9HGS0GTE1T724X8TX6XC15	4.0	2021-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Darling Next Door 4	My Darling Next Door Rukana/Kodansha Ltd.	2022-01-18T08:00:00.000Z
PRD_2TDG21N8FMKG	CNT_1KYVNG85KQW0	My Darling Next Door CNT_2E4A4107T5Y0	CNT_2E4A4107T5Y0	2	1	1	Volume 3	[]	My Darling Next Door 3	Ririka's hopelessly in love with her next-door neighbor, Hinocchi. Even though she wants to keep taking things slow, her one-sided affections come pouring out—right in front of him! On Hinocchi's part, although he handled her like a responsible adult at first, his true feelings gradually come to light as Ririka's keep growing stronger! Will they take things a step beyond being "just neighbors"...?!	01KG9GX6AJE8ZN6RA8RQ3H0HV7	3.0	2021-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Darling Next Door 3	My Darling Next Door Rukana/Kodansha Ltd.	2021-09-21T07:00:00.000Z
PRD_3J39RGBN0J0G	CNT_2W71RW5CMCX0	My Darling Next Door CNT_2E4A4107T5Y0	CNT_2E4A4107T5Y0	2	1	1	Volume 1	[]	My Darling Next Door 1	Ririka thinks she must be missing out—after all, what high school girl isn't obsessed with romance? But when a young, handsome salaryman moves in next door, she realizes she may just be able to understand the appeal of crushes, after all...	01KG9FVHRDDGTHGNMP9ZWRD86Q	1.0	2021-07-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Darling Next Door 1	My Darling Next Door Rukana/Kodansha Ltd.	2021-07-27T07:00:00.000Z
PRD_3SE9K1M6W0G0	CNT_17WVN550PJNG	My Darling Next Door CNT_2E4A4107T5Y0	CNT_2E4A4107T5Y0	2	1	1	Volume 5	[]	My Darling Next Door 5	Hinocchi and Ririka both have feelings for each other, but they've agreed to keep things platonic until she graduates in six months. Even kissing is off the table! Hoping to still find ways to kindle their romance, Ririka plans a date at his house. Hinocchi has trouble holding himself back, but knowing that he feels that strongly about her only makes Ririka like him more. Finally, the two get to go on a real date! Ririka is over the moon, but it seems Hinocchi has some bad news...	01KGAGSJGM8NCM0ATYMQ5JS617	5.0	2022-06-09T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Darling Next Door 5	My Darling Next Door Rukana/Kodansha Ltd.	2022-06-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);