products

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

3 rows where series_id = "CNT_3YA5Z17ZMY00"

✎ 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_0FW9H63N68H0 CNT_3PVR9J5CFTJ0 Genshiken Omnibus CNT_3YA5Z17ZMY00 CNT_3YA5Z17ZMY00 2 1 1 Volume 2 []   Genshiken Omnibus 2   YES WE CAN? ? When Madarame resigns from office as president of Genshiken, he selects Kanji as the best candidate to take his place. As the new president, Kanji attempts to shake the sluggish members of Genshiken out of their apathy by proposing they create a fanzine to sell at the next Comic-Fest. When Genshiken is accepted as an official vendor at the summer Comic-Fest, they find themselves with a deadly short deadline to create a real doujinshi. Can President Sasahara get his slacker constituents to level up their productivity?   01KG996YZ1ZFXY6EP7KH1PFBB0 2.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Genshiken Omnibus 2 (C) Shimoku Kio / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_29Q1RXGQR81G CNT_2Q61Y9A89B2G Genshiken Omnibus CNT_3YA5Z17ZMY00 CNT_3YA5Z17ZMY00 2 1 1 Volume 3 []   Genshiken Omnibus 3   OTAKU FOREVER ? The Genshiken have plenty of adventures to experience in the short amount of time before the end of the term.? Madarame falls under the spell of the beautiful Angela, an American otaku visiting with her rude friend Susie.? The two girls test just how much chaos they can cause during their short trip. The Genshiken girls try out their matchmaking skills on Kanji and Ogiue, though Ogiue worries what he'll think when he reads her shocking doujinshi in which he is the starring character.? As Kanji, Kousaka and Saki near graduation, tensions are high as the Genshiken prepare for their biggest celebration ever!   01KG996ZCQA0KB16PQDS0657PG 3.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Genshiken Omnibus 3 (C) Shimoku Kio / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_2C5GBGJT4Q0G CNT_0PGYSV0GMA3G Genshiken Omnibus CNT_3YA5Z17ZMY00 CNT_3YA5Z17ZMY00 2 1 1 Volume 1 []   Genshiken Omnibus 1   TO THINE OWN OTAKU BE TRUE ? It's spring of freshman year, and Kanji Sasahara has a difficult dilemma. Should he declare his love for manga and anime fandom by? joining an otaku club, like he has always wanted to? Is he prepared to deal with the social stigma attached to being an otaku? Meanwhile, Saki Kasakabe has her own otaku conundrum. How can she turn her boyfriend, anime fanboy Makoto, into a normal guy? Kanji follow his heart as does Saki. When both Kanji and Makoto join Genshiken: The Society for the Study of Modern Visual Culture, Saki chases Makoto through the various activities of the club from costume-playing and comic conventions, to video gaming and anime model figures. Saki finds otaku to be more than she imagined, but not necessarily in a good way. ? Includes special extras after the story!   01KG9373207CD3HK7KECR4MD0Y 1.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Genshiken Omnibus 1 (C) Shimoku Kio / Kodansha Ltd.   2016-10-25T07: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);