products

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

3 rows where series_id = "CNT_11C900MJN96G"

✎ 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_1GKFJPEQ6JH0 CNT_2WDQGN1T43BG Primitive Boyfriend CNT_11C900MJN96G CNT_11C900MJN96G 2 1 1 Volume 1 []   Primitive Boyfriend Vol. 1   Seventeen-year-old Kamigome Mito yearns for romance, but the boys in her school all share the same flaw--they're hopeless wimps! When Mito prays for divine intervention, Spica, goddess of the harvest, sends her back in time to find a soulmate. The destination? Planet Earth, 2.5 million years ago! My Honey is a Hominid 01KG9BSK77GB3R5NW06ZQ6VWMM 1.0 2020-03-23T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1M4TGE93G35G Primitive Boyfriend Vol. 1 Yoshineko Kitafuku 2017   2020-04-07T07:00:00.000Z   0 0
PRD_1N0J4VR9T57G CNT_3BGWBZ6SGTC0 Primitive Boyfriend CNT_11C900MJN96G CNT_11C900MJN96G 2 1 1 Volume 2 []   Primitive Boyfriend Vol. 2   Unable to forget Garhi, the soulmate she met 2.5 million years ago, Mito returns to the past, thanks to the power of the goddess Spica! This time, she encounters a whole group of primitive humans--but they're a far cry from Garhi. So Mito, along with a curious new companion, sets out through the untamed jungle to find the man of her dreams... LOOKING FOR MR. RIGHT 01KGA98ZYM8JE72T9KNCWFECQW 2.0 2020-05-28T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1M4TGE93G35G Primitive Boyfriend Vol. 2 Yoshineko Kitafuku 2018   2020-07-21T07:00:00.000Z   0 0
PRD_33BCQQXHT69G CNT_239ZZDT66VA0 Primitive Boyfriend CNT_11C900MJN96G CNT_11C900MJN96G 2 1 1 Volume 3 []   Primitive Boyfriend Vol. 3   Kamigome Mito understands at last that her soul and Garhi's are bound across time. Taking fate into her own hands, Mito travels back to Japan's prehistoric Jomon period, where she meets a young hunter-gatherer bearing the same mark as Garhi. But will the universe allow her to be with the man of her dreams? This epic love story, spanning 2.5 million years, reaches its thrilling conclusion! A DATE WITH DESTINY 01KG9DA54WEVY9MF3SETE4N7SA 3.0 2020-10-15T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1M4TGE93G35G Primitive Boyfriend Vol. 3 Yoshineko Kitafuku 2018   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);