products

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

2 rows where series_id = "CNT_3Q23DD8SBNN0"

✎ 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_0G73GB932Y30 CNT_1RAXATM0R2N0 Our Crappy Social Game Club Is Gonna Make the Most Epic Game CNT_3Q23DD8SBNN0 CNT_3Q23DD8SBNN0 2 2 1 Volume 2 []   Our Crappy Social Game Club Is Gonna Make the Most Epic Game: Volume 2   After overcoming their disbandment woes, the Meikun High School Social Game Club heads toward summer break. On Akane's recommendation, the four of them are slated to participate in a development competition that gathers the best clubs in the country! On top of that, a voice actress who hears of their accomplishments comes along as they pump themselves up for the contest—Yozakura Aina joins the mix. With the five of them, they set out to create a game... or not?! With Kai stuck in a slump and an extraordinary feud between Eru and Aina, development is the last thing on their minds! Will they be able to bring it together and finish a social game?! After overcoming their disbandment woes, the Meikun High Social Game Club pick up a new member and are slated to participate in a top-class development competition! But with Kai slumping and tension among the team, will they manage to pull through?! 01KG9DX2EWDJBSM6Q1G49GDF37 2.0 2021-01-05T08:00:00.000Z J-Novel Club LAB_30X9NTZYDFV0 GEO_1PQM5BDYSMG0 Our Crappy Social Game Club Is Gonna Make the Most Epic Game: Volume 2 Copyright (C) 2020 Oriori Siki Illustrations by Azuri Hyuga   2021-03-22T07:00:00.000Z   0 0
PRD_3JQCTRG2M940 CNT_1T6FN4GQPY8G Our Crappy Social Game Club Is Gonna Make the Most Epic Game CNT_3Q23DD8SBNN0 CNT_3Q23DD8SBNN0 2 2 1 Volume 1 []   Our Crappy Social Game Club Is Gonna Make the Most Epic Game: Volume 1   Past trauma leads Shiraseki Kai to abandon the world of social game development, so he transfers to Maikun High School to start a new life. But on his first day he meets Aoi Nanaka, the president of a low-tier social game club, and finds out that the club is on the brink of disbanding—and is also populated by total weirdos! The programmer, Oushima Aya, is a crazed gacha addict, and the illustrator, Kuroba Eru, faints from the cuteness of her own drawings?! Kai joins the club, which gives them enough members to continue... or so they thought. The student council hands down an ultimatum: "Win a competition against another school or disband!" Now their management talents will really be put to the test. With the skills that he's nurtured and his new set of friends, can Kai face his fears to create the ultimate social game?! Past trauma leads Shiraseki Kai to abandon the world of social game development, so he transfers to Maikun High School to start a new life. But on his first day he meets Aoi Nanaka, the president of a low-tier social game club, and finds out that the club is on the brink of disbanding—and is also populated by total weirdos! The programmer, Oushi... 01KG9CE04KRCG6SVDX94XAEJCA 1.0 2020-10-13T07:00:00.000Z J-Novel Club LAB_30X9NTZYDFV0 GEO_1PQM5BDYSMG0 Our Crappy Social Game Club Is Gonna Make the Most Epic Game: Volume 1 Copyright (C) 2019 Oriori Siki Illustrations by Azuri Hyuga   2021-01-06T08: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);