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

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_0S3DEXK70SG0	CNT_0P4B7EYPZBM0	Life Lessons with Uramichi Oniisan CNT_3WGX7DQ3N370	CNT_3WGX7DQ3N370	2	1	1	Volume 4	[]	Life Lessons with Uramichi Oniisan 4	Time comes for us all-including URAMICHI's poor back muscles. While contending with an aging body and brutally honest kids may all be in a day's work for him, dealing with a happy-go-lucky con artist sure isn't! As URAMICHI is unwillingly dragged into another one of HANBEI's desperate attempts to meet upper management at the bare minimum, MITSUO and HACHITA are standing by to help with pure disinterest and an onslaught of painful truths.	01KGB60JVFB70D3GQXFRGJ3C36	4.0	2023-04-11T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Life Lessons with Uramichi Oniisan 4	Gaku Kuze/Ichijinsha Inc.	2023-05-02T07:00:00.000Z
PRD_1M9Y96Q2D8H0	CNT_350E26QACCJ0	Life Lessons with Uramichi Oniisan CNT_3WGX7DQ3N370	CNT_3WGX7DQ3N370	2	1	1	Volume 3	[]	Life Lessons with Uramichi Oniisan 3	Despite his best efforts, Uramichi continues to find himself at the mercy of the outrageous demands of his fellow coworkers and management. Whether it's looking after someone's pet or younger sibling, or drumming up new designs for Hanbei's merch, the paths to escape responsibility are too few and far between. Then, just as he's reaching for a lifeline during one of his most grueling days yet, his old college acquaintance Nekota appears. Could someone with such a different take on adulthood be Uramichi's salvation?	01KGADBSB9SH8MBEPAEGY1YTBK	3.0	2022-01-21T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Life Lessons with Uramichi Oniisan 3	Life Lessons with Uramichi Oniisan Gaku Kuze/Ichijinsha Inc.	2022-02-22T08:00:00.000Z
PRD_25TKJPZM1K50	CNT_1AR0DST2K7K0	Life Lessons with Uramichi Oniisan CNT_3WGX7DQ3N370	CNT_3WGX7DQ3N370	2	1	1	Volume 2	[]	Life Lessons with Uramichi Oniisan 2	While grappling with unexpected overtime, unreasonable working conditions, and unflattering costumes, URAMICHI makes the acquaintance of other jaded professionals working deep behind the scenes. Digital strategist SAITO and merchandising whiz HANBEI almost seem like kindred spirits, but their respective bad attitude and worse temper keep the doors to URAMICHI's fragile heart firmly shut. There must be someone out there who understands...right?	01KG9DHNNCSY36QQWV973CS73W	2.0	2021-01-19T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Life Lessons with Uramichi Oniisan 2	Gaku Kuze / Kodansha Ltd.	2021-01-19T08:00:00.000Z
PRD_2B7RWFT163R0	CNT_09F2NMWRR84G	Life Lessons with Uramichi Oniisan CNT_3WGX7DQ3N370	CNT_3WGX7DQ3N370	2	1	1	Volume 1	[]	Life Lessons with Uramichi Oniisan 1	Uramichi is a 31-year old children's TV host who leads physical exercises and teaches life lessons colored by one main theme: adulthood sucks. Alongside mascots played by a couple of bushy-tailed millennials, and a singing duo whose music embodies the notion of being kicked while you're down, Uramichi wades through the misery of working life, one sardonic comment at a time...	01KG9CEHAD8N1SKC07BNVZ8BWZ	1.0	2020-11-10T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Life Lessons with Uramichi Oniisan 1	Gaku Kuze / Kodansha Ltd.	2020-11-10T08:00:00.000Z
PRD_2K9A08MR78NG	CNT_0QD1DA9X4BS0	Life Lessons with Uramichi Oniisan CNT_3WGX7DQ3N370	CNT_3WGX7DQ3N370	2	1	1	Volume 5	[]	Life Lessons with Uramichi Oniisan 5	URAMICHI's television hosting endeavors call him to new parts of the studio, including the set of PEEK-A-WHAT?!, where he meets the ambitious NANCY and the show's brand-new mascot with a secret behind its dopey smile. Off the set, he continues to contend with the fallout of his contribution to BUNNYBEAR THEATER. Forced to come face-to-face with the column's original artist, can he weasel his way out of yet another awkward situation...?	01KGBP5S3S3YCDE2ABF7434X14	5.0	2025-05-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Life Lessons with Uramichi Oniisan 5	Gaku Kuze/Ichijinsha Inc.	2025-05-20T07: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);