database: products: 14 rows where series_id = "CNT

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

14 rows where series_id = "CNT_1Z08ZQHQ9Z70"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_008Y9DA6JAC0	CNT_1MW1FB4K6XQ0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 3	[]	Sayonara Zetsubou-Sensei 3	From the savage mind of Koji Kumeta-a twisted trip of deliciously wicked proportions One of Zetsubou-sensei's new students-a genius storyteller-can melt even her teacher's black heart. Meanwhile, Chiri, the obsessive-compulsive girl who longs to marry Zetsubou-sensei, is thrilled when the morose young man actually invites her somewhere. Has Zetsubou-sensei asked Chiri out on a date, or is he planning a murder-suicide? Either option may involve flowers! Includes special extras after the story!	01KG99727BNEGQ6MNRYHMHN0EV	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 3	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_04SEM048YAK0	CNT_3M6YEPTVNWG0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 1	[]	Sayonara Zetsubou-Sensei 1	GOODBYE, MR. DESPAIR Nozomu Itoshiki is depressed. Very depressed. He's certifiably suicidal, but he's also the beloved schoolteacher of a class of unique students, each charming in her own way: The stalker. The shut-in. The obsessive-compulsive. The girl who comes to class every day with strange bruises. And Kafuka, the most optimistic girl in the world, who knows that every cloud has a silver lining. For all of them, it's a special time, when the right teacher can have a lasting positive effect on their lives. But is that teacher Itoshiki, a.k.a. Zetsubou-sensei, who just wants to find the perfect place to die?	01KG98D95PDQNT5GQKE9TY2D03	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 1	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0KGD4EH46F90	CNT_3G80D0Q972A0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 13	[]	Sayonara Zetsubou-Sensei 13	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? RACE OF DESPAIR Zetsubou-sensei explains his fear of relay races. After all, you never know what kind of baton you'll be passed! What if the CEO of a company passes off the baton to you right as the company goes bankrupt? Or what if a movie director passes off the baton to you right after the main actor quits? What would you do then, huh? In a moment of weakness, however, Zetsubou-sensei passes off the baton to a student. How will the ""Second Generation Zetsubou-sensei"" fare? Includes special extras after the story!	01KG9978ZT141TP2VYWXZTYVYM	13.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 13	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0P6XQ1KE2E80	CNT_1KJXCJDHJ1B0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 11	[]	Sayonara Zetsubou-Sensei 11	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? SPRINGING INTO A SUMMER OF SELF-DISCOVERY It's spring in volume 11, and Zetsubou-sensei and the students master the art of detuning; that is, purposefully inhibiting he performance of something. Then, during summer vacation, they go on journeys of self-discovery, confront a mob of zealous over-preotectors, and dodge spy accusations ont he beach. Finally, back in the classroom, they are caught off-guard by surprise inspections masterminded by Zetsubou-sensei and Chiri Kitsu! Includes special extras after the story!	01KG9977ZQRFEC46KQTMPVKVFC	11.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 11	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0S5ZC7ETACE0	CNT_1J77CFR2CZN0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 7	[]	Sayonara Zetsubou-Sensei 7	THE INCONVENIENCE OF CONVENIENCE ? Zetsubou-sensei is angry again, and this time he's turned his sights on Inconvenience. Modern-day inventions are supposed to make our lives more efficient, but the sensei sure doesn't see it that way. TV remote controls are meant to save us time and energy, but how much time do we waste just trying to find the remote? Our cellphones are supposed to keep us connected no matter where we are, but we spend half our time walking around trying to find a signal. Zetsubou-sensei has had it with so-called conveniences! Luckily, he's come up with the perfect solution: ""Convenience Through Cloning."" Because what the world needs now is another Zetsubou-sensei, and another, and another and . . .	01KG997518QX00A7KB5V59GDZW	7.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 7	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0TQC2MCGEDF0	CNT_3JXACW3T10M0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 9	[]	Sayonara Zetsubou-Sensei 9	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? A DARKLY OFFBEAT COMEDY BY KOJI KUMETA Have you ever noticed the ""reverse-boy-who-cried-wolf"" phenomenon, where normally serious people tell jokes and nobody gets them?? Are recent fashion trends in Japan sophisticated artistic expression, or just gaudy over-decoration?? In volume 9, Zetsubou-sensei loses his job, his freedom, and... his glasses!?? And to top it off, the students of class 2-F are informed that they will all be held back in the eleventh grade... again. Includes special extras after the story!	01KG997683TFJ1KH55PY456F7P	9.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 9	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0XTFZT8WPBD0	CNT_3NHMFSEAVYP0	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 5	[]	Sayonara Zetsubou-Sensei 5	A darkly funny comedy by Koji Kumeta ? Zetsubou-sensei has won a trip to a hot spring, but when he finds several of his students there in the bubbling pools, he launches into a tirade about the evils of detoxing. To Zetsubou-sensei, detoxing is a metaphor for sanitizing the world of the very complexities and idiosyncrasies that define it. So put down that bar of soap and pick up volume 5 of Sayonara Zetsubou-sensei. ? Includes special extras after the story!	01KG99744T41GM3Z0H1H0K37QH	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 5	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_1D8TK466R0SG	CNT_2GK9XZW4YJTG	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 14	[]	Sayonara Zetsubou-Sensei 14	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? IT'S SPRINGTIME FOR ZETSUBOU It's spring which can only mean cherry blossoms, spring tidings, Golden Week, a new fiscal year, and warm weather! But leave it to Zetsubou-sensei to rain on everyone's parade. Why do we always look at the flowers and forget to eat the dumplings? Why focus on spring tidings, when there are so many spring ""chidlings""? What about the people have to work during Golden Week? And what about Zetsubou-sensei's life-threatening outbreak of spring fever? Hilarity ensues in this newest volume of Sayonara, Zetsubou-Sensei! Includes special extras after the story!	01KG9979FQJDXH4GAZZB5YMDP3	14.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 14	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_223QG4V1MBWG	CNT_0N7AZ29F0E7G	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 4	[]	Sayonara Zetsubou-Sensei 4	A wickedly twisted comedy by Koji Kumeta Suicidally depressed high school teacher Zetsubou-sensei, a man for whom the light at the end of the tunnel is the coroner inspecting his glazed eyes, continues his attempt to endure life's suffering while teaching a classful of cute girls. Will Kafuka Fuura, the most optimistic teenager on earth, ever convince her beloved sensei to look on the bright side of life? Or will Zetsubou and his students end up lobotomized and starving in a third-world dictatorship? All this, plus a Zetsubou-sensei Christmas! Includes special extras after the story!	01KG9972NQN0CNSYS4ZJNM80BS	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 4	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_26G63QNBGA3G	CNT_2MH7ZDZQFD0G	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 2	[]	Sayonara Zetsubou-Sensei 2	TEACHER OF DARKNESS Meet the most melancholy high school teacher in Japan: Nozomu Itoshiki, whose fashion sense is strictly nineteenth-century, whose personal goal is self-annihilation, and whose signature phrase is ""I'm in despair!"" He's similar to Franz Kafka and Jean-Paul Sartre-if Kafka and Sartre had had to deal with a classroom of short-skirted, lovesick students. And to make matters worse, Itoshiki's family wants him to get married. Forget the bride, here comes the gloom! The first translated work by Japan's most savage satirist, Koji Kumeta! Includes special extras after the story!	01KG9971NCEAEQAMKRZVVPAK73	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 2	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2HSNYQ094FRG	CNT_0KX6X9JDDHVG	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 12	[]	Sayonara Zetsubou-Sensei 12	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? DOES HE KNOW IT'S CRISTMAS TIME AT ALL? Itoshiki Nozomu, the world's most negative person, is about to suffer an ironic twist of fate. His 32 students, who each have their own weird problems, have ocnstantly foiled his continual suicide attemtps. With Christmas right around the corner, will Nozomu finally discover joy this holiday, or will he be granted the ultimate gift? Includes special extras after the story!	01KG9978FX6RPW38545XJJHNF9	12.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 12	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2ME48BXK0EZG	CNT_2K7KWV8NRH4G	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 10	[]	Sayonara Zetsubou-Sensei 10	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? Speak Softly, And Carry Bad News ? Zetsubou-sensei and the students go on several unusual class trips, including an archaeological expedition, the Museum of Unnatural History, and Daisan Sentaku City-the city of the inexplicable third alternative. You know, like, when you're trying to decide whether to get a puppy or a kitten... and you end up with a crocodile? The students also practice selling themselves (legally), getting over their self-entitlement, and the art of ""soft landings""-a.k.a. breaking bad news gently. Includes special extras after the story!	01KG9977FV564XGNMF1CADBNQQ	10.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 10	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2RWMVYZNCDYG	CNT_0JJ0W6YY7G5G	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 8	[]	Sayonara Zetsubou-Sensei 8	Teachers are supposed to inspire the younger generation to follow their dreams and achieve great things. However, our hero, Nozomu is not that teacher. Nozomu's probably the most depressive man in Japan--so depressive, in fact, that every little setback in life inspires yet another suicide attempt! But then why is being in Nozomu's class such a blast? Is it his quirky and endearing students? The bizarre adventures he leads them on? Or is there something after all to ""the Power of Negative Thinking""? RITES OF PASSAGE November means that it's time for the Shichigosan holiday, a rite of passage for all Japanese children. Of course, Zetsubou-sensei is quick to point out that rites of passage don't end with childhood. There are many different rites of passage in the world. For instance, a manga assistant's rite of passage is spilling coffee on the storyboards forthe first time. And we mustn't forget the important rite of passage that any true Zetsubou fan must undergo. What is it, you ask? Why, buying a copy of Sayonara, Zetsubou-sensei Volume 8, of course! This volume of Sayonara, Zetsubou-Sensei includes special extras after the story!	01KG9975NGE7571TG1BF13CYEC	8.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 8	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2ZD76HSZ8CXG	CNT_2NWXZGK6NF6G	Sayonara Zetsubou-Sensei CNT_1Z08ZQHQ9Z70	CNT_1Z08ZQHQ9Z70	2	1	1	Volume 6	[]	Sayonara Zetsubou-Sensei 6	DELUSIONAL SELF-BLAMING DISORDER ? Those suffering from this peculiar condition, according to Zetsubou-sensei, blame themselves for everything that goes on around them. But as Zetsubou-sensei explores this affliction, he realizes that he himself is a victim! Luckily, the sensei has a foolproof plan for putting an end to Delusional Self-Blaming Disorder-which happens to involve a long rope dangling from a tree. Could this be the end of Zetsubou-sensei?	01KG9974K7EYR14MSFJ8YEF6ZR	6.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sayonara Zetsubou-Sensei 6	(C) Koji Kumeta / Kodansha Ltd.	2016-10-25T07:00:00.000Z

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);