products

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

3 rows where series_id = "CNT_22M8XQ0D0S90"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at (date), on_sale_at (date)

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_0Z78J4N6MTP0 CNT_3553DFJ6N9NG Small Nozomi and Big Yume CNT_22M8XQ0D0S90 CNT_22M8XQ0D0S90 2 1 1 Volume 3 []   Small Nozomi and Big Yume 3   When Nozomi's explanations don't add up, even airheaded Yume figures out she's real...which only fuels her fantasy of having Nae and Nozomi as her very own dolls-frilly dresses included. But when Yume remembers Big Nozomi and tails her for questioning, the origin of the mini-people is finally revealed...but not before disaster strikes. Now that their lives are on the line, can a shut-in like Yume brave the outdoors and fight for her (only) friend?   01KGB7XN9HPHQ35KC0S9PP42R0 3.0 2023-06-27T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Small Nozomi and Big Yume 3 Sou Hamayumiba/Kodansha Ltd.   2023-07-18T07:00:00.000Z   0 0
PRD_3862EHSH1GV0 CNT_1TKKPWKWAJH0 Small Nozomi and Big Yume CNT_22M8XQ0D0S90 CNT_22M8XQ0D0S90 2 1 1 Volume 2 []   Small Nozomi and Big Yume 2   Now having met another mini-person who's even smaller than she is, Nozomi is more eager than ever to find clues about her short stature at the shrine in the mountains where she first awoke. Problem is, one small step for man is a perilous journey for Nae and Nozomi. Meanwhile, Yume faces a daunting trial (for introverts) back home-getting a delivery and answering the door. But when she stumbles upon Nozomi's cardboard abode, she begins to piece together that maybe, just maybe...Nozomi isn't a figment of her imagination after all.   01KGB7K3A398M5W90NE5J2JBGS 2.0 2023-05-30T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Small Nozomi and Big Yume 2 Sou Hamayumiba/Kodansha Ltd.   2023-06-20T07:00:00.000Z   0 0
PRD_39Q1SSCRN9W0 CNT_2RCNMR47QVR0 Small Nozomi and Big Yume CNT_22M8XQ0D0S90 CNT_22M8XQ0D0S90 2 1 1 Volume 1 []   Small Nozomi and Big Yume 1   High schooler Nozomi Koiwa wakes up and discovers she's lost her memories...and a whole lot of height. Now the size of a soda can, she flees from a feline assault into the disgusting den of Yume Okubo, a drunken shut-in NEET who's terrified of people and hasn't been outside for months. Between falling beer cans and deadly insect traps, Nozomi survives long enough to convince the airheaded Yume that she's a figment of her imagination who's come to save her from hitting rock bottom...all while investigating how she ended up funsized. But despite their differences-height, brains, and otherwise-each half of this quirky combo might just be what the other needs!   01KGB6N3NZWDFK5CHEE7ZGBHNV 1.0 2023-04-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Small Nozomi and Big Yume 1 Sou Hamayumiba/Kodansha Ltd.   2023-05-16T07:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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