products

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

8 rows where series_id = "CNT_2M0X3KMGT0VG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, on_sale_at, 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_031GP7E1ECKG CNT_1DMHH0STHEGG Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 6 []   Sundome, Vol. 6   With the start of summer comes a pair of daring, alumni-instigated challenges the Roman Club must take on. When an overnight investigation at an abandoned hospital leads to Kurumi and Hideo sharing an intimate night of heavy petting...little do they know they have company . . . in the supernatural form of a GHOST!   01KGB1F2T3K0JY91WFAMMRBXAQ 6.0 2017-02-20T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 6     2017-02-20T15:00:00.000Z   0 0
PRD_169K8457XPPG CNT_2VVJCHEQH8XG Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 7 []   Sundome, Vol. 7   The annual festival marks the end of summer vacation, the last summer vacation Hideo will ever spend with Kurumi. And the last for the ex-prez as well, who will graduate at the end of the year. Eager to prove he still has leadership potential, the ex-prez pushes for one more Roman Club field trip. This time, Hideo and Kurumi aren't the only ones exploring each other in the dark...   01KG9YXQ1CY9P4642NXTP0KZHF 7.0 2017-03-20T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 7     2017-03-20T15:00:00.000Z   0 0
PRD_18H0YKMRHZH0 CNT_1N64NEHQ4HJ0 Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 2 []   Sundome, Vol. 2   Kurumi makes Hideo quit her cold turkey for two weeks! Whatever is poor, horny Hideo to do? Well, for one thing, his club is visited by a masked OB for some hardcore "physical training." Then, there's a UFO-sighting field trip up to a mountain. But Hideo's never quite over his obsession with the precocious transfer student and he thinks he's gotten just a little closer to the object of his affection when he helps her catch a panty-thief. His reward? A trip to the movies... in handcuffs!   01KG9YR4WV9E1X17V44EZY469K 2.0 2016-12-27T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 2     2016-12-27T15:00:00.000Z   0 0
PRD_19S75D31BW2G CNT_0CJZC12PFZ1G Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 4 []   Sundome, Vol. 4   The climax builds as Kurumi says she wants to visit Hideo's house. Now the Aiba family is in an uproar over their son bringing his first girl home!!   01KG9YTNVNFWWM1D5SMCG7GHGX 4.0 2017-01-23T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 4     2017-01-23T15:00:00.000Z   0 0
PRD_21EV8HS6CB30 CNT_2DA819MYQY00 Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 5 []   Sundome, Vol. 5   Hideo is determined to prove his unwavering love and devotion for Kurumi. First, when Hideo gets sick with Kurumi's cold, she comes over to administer treatment in her own special way. The bond between Kurumi and Hideo grows stronger as he struggles to learn even an inch of her past and understand her present situation. Meanwhile, Katsu and Kyouko get closer-even sharing an accidental kiss on the lips! The Roman Club also goes on several adventures, including a trip to a mysterious shrine and another dare at the school at night.   01KGB1F25RNEN5PPT8BQF6N8MG 5.0 2017-02-20T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 5     2017-02-20T15:00:00.000Z   0 0
PRD_3008QVT2ZP70 CNT_1R6VX8KK8SC0 Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 8 []   Sundome, Vol. 8   As summer turns to fall, Kurumi's condition takes a turn for the worse. Hideo comforts her as only Hideo can, but even he cannot ignore the signs of what is to come. Remembering his promise to take Kurumi to see the wave flowers, Hideo and the Roman Club rally their efforts to make her dream come true.   01KG9YXQH026RQGRPR6J7KA6Q5 8.0 2017-03-20T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 8     2017-03-20T15:00:00.000Z   0 0
PRD_3E6FZQJ69WJ0 CNT_1C7NWBXTMEH0 Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 3 []   Sundome, Vol. 3   More torture, teasing, and humiliation from Kurumi ensues, but Hideo's crush on his tormentor only worsens! When nasty rumors start flying about Kurumi's promiscuity, Hideo finds the source and sets things straight. But even he can't explain the mysterious pair of men's shoes in her apartment. Meanwhile, the Roman Club accepts a bet from the sneaky class president which involves wandering through a haunted graveyard and playing a creepy game of hide-and-seek in the school after dark. And the love bug launches a surprise attack on Hideo's Roman Club crony Tatsuya when he stands up for the buxom Kyouko who's sick and tired of being abused by her boyfriend.   01KG9YTNCXQTQSNWZBN6DBMQ59 3.0 2017-01-23T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 3     2017-01-23T15:00:00.000Z   0 0
PRD_3EY8QW7XZY0G CNT_2MVV4QCVD13G Sundome CNT_2M0X3KMGT0VG CNT_2M0X3KMGT0VG 2 1 1 Volume 1 []   Sundome, Vol. 1   The "Roman Club," a school group interested in the occult, to which he's practically enslaved, has become boring for one Hideo Aiba. In fact, he finds his entire existence pretty tiresome until, one day, when a girl named Kurumi Sahana shows up and wants to join up. When the two are left alone in the club classroom, Kurumi makes a special "request" of Hideo, which makes him (understandably) freak out. Though he doesn't know what to think, one thing's for sure, Hideo's life just became anything but boring.   01KG98JG3CZMSYA4TVB8A557T4 1.0 2016-12-27T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QR2G8X6B6CG Sundome, Vol. 1     2016-12-27T15: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);