products

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

6 rows where series_id = "CNT_244WAQNMHFK0"

✎ 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_0NDDD6YQMGJ0 CNT_1S8HS0MD9THG Psycome CNT_244WAQNMHFK0 CNT_244WAQNMHFK0 2 2 1 Volume 1 []   Psycome, Vol. 1   Accused of a crime he didn't commit, Kyosuke Kamiya is sent to Purgatorium Rehabilitation Academy. Suddenly, he's surrounded by a variety of fetching lasses--each one a murderer! Worse, he's famous for being the "Dozen Demon," a killer responsible for twelve deaths! When the busty, gas mask-wearing beauty Renko Hikawa approaches him, the difference between death and desire becomes very narrow indeed. How is Kyosuke gonna graduate alive?   01K5G9W2E2SY9THQNCFWZ3P8TM 1.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Psycome, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_1AB4D497VW30 CNT_13DDPCH8A840 Psycome CNT_244WAQNMHFK0 CNT_244WAQNMHFK0 2 2 1 Volume 6 []   Psycome, Vol. 6   The school festival has arrived, and the students of Class A are putting together a maid cafe. Renko Hikawa returns to the school after collapsing in her fight against Kyousuke at the athletics festival, and she's looking forward to a school life even more enjoyable than before. When Renko's parents visit for the festival, they're even more determined to put an end to the relationship between their daughter and Kyousuke--by demanding him to drop out of school! With both the school's deadly exams and Renko breathing down his neck, will Kyousuke finally sort out his feelings for the Murder Maid?   01KGA1DR0HJ02F6VPHMT7EA6G1 6.0 2018-02-27T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Psycome, Vol. 6     2018-02-27T08:00:00.000Z   0 0
PRD_1H870Q86QZM0 CNT_0HE0YCBGER90 Psycome CNT_244WAQNMHFK0 CNT_244WAQNMHFK0 2 2 1 Volume 5 []   Psycome, Vol. 5   Even cutthroat murderers have school athletics festivals! Aiming for the top place in the school's first murderathon, Kyousuke and his classmates suffer through backbreaking conditioning. His life gets even more complicated when Renko's mother, Reiko Hikawa, pays a visit. She gives the pair an ultimatum: if their class doesn't win the athletics festival, Kyousuke and Renko can't get married! Can he sort out his ambiguous feelings for Renko while surviving the upperclassmen's bloodlust?   01KG9ZDY0YMWA1A6G4MVGFYSCT 5.0 2017-10-31T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Psycome, Vol. 5     2017-10-31T07:00:00.000Z   0 0
PRD_2EXXMCE3RMW0 CNT_1ZAYMMCX5XH0 Psycome CNT_244WAQNMHFK0 CNT_244WAQNMHFK0 2 2 1 Volume 4 []   Psycome, Vol. 4   BRUTAL SUMMER LOVIN'...Summer break has arrived for the students with the highest exam scores, but it looks like Kyousuke will be stuck in school... However, when Eiri is suddenly summoned home, Kyousuke discovers her family has asked for him, too! He worries his stay with House Akabane, a family of assassins, will be a dangerous one, and Eiri isn't enthusiastic to return home. Surprisingly, they're met with a warm reception! ...So then why does Eiri look so sullen? The sweet, summery fourth volume heats up in the romantic comedy where the more Kyousuke loves, the more dangerous his life becomes!   01KG9Z4C1AAM8ENJ9M27KF0ERJ 4.0 2017-06-19T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Psycome, Vol. 4     2017-06-19T15:00:00.000Z   0 0
PRD_2QBBX59S2XWG CNT_37GMYKZRJ07G Psycome CNT_244WAQNMHFK0 CNT_244WAQNMHFK0 2 2 1 Volume 3 []   Psycome, Vol. 3   As the final exams for parole draw near, suddenly a transfer student appears! And the newcomer is none other than Kyousuke's little sister, Ayaka Kamiya! Ayaka could not be happier with this reunion but Kyousuke is terrified. What's more, he soon finds out that for the sake of meeting her beloved brother, Ayaka committed attempted murder. Considering Ayaka's mental state, Kyousuke resolves himself to protect her from the pack of killers he calls classmates. But, if someone, let's say Renko, were to find out that Kyousuke's most important 'Ayaka' is his sister, there'll be hell to pay... Facing dangers left and right, Kyousuke will have to be more resourceful than ever to get himself-and his sister-out in one piece.   01KG9YVWHP69NYAV0BZ0YXRGPA 3.0 2017-02-20T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Psycome, Vol. 3     2017-02-20T15:00:00.000Z   0 0
PRD_3RMXT1M3W990 CNT_3HTDK2AV1WA0 Psycome CNT_244WAQNMHFK0 CNT_244WAQNMHFK0 2 2 1 Volume 2 []   Psycome, Vol. 2   Kyousuke Kamiya has only just started to get used to his life in the blood-spattered hellscape that is Purgatorium Remedial Academy and its twisted version of school life. The architect of this series of gruesomely parodic extracurricular activities is the beautiful, charming Saki Shamaya--also known as the "Princess of Murder," a serial killer responsible for twenty-one deaths!   01KG988K3EKN1P9K2Y4PYPBYTM 2.0 2016-10-24T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Psycome, Vol. 2     2016-10-24T15: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);