products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
12 rows where series_id = "CNT_3QNKKMFN0GB0"
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_07C2NJ6HR92G | CNT_24CTK9HG2Y0G | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 7 | [] | Kiniro Mosaic, Vol. 7 | Shino and friends are about to become third-year high school students! The girls are a little uneasy about their new class, but a field trip to Nara and Kyoto awaits! Alice loves Japanese culture and should be excited about this, but...!? | 01KGA57777C479HZ6YFYB1Q529 | 7.0 | 2018-09-18T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 7 | 2018-09-18T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0PV5MTFXBHA0 | CNT_3WTWYK0XBM90 | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 2 | [] | Kiniro Mosaic, Vol. 2 | While Alice and Karen have quickly gotten used to life in Japan thanks to the help of their friends, plenty of new experiences still await them--their first school festival, summer vacation, an unforgettable Japanese-style(?) Christmas party, and more! The girls are having the time of their lives in this comedy of cultural exchange, and with any luck, they might even remember to study for their exams too! | 01KG9YXG38YC4KWS43TYH88VPM | 2.0 | 2017-03-20T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 2 | 2017-03-20T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1TB5YSXKRNBG | CNT_028MPZ76VHA0 | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 9 | [] | Kiniro Mosaic, Vol. 9 | It’s another year and another summer vacation for the girls, and Karen’s got everything planned out. A trip to the Kujou family cottage awaits, but Aya threatens to cancel their plans if anyone does poorly on the upcoming exam! Feeling the pressure, Karen hits the books…unlike Youko, whose misguided self-confidence just might end the whole trip before it even begins! | 01KGA706SNVET8SNVDXCQG4MC8 | 9.0 | 2019-05-28T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 9 | 2019-05-28T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2KXF39R402Y0 | CNT_01FRG5D9TQ40 | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 8 | [] | Kiniro Mosaic, Vol. 8 | The girls are back, and they're as lively as ever! Alice and Shino are fighting over pudding, Aya has a secret diary filled with poems, and Karen's challenged Youko to a duel! But with college entrance exams just around the corner...shouldn't they be studying? | 01KGA5KJ0YVD7HXWMV8CE6MN9D | 8.0 | 2019-01-29T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 8 | 2019-01-29T08:00:00.000Z | 0 | 0 | ||||||
| PRD_2PAJ5CJF5WP0 | CNT_3Q5VQNJGCEX0 | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 1 | [] | Kiniro Mosaic, Vol. 1 | Alice has just transferred to a school in Japan from England, and a whole world of adventures await with her friends Shinobu, Aya, Karen, and Youko. Join the girls' daily school lives as they learn more about Japan's language and culture! | 01KG98JFHPCJ1FPNJT6RYK1NR1 | 1.0 | 2016-12-27T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 1 | 2016-12-27T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2YF2F0M8GTKG | CNT_3PXGX7VZ032G | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 4 | [] | Kiniro Mosaic, Vol. 4 | Shinobu, Alice, and the rest of the girls might be in different classes, but their friendship is stronger than ever! From everyday chats to gardening to visiting the beach, there's plenty in store--including a trip back to England for Alice and Karen! | 01KG9VN19359HJZZ1BT1T3BDF2 | 4.0 | 2017-09-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 4 | 2017-09-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_326CWYNNA00G | CNT_07RVYFCM0SXG | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 3 | [] | Kiniro Mosaic, Vol. 3 | Alice, Shinobu, and the rest of the girls are entering their second year of high school...but now they're in separate classes! Can Aya cope with not having Youko by her side? And just why is Karen's new homeroom teacher, Kuzehashi-sensei, always scowling at her? It's a brand-new spring--and a brand-new opportunity for intercultural hijinks! | 01KG9Z4Y7TMB68J3D0X7TBMKF9 | 3.0 | 2017-06-19T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 3 | 2017-06-19T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3BDKV87JRBQG | CNT_2QB50C3FA6GG | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 6 | [] | Kiniro Mosaic, Vol. 6 | The girls are headed toward their final year in high school! Whether it's Alice's first Japanese bath house visit or the fanciest low-key Christmas party ever, the fun never stops. Santa Karen also has the ultimate yuletide present for Alice...but mum's the word! | 01KGA3DFQSGNRQAK98SVYV44S7 | 6.0 | 2018-04-24T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 6 | 2018-04-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3EXTX714RNJ0 | CNT_29XVNGTBV6AG | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 10 | [] | Kiniro Mosaic, Vol. 10 | Summer vacation is here, and while the girls just want to have fun, Aya’s determined to get some studying done! College is right around the corner, and the idea of being separated from one another is enough to make anyone anx-ious about the future. But the good times they’ve shared aren’t done yet—because once summer’s over, the school festival begins, and Karen and Alice will be taking center stage! | 01KGA7WYCN6AK4S3E98KAGQ8NP | 10.0 | 2020-02-25T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 10 | 2020-03-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3QG3T9D6VD00 | CNT_19D58457ZNDG | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 5 | [] | Kiniro Mosaic, Vol. 5 | Sports Day has arrived, and the girls are getting ready to compete! Honoka, on the other hand, is focusing on how to ask Karen for her number, and it's not going well. But things might change once Shino gets involved and joins forces with her to form the Blond Alliance! Sharing their love of blond hair, the two become the best of friends...and the fiercest of rivals! | 01KGA186CBZV62CTXRBX979ZZ8 | 5.0 | 2017-12-19T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 5 | 2017-12-19T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3TGBKXQWJ270 | CNT_1HCY683YCE50 | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Best Wishes | [] | Kiniro Mosaic: Best Wishes | The girls have graduated, and spring has arrived! With Alice and Shino living in England—and Aya, Youko, Karen, Kana, and Honoka adjusting to college back in Japan—the future is fifilled with excitement and trepidation. And as their lives play out, the girls also can’t help but reminisce about their high school years. Whether together or an ocean apart, their golden days aren’t over just yet! | 01KGB2RE03PW2RWJ7K2Z7TZ507 | 12.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1HQTK5SKDE9G | Kiniro Mosaic: Best Wishes | 2023-03-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3YFR705KJ6BG | CNT_1BTR6QYHMAM0 | Kiniro Mosaic CNT_3QNKKMFN0GB0 | CNT_3QNKKMFN0GB0 | 2 | 1 | 1 | Volume 11 | [] | Kiniro Mosaic, Vol. 11 | It’s the final stretch as Aya, Youko, and Karen study frantically for college entrance exams, with Alice and Shinobu cheering them on. Then it’s finally time for their graduation trip, and there’s a single destination on their map-England! Join your favorite fun-loving group of girls one last time as they make memories abroad! | 01KG9GGF99GVS8HC90ZT41EGFA | 11.0 | 2021-07-27T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Kiniro Mosaic, Vol. 11 | 2021-08-31T07: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);