products

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

5 rows where series_id = "CNT_0TQGATKP46S0"

✎ 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_08NZ4Y5WJ9Q0 CNT_3AF8Y2J1H3FG Days on Fes CNT_0TQGATKP46S0 CNT_0TQGATKP46S0 2 1 1 Volume 2 []   Days on Fes, Vol. 2   After making their music festival debut, Kanade and Otoha set off to take part in their first overnight event-the massive Rock On Japan Festival. Along with a slew of their favorite bands, they get to enjoy all-new thrills like camping, barbecue, tents, and even a hot spring?! This summer is set to be the best ever!   01KG9FHN0CXXEVEFQXMWMYVAGB 2.0 2021-05-26T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Days on Fes, Vol. 2     2021-07-13T07:00:00.000Z   0 0
PRD_0GQN9W0S6FD0 CNT_2TCMRF6SK5SG Days on Fes CNT_0TQGATKP46S0 CNT_0TQGATKP46S0 2 1 1 Volume 5 []   Days on Fes, Vol. 5   <P>Kanade and Otoha score tickets to the Countdown Festival&mdash;a massive indoor event to ring in the new year! Surrounded by boisterous friends, good food, and their favorite tunes, the gang reflect on their past experiences and discover new dreams for the future. The festival season may be ending, but the party doesn&rsquo;t stop in this final volume of <I>Days on Fes</I>!</P>   01KGAEZV3GW5M66P5SWY1CF821 5.0 2022-03-30T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Days on Fes, Vol. 5     2022-04-26T00:00:00.000Z   0 0
PRD_19FCTJWEQ9E0 CNT_249K2YJ5TDT0 Days on Fes CNT_0TQGATKP46S0 CNT_0TQGATKP46S0 2 1 1 Volume 1 []   Days on Fes, Vol. 1   Kanade Sora has never been to a music festival before. But when her friend Otoha lures her along with the promise that her favorite band will be playing, she finds herself having more fun than she ever imagined. And if one small show is enough to hook her, what might a huge overnight event at a major venue be like? As Kanade dives into a whole new world of rocking out, will her life ever be the same?!   01KG9E2TX1EEKXNN526J9KM9A7 1.0 2021-01-28T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Days on Fes, Vol. 1     2021-02-23T08:00:00.000Z   0 0
PRD_1T1RKSJNW3G0 CNT_2VKT6AF3KPRG Days on Fes CNT_0TQGATKP46S0 CNT_0TQGATKP46S0 2 1 1 Volume 3 []   Days on Fes, Vol. 3   When Mero Fukagawa-a classmate with a crush on Kanade-invites her and Otoha to attend Ultima Rock Fest in Shibuya, it’s the girls’ first time at an urban music festival. With the opportunity to visit a bevy of smaller venues and get closer to the bands than ever before, this event is a far cry from the outdoor performances they’ve experienced. Mero is actually playing at the festival himself (and he hopes to show Kanade his best side), but his competition is stiff: Kanade’s favorite band, Daze on Youth, is also there!   01KG9FS98BMJZJ14AHXEK0GMHP 3.0 2021-08-27T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Days on Fes, Vol. 3     2021-09-28T07:00:00.000Z   0 0
PRD_3P3Y38NSSAGG CNT_0N6CHDQZMYKG Days on Fes CNT_0TQGATKP46S0 CNT_0TQGATKP46S0 2 1 1 Volume 4 []   Days on Fes, Vol. 4   Take a peek into the past as Gaku recalls his first music festival! After stumbling upon a caf&eacute; that shares his name, he&rsquo;s invited by the elderly owner to come along to an overnight camping festival. Gaku doesn&rsquo;t know what to expect, but his heart is stolen by the sights and sounds he finds there&hellip;!   01KG9HFE1ZVPRG6FXP0NRVEG41 4.0 2021-12-09T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Days on Fes, Vol. 4     2022-02-08T00: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);