products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
7 rows where series_id = "CNT_18WZRC10SDD0"
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_0QB7KN18DSVG | CNT_3V3FVQBY54HG | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 7 | [] | Oh, Those Hanazono Twins 7 | Due to a burst water pipe in his house, Tatara suddenly finds himself staying at the Hanazonos because his home has to undergo major construction for a month! And life under one roof with Ranko and Yuriko means It's a month full of unexpected, exciting events! One night, under Maricchi's instruction, Ranko decides to make a very aggressive approach to Tatara. Is the secret weapon Maricchi has prepared for Ranko turn out too extreme?! Life is peaceful and well until the wheel of fates brings them all in different directions. The twins' romance takes a big turn in this final volume! | 01KGB2FK269B1HD1ETWRG9HCWH | 7.0 | 2022-11-10T08:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 7 | Nena Kitajima/Kodansha Ltd. | 2022-11-29T08:00:00.000Z | 0 | 0 | |||||
| PRD_145X0PP4VCD0 | CNT_0V5KH9ZJE2SG | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 1 | [] | Oh, Those Hanazono Twins 1 | Tatara Tani is so average it hurts—the only thing he has going for him is that his childhood friends are ultra-popular idol Yuriko Hanazono and her fashionable twin, Rinko Hanazono! They're both his classmates, and his long-standinglongstanding relationship with them makes others seethe. But he thinks his fortunes might be turning around when Yuriko invites him to an amusement park on what probably isn't a date, seeing as she's explicitly NOT allowed to date as an idol. Even though Yuriko carefully disguises herself as Rinko, a photo of the two of them is discovered by their classmates...So he thinks he's hit the jackpot when Yuriko asks him to the amusement park with her, even though idols aren't allowed to date. She dresses up as Rinko to fool the world, but when her ruse is discovered by the school, it's up to the REAL Rinko to save her sister's reputation...by dating Tatara herself? This crazy rom-com of errors begins! | 01KGAF6H040KM01SZ36X8QZYX6 | 1.0 | 2022-04-14T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 1 | Oh, Those Hanazono Twins Nena Kitajima/Kodansha Ltd. | 2022-05-03T07:00:00.000Z | 0 | 0 | |||||
| PRD_1RZTAPTB54XG | CNT_1X63N665E6Z0 | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 3 | [] | Oh, Those Hanazono Twins 3 | Tatara Tani, average in both sports and studies, is attending high school with his childhood friends, the twin sisters Ranko and Yuriko. Ranko is an ultra-fashionista, while Yuriko is a famous idol. Yuriko is way out of his league, and even to this day, Tatara continues to admire the idol in his one-sided crush. But suddenly out of the blue, Yuriko invites Tatara out for a date, and Tatara's life becomes intertwined with the twins' secret! Thus begins their love triangle that no one can know! A story of twins with two times the excitement!! "I like Tatara!" Yuriko and Ranko have come to terms with their feelings. But being an idol means that Yuriko is forbidden from dating, and in order for Ranko to protect their relationship as secret lovers, she could not confess. Meanwhile, a mysterious classmate appears before Tatara and Ranko, and she invites Ranko to her band, making waves in the new volume. The twins' love story escalates even further with these turn of events! The bittersweet love troubles are raging at 200 percent! | 01KGAHPE66R2MN4M27F4DTQRS2 | 3.0 | 2022-06-17T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 3 | Oh, Those Hanazono Twins Nena Kitajima/Kodansha Ltd. | 2022-07-05T07:00:00.000Z | 0 | 0 | |||||
| PRD_1S7YNNDTP44G | CNT_1MSCA0Y6C700 | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 2 | [] | Oh, Those Hanazono Twins 2 | High schooler Tatara Tani only stands out because of how average he is—that is, until he starts (fake) dating the ultra-fashionable Ranko! The two of them can't allow anyone to get the idea that Ranko's twin sister, idol singer Yuriko, is romantically involved with Tatara, or she might lose her career! But as the fake dates pile up, Ranko's true feelings begin to awaken. As Ranko and Tatara grow closer, Yuriko begins to panic... because if Ranko and Tatara fall in love for real, where will that leave her?! The comedic twists and turns continue as the twins' love triangle begins to warp under the pressure! | 01KGAGME8EJG8QSA1YPQT2432G | 2.0 | 2022-05-18T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 2 | Oh, Those Hanazono Twins Nena Kitajima/Kodansha Ltd. | 2022-06-07T07:00:00.000Z | 0 | 0 | |||||
| PRD_23BX746BWNWG | CNT_3T9QV5T49290 | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 6 | [] | Oh, Those Hanazono Twins 6 | "As a result of their hard work during the summer break, the "Brave Momo and the Dream Team" won the band contest at the school festival! Among the band's mountainous prizes was a hot spring trip voucher for two. Momo gave the ticket to them, and to keep up with their set-up relationship, Tatara and Ranko agreed to go. Although there's a rift between the two caused by an unexpected blunder from Ranko, will their first trip with delicious food and luxurious accommodations brings them closer?! Let's begin the hot spring trip arc overflowing with love!" | 01KGB24XAXAGSX4PYCGP1X7TTP | 6.0 | 2022-10-12T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 6 | Oh, Those Hanazono Twins Nena Kitajima/Kodansha Ltd. | 2022-10-25T07:00:00.000Z | 0 | 0 | |||||
| PRD_2GV7D44RNA0G | CNT_1H8ZY26V47N0 | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 5 | [] | Oh, Those Hanazono Twins 5 | Finally, it's the day of the school festival! Before the band competition starts, Tatara and Ranko will participate in a lovey-dovey couples battle! The ordeals are so embarrassing that fainting in agony is inevitable! Afterward, it's finally time for the band contest to begin! Between Momo's band and Ume's band, who will come up as the champion?! As the contest begins, the twins and Tatara's wheel of destiny is about to be set in motion! This volume marks the end of the school festival arc! | 01KGB1TREFWTPY8BBYTSC950T4 | 5.0 | 2022-09-08T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 5 | Oh, Those Hanazono Twins Nena Kitajima/Kodansha Ltd. | 2022-09-27T07:00:00.000Z | 0 | 0 | |||||
| PRD_2SWZ588XNCAG | CNT_30F1E25NT9K0 | Oh, Those Hanazono Twins CNT_18WZRC10SDD0 | CNT_18WZRC10SDD0 | 2 | 1 | 1 | Volume 4 | [] | Oh, Those Hanazono Twins 4 | Between being busy as the all-in manager of Ranko's school band and having a study session with Yuriko, the average high schooler Tatara Tani wouldn't think of fooling the whole school with his ongoing fake relationship with Ranko. When the summer break starts, Ranko and the gang's motivation to practice becomes even more extensive as the school festival becomes closer, and Tatara tries to find ways to help the band in his own way. All that while juggling a top-secret trip with Yuriko and gourmand dates with Ranko?! The twins are going on the offensive this summer! | 01KGAJFWDQ1APHSK9K8W8VNQT2 | 4.0 | 2022-08-16T07:00:00.000Z | Kodansha LAB_0ZM7YN9KHCT0 | GEO_1PKAG51AEAQG | Oh, Those Hanazono Twins 4 | Oh, Those Hanazono Twins Nena Kitajima/Kodansha Ltd. | 2022-08-30T07: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);