products

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

6 rows where series_id = "CNT_0GWR4XETGWR0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, 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_0GFP466Z75S0 CNT_2378E2WVYBDG Twilight Out of Focus CNT_0GWR4XETGWR0 CNT_0GWR4XETGWR0 2 1 1 Volume 1 []   Twilight Out of Focus 1   Second-years Mao Tsuchiya and Hisashi Otomo make three promises: 1) That Mao will never tell anyone that Hisashi is gay and has a boyfriend, 2) That Hisashi will never think of Mao in that way, and 3) That they'll always knock before entering, in case someone is having some private time. The two's ground rules should ensure a peaceful life together in their dorm, but life is never as simple as it should be, and some things are not so easily promised...   01KGAF35ZM7D261DSKXEKJCA15 1.0 2022-02-08T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Twilight Out of Focus 1 Twilight Out of Focus Jyanome/Kodansha Ltd.   2022-03-01T08:00:00.000Z   0 0
PRD_0W6SBRQB711G CNT_0XRBEWKRDMVG Twilight Out of Focus CNT_0GWR4XETGWR0 CNT_0GWR4XETGWR0 2 1 1 Volume 5: Long Take Part 1 []   Twilight Out of Focus 5: Long Take Part 1   Winter is coming for roommates-turned-lovers Mao and Hisashi, bringing with it a whole slew of unexpected challenges-and a noted cooling in their relationship that makes Mao wonder if it really is as strong as it once seemed. To make matters worse, this period of transition before their final year of high school has also shaken up the one constant Mao had always relied on: film. Weighed down by such uncertainty, will the two manage to find something solid to see them through a season of darkness, or will the curtain fall on their romance for good?   01KGBC6PJ6N30Y7HQGKRV2T0X6 5.0 2024-08-27T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Twilight Out of Focus 5: Long Take Part 1 Jyanome/Kodansha Ltd.   2024-09-17T07:00:00.000Z   0 0
PRD_19RKX1GR0MQG CNT_3ZY3B1E0XYMG Twilight Out of Focus CNT_0GWR4XETGWR0 CNT_0GWR4XETGWR0 2 1 1 Volume 3: Overlap []   Twilight Out of Focus 3: Overlap   What happens when roomates-turned-lovers turn into viral sensations? And what if your happily-ever-after has an expiration date...? It's been three months since roommates Mao and Hisashi took their relationship to the next level, and Mao couldn't be more in love...or more nervous that he's not doing enough to keep his experienced partner satisfied. Just when it seems like he may have figured things out, the film club's movie goes viral, and suddenly everyone wants a piece of its breakaway star: Hisashi. With graduation right around the corner, Mao must find a way to keep them together or risk leaving their future to the uncertain tides of fate.   01KH3G50XKG5THBARHYSWGY2Z3 3.0 2023-08-29T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Twilight Out of Focus 3: Overlap Jyanome/Kodansha Ltd.   2023-09-19T07:00:00.000Z   0 0
PRD_213VETXZZTK0 CNT_1MG07RGVF98G Twilight Out of Focus CNT_0GWR4XETGWR0 CNT_0GWR4XETGWR0 2 1 1 Volume 2: Afterimages in Slow Motion []   Twilight Out of Focus 2: Afterimages in Slow Motion   Jin, third-year director, lead actor, and president of the film club, and second-year director Giichi see eye-to-eye on very little. Jin is flashy, flirty, and focused on keeping everyone happy, while Giichi expects the best from himself and others, and will compromise nothing to see his vision through. Constantly at each other's throats, the two can hardly stand to be in the same club. But what will happen when family trouble forces them to share the same dorm room? Will their common interests bring them closer as friends, push them further apart as rivals-or something else entirely?   01KH3EDJF0S7NEVDV7T7FK8KKX 2.0 2023-06-20T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Twilight Out of Focus 2: Afterimages in Slow Motion Jyanome/Kodansha Ltd.   2023-07-11T07:00:00.000Z   0 0
PRD_37DW6XT9FW4G CNT_2G07RWMZ3C20 Twilight Out of Focus CNT_0GWR4XETGWR0 CNT_0GWR4XETGWR0 2 1 1 Volume 6: Long Take Part 2 []   Twilight Out of Focus 6: Long Take Part 2   Amidst the anxieties of preparing for his final year in high school, film club cameraman Mao plucks up his courage and asks his boyfriend Hisashi to take a big step forward in their relationship. But what seemed like a great idea at first leads to a whole series of other questions that leave Mao at a loss and the two at a crossroads. And just when they most need some quality time together, Mao and Hisashi are forced to split up for a school field trip that threatens to disrupt their connection-and attracts unexpected attention from a clandestine figure lurking in the shadows.   01KG9Q3VTFXZ1HKTY7NPKZ4XG2 6.0 2025-02-06T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Twilight Out of Focus 6: Long Take Part 2 Jyanome/Kodansha Ltd.   2025-02-18T08:00:00.000Z   0 0
PRD_3S173JH7EVNG CNT_2XSQ43DZSNAG Twilight Out of Focus CNT_0GWR4XETGWR0 CNT_0GWR4XETGWR0 2 1 1 Volume 4: The Evening Monologues []   Twilight Out of Focus 4: The Evening Monologues   The Midorigaoka High School Film Club's ­new­est member Shion Yoshino knows exactly what he wants, and he's not afraid to work for it. There's just one catch: it has nothing to do with film. Shion's looking for the picture-­perfect Prince Charming, and he'll do whatever it takes to find him, even if that means joining a club full of nerds. He announces his intentions on his very first day in the group, only for the club's former Vice President, Rei Inaba, to make a stunning declaration: "I can promise you, 100%, you won't find a boyfriend here." Not long after, however, it's Rei himself who kisses Shion and asks him out! What does it all mean? One thing is for certain: Shion Yoshino won't give up on his dream without a fight!   01KGATAHMV5F77VQ4GQN0FA9WB 4.0 2023-11-28T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Twilight Out of Focus 4: The Evening Monologues Jyanome/Kodansha Ltd.   2023-12-19T08: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);