products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_1KWJ3VWAMPVG"
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_04RJ4EN5S5HG | CNT_2B962Z4AW9HG | DRAGONZAKURA2 CNT_1KWJ3VWAMPVG | CNT_1KWJ3VWAMPVG | 2 | 1 | 1 | Volume 2 | [] | DRAGONZAKURA2, Volume 2 | Kenji Sakuragi has returned and created the ""Specialized University of Tokyo Class. ""Nao Hayase and Koichiro Amano have joined to begin studying for the exams. To start, the two have taken on past Center Test questions. The purpose was to analyze their current academic levels and take measures accordingly, but with the students' unexpected actions teacher Naomi Mizuno is completely baffled. On the other hand, confrontation between the ""Old"" vs. ""New"" School Building groups has escalated since Sakuragi's arrival. In the midst of this unsettling mood enveloping the school, laughter suddenly boomed through the ""Specialized University of Tokyo Class."" ""Laugh when you've failed!"" With the arrival of the ""University of Tokyo Test Matrix"" as a trump card, this story blazes into action! | 01KGA5CGYAXZ2R6H0HCEZYGKTD | 2.0 | 2018-10-22T15:00:00.000Z | Cork, Inc. LAB_168HRN4Z10P0 | GEO_1PKAG51AEAQG | DRAGONZAKURA2, Volume 2 | (c)Norifusa Mita/Cork | 2018-10-22T15:00:00.000Z | 0 | 0 | |||||
| PRD_1AVKGSZZ3G7G | CNT_2FACK2WFZCE0 | DRAGONZAKURA2 CNT_1KWJ3VWAMPVG | CNT_1KWJ3VWAMPVG | 2 | 1 | 1 | Volume 5 | [] | DRAGONZAKURA2, Volume 5 | Some conditions in the U of T English listening test will give you an advantage !? Anticipation by using TED-Ed, The ten conditions that parents of U of T should follow, and they talk about reading comprehension, which is it's studying method is not known, but it's essential to boost up the scores of all subjects. This volume is also full of must-pass information! The charismatic Japanese professor, Mr. Osamu Hayashi will appear in his role! | 01KGA7DZKBQ6B5YSSS1WZXN8WX | 5.0 | 2019-07-30T07:00:00.000Z | Cork, Inc. LAB_168HRN4Z10P0 | GEO_1PKAG51AEAQG | DRAGONZAKURA2, Volume 5 | (c)Norifusa Mita/Cork | 2019-08-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_1QE56FYWPYK0 | CNT_13VF7XVFG2Q0 | DRAGONZAKURA2 CNT_1KWJ3VWAMPVG | CNT_1KWJ3VWAMPVG | 2 | 1 | 1 | Volume 3 | [] | DRAGONZAKURA2, Volume 3 | With supplemental study materials and exam matrices, the ""U of T Course"" has introduced many new era exam prep skills. Sakuragi's original English study method of daily tweets and video uploads on YouTube turned out to be ""too much"" for the students. On the other hand, the ""Entrance Exam Problem Solving Course"" that has promised to bring down the ""U of T Course"" has also had its share of tear-inducing drama, resulting in a new and powerful student-teacher duo... | 01KG9B04EKHFFJQ556S1Z9F0AZ | 3.0 | 2019-01-22T15:00:00.000Z | Cork, Inc. LAB_168HRN4Z10P0 | GEO_1PKAG51AEAQG | DRAGONZAKURA2, Volume 3 | (c)Norifusa Mita/Cork | 2019-01-22T15:00:00.000Z | 0 | 0 | |||||
| PRD_3B0T92EW1GQ0 | CNT_3EZ33BQM5VZG | DRAGONZAKURA2 CNT_1KWJ3VWAMPVG | CNT_1KWJ3VWAMPVG | 2 | 1 | 1 | Volume 4 | [] | DRAGONZAKURA2, Volume 4 | ""Hello Everybody!"" A new English teacher has came to The University of Tokyo Class. Her name is Akemi Nabe, who can copy Beyonce perfectly. She says Listening section is the most important to attack The The Tokyo University entrance exam. Her first class was eccentric and highly entertaining; Dancing, singing, copying and lip syncing! She teaches the key strategy for listening section, ""Murmur Speech Shadowing"". This volume tells all about how to study English! | 01KGA7DZ428J2PZ41QYXYTGS5Z | 4.0 | 2019-07-30T07:00:00.000Z | Cork, Inc. LAB_168HRN4Z10P0 | GEO_1PKAG51AEAQG | DRAGONZAKURA2, Volume 4 | (c)Norifusa Mita/Cork | 2019-08-20T07:00:00.000Z | 0 | 0 | |||||
| PRD_3HFXHKQY2AV0 | CNT_2PJZJW1QCEZ0 | DRAGONZAKURA2 CNT_1KWJ3VWAMPVG | CNT_1KWJ3VWAMPVG | 2 | 1 | 1 | Volume 1 | [] | DRAGONZAKURA2, Volume 1 | Todai is a piece of cake.""By producing Todai entrance exam passing students, Kenji Sakuragi had succeeded in rebuilding the ""idiot school"" Ryuzan High. With the major education reformation approaching in 2020, Sakuragi once again returns to Ryuzan which has fallen back down to its low. At his side is his former pupil Naomi Mizuno. With ""Empress"" Kumiko Tatsuno reigning supreme over Ryuzan and the completely unmotivated student body before him, Sakuragi roars."" Todai is THE place! Get into Todai! | 01KGA3NZ0S0K4R2H066Z9EWQ7V | 1.0 | 2019-06-25T07:00:00.000Z | Cork, Inc. LAB_168HRN4Z10P0 | GEO_1PKAG51AEAQG | DRAGONZAKURA2, Volume 1 | (c)Norifusa Mita/Cork | 2019-06-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);