products

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

3 rows where series_id = "CNT_3JG4WHYB4090"

✎ 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_0KCZ5V3NQDPG CNT_0E7JA2BMD9RG Last Gender CNT_3JG4WHYB4090 CNT_3JG4WHYB4090 2 1 1 Volume 2 []   Last Gender 2   Ever felt as if there's no place for you in this world? BAR California. A secluded establishment where people of various genders, propensities, and sexual orientations gather in search of love, sex, and fulfillment. In this installment, Rei Taki tells the story of a young man who loses his same-sex partner to the harshness of society, a lithromantic woman who's scared of getting her feelings reciprocated, and a cross-dresser who has a secret she'll never share...   01KGB2TYK7Z6JP38TQ0FRBZDHA 2.0 2022-12-23T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Last Gender 2 Rei Taki/Kodansha Ltd.   2023-01-11T08:00:00.000Z   0 0
PRD_2BE5B9MW6HK0 CNT_2XB37GNPNG8G Last Gender CNT_3JG4WHYB4090 CNT_3JG4WHYB4090 2 1 1 Volume 3 []   Last Gender 3   A never-ending search for who we are BAR California is a secluded sex bar that welcomes people of all genders, propensities, and sexual orientations. For some, it's the only place where they're free to be themselves. For others, it's a place for self-discovery. The mysterious young woman who runs the establishment, Yo, quietly watches over the patrons every evening. No one seems to know much about her. But when a new part-timer accidentally walks into her room, her past-and how the bar came to be-is gradually revealed. The final installment of Rei Taki's intricate and deeply moving series. Her words will touch you to the core!   01KGB6JQC5RS8JW94P0BHYKRKT 3.0 2023-05-23T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Last Gender 3 Rei Taki/Kodansha Ltd.   2023-06-13T07:00:00.000Z   0 0
PRD_2WSZXJCD7430 CNT_2PGBKN7QD1BG Last Gender CNT_3JG4WHYB4090 CNT_3JG4WHYB4090 2 1 1 Volume 1 []   Last Gender 1   Welcome to BAR California, a place for you to reveal your true self People of different genders, propensities, and sexual orientations gather at a certain chic bar that's hidden from the public eye. While some come in search of themselves, others step into the establishment looking for sex and love. There are as many sexualities as there are people, and the patrons' stories intertwine as they struggle to find happiness. A bisexual trans woman who's been hurt by the voices of others wishes she had a "normal" relationship; a married, middle-aged salaryman secretly expresses his female side; and a pansexual cis guy is on the lookout for true love.   01KGAK2XGMQBNBRBV6WDDG07VQ 1.0 2022-10-04T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Last Gender 1 Last Gender Rei Taki/Kodansha Ltd.   2022-10-11T07: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);