products

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

3 rows where series_id = "CNT_2TQ9YGNJNV80"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_2HJNW042QX8G CNT_2WXM12SHD0CG Magical Girl Incident CNT_2TQ9YGNJNV80 CNT_2TQ9YGNJNV80 2 1 1 Volume 2 []   Magical Girl Incident, Vol. 2   Office worker Hiromi Sakura only recently discovered that he can turn into a magical girl—and now he’s leaping off a paramilitary helicopter and fighting an unsettling schoolgirl in the clouds! And as if things couldn’t get more off-kilter, who’s this dashing, caped protector asking Hiromi to call him “senpai”?! But bizarre as these encounters are, they could be a chance for Hiromi to learn more about his new identity, including what special powers lie within…   01KGB6DVGY8TQDT9WQAEQC6MS4 2.0 2023-04-24T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Magical Girl Incident, Vol. 2     2023-09-19T00:00:00.000Z   0 0
PRD_2KM7GWN53QK0 CNT_11GCPGRN6KK0 Magical Girl Incident CNT_2TQ9YGNJNV80 CNT_2TQ9YGNJNV80 2 1 1 Volume 1 []   Magical Girl Incident, Vol. 1   Every child has a dream job, and for Hiromi Sakura, it was being a hero like his favorite color-coded defenders of justice. Unfortunately, not all wishes come true, and now he’s forever stuck with a miserable desk job—until one evening, when he steps up to save a little girl’s life. With his newfound courage and strength to fight evil, Hiromi transforms…into a magical girl?!   01KGB4QWD49PEJ7J9NNF4XW2D8 1.0 2023-02-07T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Magical Girl Incident, Vol. 1     2023-05-23T00:00:00.000Z   0 0
PRD_3WM8WQH6PZZG CNT_1N1GKRDE72XG Magical Girl Incident CNT_2TQ9YGNJNV80 CNT_2TQ9YGNJNV80 2 1 1 Volume 3 []   Magical Girl Incident, Vol. 3   The investigation into the girl in the black school uniform continues! Having just become a Waltz through a life-threatening confrontation with Misaki Suga, the first thing Yuzuru Saotome does is…propose to Hiromi?! With a new magical girl on their side, the team is once again hot on Misaki’s trail as they unravel Yuzuru’s hidden past and the truth behind Misaki’s existence. But when all is said and done, can Hiromi step up to the plate and become the hero of his dreams…?   01KGBBWK8S8WNVNEF350X6QCMC 3.0 2024-07-12T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Magical Girl Incident, Vol. 3     2024-12-10T08: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);