products

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

4 rows where series_id = "CNT_3CSBBV1QB1A0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_0C6MEV2WVJV0 CNT_32Q9Z2V3ZXVG Little Miss P CNT_3CSBBV1QB1A0 CNT_3CSBBV1QB1A0 2 1 1 Little Miss P []   Little Miss P   It’s that time of month, and you know what that means…a visit from Little Miss P! She always seems to show up at just the wrong time, generally armed with a heavy dose of fatigue and poised to deliver a barrage of beatings that leave her hosts physically and mentally exhausted. Though Little Miss P is often met with dread and resignation, the realities of a woman’s period are widely misunderstood—especially by those who haven’t been subjected to her gut punches on a monthly basis. Join Little Miss P—along with Mr. Libido, Mr. Virginity, and Little Miss PMS—as she visits women in a variety of circumstances, advising, harassing, comforting, and delivering more than one obligatory PERIOD PUNCH in this humorous, heartwarming collection!   01KGA60MRQK8K2YG09784SG9ZK 1.0 2019-06-25T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Little Miss P     2019-06-25T07:00:00.000Z   0 0
PRD_1WERH27CZF8G CNT_1N67TJN1CMB0 Little Miss P CNT_3CSBBV1QB1A0 CNT_3CSBBV1QB1A0 2 1 1 The Second Day []   Little Miss P: The Second Day   Like clockwork, Little Miss P has stopped by for another one of her energy-sapping, gut-twisting monthly visits! Despite the difficulties brought about by her arrival, women around the world—and galaxy—must find ways to cope with her (ir)regular visits, a task made easier by the support and understanding of those who care about them. Through frank discussion and a heavy flow of humor, this collection follows Little Miss P as she calls on women from all walks of life. No pop star, action hero, or office worker is exempt from Little Miss P’s formidable PERIOD PUNCH!   01KG9BM0QJSYEZQXM1WWHVK0F1 2.0 2020-05-21T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Little Miss P: The Second Day     2020-06-23T07:00:00.000Z   0 0
PRD_1WQ0RAMGG6V0 CNT_2BFYPRSNTT5G Little Miss P CNT_3CSBBV1QB1A0 CNT_3CSBBV1QB1A0 2 1 1 Volume 3 []   Little Miss P, Vol. 3   The pain, fatigue, and discomfort that so often accompany her visits make Little Miss P nigh impossible to ignore, but much of society prefers to do just that. Struggling to maintain “business as usual,” many of her weary hosts stockpile painkillers and hygiene products, often leaving their friends, coworkers, and even lovers blissfully unaware of the not-so-Little Miss P repeatedly punching them in the gut!   01KG9GGEP881QHH99FSJ8DH4NZ 3.0 2021-07-27T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Little Miss P, Vol. 3     2021-08-31T07:00:00.000Z   0 0
PRD_2AS92XGEZYQG CNT_0B3Y5GGNC460 Little Miss P CNT_3CSBBV1QB1A0 CNT_3CSBBV1QB1A0 2 1 1 Volume 4 []   Little Miss P, Vol. 4   She never really leaves. Not really. All anyone can learn to do is live with Little Miss P. Like the girls who make a living on their backs. Or the model facing her own battles. Even the elementary school girls just starting their adventures with Little Miss P. So don’t miss out on Little Miss P’s last words of wisdom in the final volume!   01KGAEYMXFQZP4H9329W97F144 4.0 2022-03-17T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Little Miss P, Vol. 4     2022-04-05T00: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);