products

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

3 rows where series_id = "CNT_09R0H1DRX71G"

✎ 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_00E56N9CAYB0 CNT_3A695QZC82X0 The Conditions of Paradise CNT_09R0H1DRX71G CNT_09R0H1DRX71G 2 1 1 Azure Dreams []   The Conditions of Paradise: Azure Dreams   Ruri and Sayaka have always gotten along, but when the two coworkers go out for drinks, Sayaka ends up confessing her love for Ruri! After a drunken hookup, will the two be able to face each other Monday morning? Or is it the start of an office romance? Find out in this collection of seven yuri love stories! Love in the workplace 01KG9DMS7ZVVCS5TVW0T15C91D 3.0 2020-12-21T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Conditions of Paradise: Azure Dreams Akiko Morishima 2009   2021-01-26T08:00:00.000Z   0 0
PRD_0X1WD0HCDF80 CNT_1E0FMDETHHCG The Conditions of Paradise CNT_09R0H1DRX71G CNT_09R0H1DRX71G 2 1 1 The Conditions of Paradise []   The Conditions of Paradise   Sarina and her best friend Sumi are super close. Sumi often crashes at Sarina's place, and sometimes the two even make out a little bit. But Sarina figures a romantic relationship could never work between them. Sarina is an organized office worker, while Sumi is a nomadic freelance writer. Can the two find a way to make their very different lifestyles mesh? A self-contained yuri manga about adult women by the superstar yuri manga artist behind Yuri Bear Storm and Hanjuku Joshi! 01KG9BQPRQHFDTKYTWE5SAZ1F5 1.0 2020-02-07T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Conditions of Paradise Akiko Morishima 2008   2020-03-24T07:00:00.000Z   0 0
PRD_1BFKXCXTP6DG CNT_1A75PZGVYVP0 The Conditions of Paradise CNT_09R0H1DRX71G CNT_09R0H1DRX71G 2 1 1 Our First Time []   The Conditions of Paradise: Our First Time   Sumi has long carried a torch for her best friend Sarina, but she's made peace with the fact that Sarina will never love her back. But as the two women start to blur the lines and kiss, will they go from being friends to lovers? Read their tale and many more sweet yuri love stories in The Conditions of Paradise: Our First Time! Every love story has two sides... 01KG9D5QNFSGQY2MP754ZHR434 2.0 2020-09-09T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 The Conditions of Paradise: Our First Time Akiko Morishima 2013   2020-11-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);