products

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

2 rows where series_id = "CNT_1GYS2MMCZGH0"

✎ 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_0J1X1SP74VE0 CNT_2VMAR7VGDZT0 She's the Cutest... But We're Just Friends! CNT_1GYS2MMCZGH0 CNT_1GYS2MMCZGH0 2 2 1 Volume 1 []   She's the Cutest... But We're Just Friends! Volume 1   Kai Nakamura has the average range of otaku hobbies for a high school boy, but the buddy he shares them with is far from ordinary... Kai's best friend in the whole world is Jun Miyakawa, his classmate known as a super hottie. Though Kai and Jun just met when they enrolled in high school, they hit it off with passion for all the same hobbies! When they're together, the pair never have enough hours in the day. Kai and Jun can't get enough of each other's company as they chat about video games and manga or sing anime songs at karaoke. Love is fleeting, but friendship is forever in this "just friends" rom-com filled with flirty fun!   01KG9CG37AXQP75CSBZEG86HX0 1.0 2020-12-03T08:00:00.000Z J-Novel Club LAB_30X9NTZYDFV0 GEO_1PQM5BDYSMG0 She's the Cutest... But We're Just Friends! Volume 1 Copyright (C) 2020 Akamitsu Awamura Illustrations (C) 2020 mmu   2021-02-01T08:00:00.000Z   0 0
PRD_3GCP75NVEFY0 CNT_2K9YZQP5VK2G She's the Cutest... But We're Just Friends! CNT_1GYS2MMCZGH0 CNT_1GYS2MMCZGH0 2 2 1 Volume 2 []   She's the Cutest... But We're Just Friends! Volume 2   She's the cutest, too... but we're just coworkers! "No way, you actually like me?!" Kai Nakamura, 16 years old, has just been asked out by a girl for the first time in his life. And the girl who has set her sights on him is the cute, anime-craving coworker he's been chatting up, Kotobuki Hotei! Struck by this bolt from the blue, Kai's at a loss—he doesn't dislike her, but where does he draw the line between liking her as a pal versus as a partner? Meanwhile, Kotobuki lays on the pressure and suggests they have a date to test their compatibility. Unable to refuse a passionate yet polite plea from this otherwise nervous wreck of a newbie, Kai agrees to a trial run, leading to the first real-deal date of Kai's young life. And if that wasn't stressful enough, his best girl friend Jun happens to spot them together at their destination... This Pure Friendship Romantic Comedy comes back for Part 2! Kai Nakamura has just been asked out by the cute coworker he's been chatting up! He's not sure how he feels about her, so she suggests a date to test their compatibility. He agrees, but what happens when his best girl friend Jun spots them together? 01KG9FRP5WK7EFV4543HNB3TG2 2.0 2021-08-10T07:00:00.000Z J-Novel Club LAB_30X9NTZYDFV0 GEO_1PQM5BDYSMG0 She's the Cutest... But We're Just Friends! Volume 2 Copyright (C) 2020 Akamitsu Awamura Illustrations Copyright (C) 2020 mmu   2021-10-06T07: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);