products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
12 rows where series_id = "CNT_3KM9SVX18TC0"
This data as json, CSV (advanced)
Suggested facets: description, 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_13869TY550RG | CNT_16A733ATCJVG | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 1 | [] | Arisa 1 | Twin sisters, Arisa and Tsubasa, are separated by their parents' divorce. The twins secretly exchange letters during their separation. Finally reunited after three years, Arisa asks Tsubasa to pretend to be her and spend a day in her school just for fun. At school everyone seems very nice to Tsubasa (who is pretending to be Arisa) and everything seemed normal... until she finds a strange note in her sister's shoe locker. When Tsubasa hands over the letter to Arisa, Arisa tries to kill herself. Arisa survives but remains in a coma. The letter read, ""Arisa is a traitor."" Determined to unravel the mystery behind the act and the letter, Tsubasa decides to investigate... | 01KG936VGJE9GT4Z26K6K4J6Y0 | 1.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 1 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_1H65PD7CN4MG | CNT_150K1AKRRPZG | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 9 | [] | Arisa 9 | THE ACTION HEATS UP! ? Having collected all of King's cell phones, Kudo now rules over his classmates with terror! In a terrible act of vengeance, he enacts his final dastardly plot by setting a house on fire. As the blaze threatens to destroy everything, Kudo's classmates are all hunting for the identity of the King! | 01KG9964MV12JMN3SDDG0S05B4 | 9.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 9 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_1JHN4T5A95NG | CNT_35P61RXGDQYG | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 11 | [] | Arisa 11 | A CRUEL ROYAL HISTORY Tsubasa thought she'd finally reconciled with her sister, only to watch her go back to Midori's side! Shocked and confused, Tsubasa heads to Midori's hometown, desperate for answers. But while she spends her time digging up the past, the King's schemes continue to fester! Who will be his next victim? | 01KG99664PC20W5WAADNM7HZQE | 11.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 11 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_1NMM100PH3VG | CNT_34B00M817NRG | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 7 | [] | Arisa 7 | Tsubasa thinks that her pretty and popular twin sister, Arisa, has the perfect life. Everyone at school loves Arisa-unlike the hot-tempered Tsubasa, whose nickname is ""The Demon Princess."" But when Arisa attempts suicide, Tsubasa learns that her seemingly perfect sister has been keeping some dark secrets. Now Tsubasa is going undercover at school - disguised as Arisa - insearch of the truth. But will Arisa's secrets shatter Tsubasa's life, too? K = THE KING?! While pretending to be Arisa, Tsubasa has promised to meet with the person known only s ""K"" - someone who may or may not hold the secret to the King's identity. Will Tsubasa wander into a trap or will she come one step closer to unmasking the King? Includes special extras after the story! | 01KG9963QCJKH7QGSWQ4R0SS9P | 7.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 7 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_1R57CK2RX2TG | CNT_17NX07Y9JMSG | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 5 | [] | Arisa 5 | Tsubasa thinks that her pretty and popular twin sister, Arisa, has the perfect life. Everyone at school loves Arisa-unlike the hot-tempered Tsubasa, whose nickname is ""The Demon Princess."" But when Arisa attempts suicide, Tsubasa learns that her seemingly perfect sister has been keeping some dark secrets. Now Tsubasa is going undercover at school - disguised as Arisa - insearch of the truth. But will Arisa's secrets shatter Tsubasa's life, too? THE KING... IS ON MY SIDE NOW Twin sisters, Arisa and Tsubasa, are separated by their parent's divorce. But after her sister's suicide attempt, Tsubasa is determined to go undercover and unravel the conspiracy behind the elusive King. But, right now, the King's wish granting abilities may have fallen into the wrong hands... and the results may prove to be deadly to Tsubasa and Class 2B! Includes special extras after the story! | 01KG9961M22CATXNP1WCCGB202 | 5.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 5 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_1WVQY7W2S1SG | CNT_370A3HMJ1KTG | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 3 | [] | Arisa 3 | Tsubasa thinks that her pretty and popular twin sister, Arisa, has the perfect life. Everyone at school loves Arisa-unlike the hot-tempered Tsubasa, whose nickname is ""The Demon Princess."" But when Arisa attempts suicide, Tsubasa learns that her seemingly perfect sister has been keeping some dark secrets. Now Tsubasa is going undercover at school - disguised as Arisa - insearch of the truth. But will Arisa's secrets shatter Tsubasa's life, too? IN THE SHADOW OF THE MOON Tsubasa hunt for The King thickens when Arisa's class goes to a planetarium to watch an eclipse and The King makes a decree that turns the chosen against each other. Later, suspicion mounts on Midori, who asks Tsubasa on a date! Can Tsubasa save the day from The King, and protect the stars in her sister's sky from ill fates? Includes special extras after the story! | 01KG9960BJ99BGRXY3BEWZHV8A | 3.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 3 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_2C82KHT5B560 | CNT_221FHP2C78D0 | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 12 | [] | Arisa 12 | DETHRONE THE KING! ? The global elite has gathered for a Christmas summit, and the King's final revenge on the world that rejected him is almost at hand! All Tsubasa can do is grab the bomb and run - but how far will she get before time runs out? And will Arisa and Tsubasa be able to forget the betrayals and go back to being loving sisters again? ? THE THRILLING FINAL VOLUME! | 01KG9966JFKTX754YGBBVTAKZ8 | 12.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 12 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3GYXX4MFQ450 | CNT_05BWH1RMJ7E0 | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 10 | [] | Arisa 10 | THE SECRET OF KING TIME REVEALED! ? Tsubasa's beloved twin sister Arisa is awake - but wants her eliminated by the King! Reeling from Arisa's betrayal, Tsubasa falls right into a trap set by ""King"" Midori. The clocks tick as Tsubasa awaits her demise. Will this be her final King Time? | 01KG99655P626A4CCEH7X4W9XD | 10.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 10 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3QFC8QHHK340 | CNT_24P9GKEX16F0 | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 8 | [] | Arisa 8 | THE ACTION HEATS UP! ? Having collected all of King's cell phones, Kudo now rules over his classmates with terror! In a terrible act of vengeance, he enacts his final dastardly plot by setting a house on fire. As the blaze threatens to destroy everything, Kudo's classmates are all hunting for the identity of the King! | 01KG996467TGCH00NSMYJZGW1G | 8.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 8 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3VXWTAKVZ2B0 | CNT_0406GX35C580 | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 6 | [] | Arisa 6 | Tsubasa thinks that her pretty and popular twin sister, Arisa, has the perfect life. Everyone at school loves Arisa-unlike the hot-tempered Tsubasa, whose nickname is ""The Demon Princess."" But when Arisa attempts suicide, Tsubasa learns that her seemingly perfect sister has been keeping some dark secrets. Now Tsubasa is going undercover at school - disguised as Arisa - insearch of the truth. But will Arisa's secrets shatter Tsubasa's life, too? FRIEND OR ENEMY?! Shizuka, confined to a wheelchair, blames her misfortune on Arisa. Will she seek revenge using the King's cell phone? Can Tsubasa defend Arisa against Shizuka, and get the information about the King? Or does the King have something far more sinister in store? Includes special extras after the story! | 01KG99639K0ND6N8ST1XCH5NK2 | 6.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 6 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3X0ZGGF07090 | CNT_06N0KTFP63A0 | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 2 | [] | Arisa 2 | Tsubasa thinks that her pretty and popular twin sister, Arisa, has the perfect life. Everyone at school loves Arisa-unlike the hot-tempered Tsubasa, whose nickname is ""The Demon Princess."" But when Arisa attempts suicide, Tsubasa learns that her seemingly perfect sister has been keeping some dark secrets. Now Tsubasa is going undercover at school - disguised as Arisa - insearch of the truth. But will Arisa's secrets shatter Tsubasa's life, too? UNRAVELING SECRETS Who is the mysterious ""King"" controlling the class?? Tsubasa pursues Akira Manabe, a troubled boy who might know the King's true identity.? As Tsubasa closes in on Arisa's secret, the King makes another move! Includes special extras after the story! | 01KG995ZQRMX5B56H7FYCZRDY1 | 2.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 2 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_3YJF5XDXV1A0 | CNT_27AKG8SDV490 | ARISA CNT_3KM9SVX18TC0 | CNT_3KM9SVX18TC0 | 2 | 1 | 1 | Volume 4 | [] | Arisa 4 | Tsubasa thinks that her pretty and popular twin sister, Arisa, has the perfect life. Everyone at school loves Arisa-unlike the hot-tempered Tsubasa, whose nickname is ""The Demon Princess."" But when Arisa attempts suicide, Tsubasa learns that her seemingly perfect sister has been keeping some dark secrets. Now Tsubasa is going undercover at school - disguised as Arisa - insearch of the truth. But will Arisa's secrets shatter Tsubasa's life, too? ONCE UPON A KING When her sister's boyfriend, Midori, leads her to his cell phone, Tsubasa finally gets a chance to meet the King. But the mysterious Kudo is determined to prove that people are base creatures who betray and reveal your secrets. After another betrayal can Tsubasa ever trust anyone, including her own sister, Arisa? Includes special extras after the story! | 01KG99610B6A9FFRS25Q0MB9NM | 4.0 | 2016-10-25T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Arisa 4 | (C) Natsumi Ando / Kodansha Ltd. | 2016-10-25T07:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);