database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_2AMXFGW13Q4G"

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	on_sale_at
PRD_00FR1K8KT5VG	CNT_06BF2N47DGWG	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Boredom of Haruhi Suzumiya	[]	The Boredom of Haruhi Suzumiya	This third volume in the Haruhi Suzumiya series is a collection of four exciting short stories that chronologically take place before The Sigh of Haruhi Suzumiya. The Boredom of Haruhi Suzumiya: In her latest attempt to give the S.O.S. Brigade more public exposure, Haruhi signs the group up for the city-wide baseball tournament. Bamboo Leaf Rhapsody: It's like Back To the Future! In order to prevent an impending disaster, Mikuru takes Kyon back in time, where he meets Haruhi as a seventh grader. Mysterique Sign: The computer club president at school mysteriously disappears, and it's up to the S.O.S. Brigade to get to the bottom of it! Remote Island Syndrome: It's vacation time when a relative of Itsuki's invites the S.O.S. Brigade to stay at his island villa. But then a dead body turns up, and Haruhi and the gang get mixed up in a thrilling murder mystery.	01KGA307993A6SWMNFFM10FBVY	3.0	2018-02-23T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Boredom of Haruhi Suzumiya	2018-02-23T08:00:00.000Z
PRD_04W8K6AP64TG	CNT_2SNW20TFVFXG	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Melancholy of Haruhi Suzumiya	[]	The Melancholy of Haruhi Suzumiya	Haruhism has seized the nation with the release of the highly successful animated series DVD that was one of the top ten bestselling anime properties in 2007. Yen Press and Little, Brown Books for Young Readers will publish the novel and manga series back-to-back, with hardcovers of the novels with the original Japanese cover art for libraries and hard core fans of the property. When Haruhi Suzumiya introduces herself to Kyon by asking if he's an alien, time traveler, or psychic, he knows his chances for a normal high school experience are ruined. Bold Haruhi takes a shine to him, and uses the force of her irrepressible personality to draft him into her club to find paranormal beings. Kyon soon discovers what she's looking for: Haruhi herself has the power to destroy and create entire universes at her whim. But if she knew about her ability, it could spell disaster for everyone.	01KGA1JNXV4XF8J3TYT9MJ8QW4	1.0	2018-02-23T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya	2018-02-23T08:00:00.000Z
PRD_0FFVR8MPEXFG	CNT_2F71WKSVCS8G	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Dissociation of Haruhi Suzumiya	[]	The Dissociation of Haruhi Suzumiya	As the second year of high school begins, Haruhi's cynical and sarcastic confidant Kyon, the only "normal" member of the SOS Brigade, finds himself meeting Sasaki, an old friend from his days in junior high. Haruhi and Sasaki's shared friendship with Kyon and, possibly, shared abilities, causes tension between the two and Kyon knows Haurhi's dissatisfaction can have dire consequences! Kyon and Sasaki's chance meeting could affect his future, the future of the SOS Brigade, and the world forever. This ninth volume of the Haruhi Suzumiya series is the first to use two alternate stories for the same plot with different endings. The story continues in the next novel, The Astonishment of Haruhi Suzumiya.	01KGA361V8HARS3FY8HYQGF5CX	9.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Dissociation of Haruhi Suzumiya	2018-03-02T08:00:00.000Z
PRD_0R7G9NEAZ1S0	CNT_2FN4V15QPNF0	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Intuition of Haruhi Suzumiya	[]	The Intuition of Haruhi Suzumiya	SOMETIMES EVEN HARUHI DOESN’T KNOW WHAT SHE WANTS! While the SOS Brigade visits a shrine to ring in the New Year, Kyon can’t help but notice a distinct lack of supernatural or reality-bending phenomena. Despite this, he’s as wary as ever. After all, Haruhi has a tendency to turn even the most mundane events into impossible uproars! That danger could not be more pressing when their club activities lead them into a world of school wonders and whodunit mysteries. Even peaceful moments are remarkably bizarre when Haruhi is around...	01KG9CF89SSD6Y73MA04X7HBBK	11.0	2020-11-24T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Intuition of Haruhi Suzumiya	2020-11-25T08:00:00.000Z
PRD_1KWABVPRAWEG	CNT_0EHYWXE3VR9G	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Intrigues of Haruhi Suzumiya	[]	The Intrigues of Haruhi Suzumiya	After closing a time loop fiasco in The Disappearance of Haruhi Suzumiya, our protagonist Kyon is ready to start a new year with a blank slate--no time travel, no apocalyptic worries, and maybe some actual peace and quiet with the SOS Brigade, a club comprised of his high school's most extraordinary students. Their leader is Haruhi, a bold, brash girl who doesn't realize that she's actually a powerful goddess whose moods can easily change the balance of the universe.Just as Kyon starts to get comfortable, he gets a visit from his friend Mikuru. Except this isn't his Mikuru; it's a Mikuru from eight days in the future! Time traveling shenanigans start all over again as Kyon, guided by the future Mikuru, attempts to stop a terrible future from becoming a reality.	01KGA35ZPJ8NXX2N140FNNH4FS	7.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Intrigues of Haruhi Suzumiya	2018-03-02T08:00:00.000Z
PRD_1PJTNEG2PVDG	CNT_21WBWF4C6QAG	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Rampage of Haruhi Suzumiya	[]	The Rampage of Haruhi Suzumiya	The popular Haruhi Suzumiya series returns with another collection of surprising and quirky short stories starring our heroine and the SOS Brigade, comprised of the high school's extraordinary students. Short prose pieces help establish where the stories take place in the timeline.Endless Eight: The SOS Brigade are having a great time during the last two weeks of summer. Such a great time that Haruhi won't let it end, and the members of the SOS Brigade realize that Haruhi wishes have caused their summer to loop back 15,498 times!The Day of Sagittarius: The computer club challenges the SOS Brigade to a videogame tournament. Kyon begs the club to set aside their super powers in order to compete fairly, but when they discover that the Computer Society is cheating, Yuki steps up to level the playing field.SnowyMountain Syndrome: While skiing, the SOS Brigade are trapped by a mysterious blizzard, and take refuge in a deserted mansion. Yuki suddenly loses her powers, but Itsuki swears that Haruhi is not behind this. The SOS Brigade discover they have a mysterious nemesis who is out to take down the club.	01KGA35YBQTGE5G48J1ZPKF8YH	4.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Rampage of Haruhi Suzumiya	2018-03-02T08:00:00.000Z
PRD_21X9R46EWBBG	CNT_0HKG21MBFXQG	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Theater of Haruhi Suzumiya	[]	The Theater of Haruhi Suzumiya	HARUHI’S SHOW MUST GO ON!Kyon has woken up in strange places before, but a classic fantasy world where Haruhi’s the legendary hero is a first, even for him. He can’t remember how he or the rest of the SOS Brigade got there, and it doesn’t seem like there’s any way to leave. Things get even stranger when the gang falls face-first into one genre after another—from spaghetti westerns to space operas! It looks like the only way to go home is to break a leg and get these shows on the road!	01KP0BBRY9SHMFDFFMV2JYPPTN	12.0	2024-09-26T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	The Theater of Haruhi Suzumiya	2024-11-29T08:00:00.000Z
PRD_26Q0TXVGR4B0	CNT_1605JZZBJ0C0	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Sigh of Haruhi Suzumiya	[]	The Sigh of Haruhi Suzumiya	In this novel, the story follows the SOS Brigade's first movie making project, starring Mikuru Asahina as the main protagonist. Additionally, Nagato is made the antagonist in the movie and Koizumi is the conflict hero, who is supposed to end happily ever after with Mikuru, but faces competing interests from Nagato. Haruhi comes up with the idea that the SOS Brigade needs to do something for the upcoming cultural festival. Her class is doing a questionnaire, which is boring in her mind. She decides to make a movie, starring Mikuru.However, Haruhi begins to confuse the movie world with the real world, and the real world begins to become more like her movie. The pigeons in front of the shrine turn white, then into Passenger Pigeons, cherry trees blossom in autumn, Mikuru begins to shoot lasers out of her eyes, and the cat Shamisen begins to talk. By the efforts of Itsuki and Yuki, Kyon eventually convinces Haruhi to add a disclaimer at the end that the movie is a work of fiction.Overnight, the movie apparently edits itself, and is shown. With the disclaimer, Haruhi herself realizes it is a work of fiction, and the world reverts back to normal.	01KGA306DAGD10PB79AF1NP22D	2.0	2018-02-23T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Sigh of Haruhi Suzumiya	2018-02-23T08:00:00.000Z
PRD_296K7Y5H0YR0	CNT_1FJBDAYQ69Z0	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Surprise of Haruhi Suzumiya	[]	The Surprise of Haruhi Suzumiya	The Haruhi Suzumiya Series comes to a close with this final adventure of Haruhi and the S.O.S. Brigade. The two storylines from The Disassociation of Haruhi Suzumiya continue, introducing a new inductee into the S.O.S. brigade who may be more than just the eager freshman she appears to be. As the two realities converge, the SOS Brigade learns that the new member may have the ability to bring the two story "timelines" together--and save the world in the process. This book was originally published as two separate volumes in Japan, but the U.S. version will feature both volumes for the price of one.	01KGA362HR1YHRWCZ0S4C3G00E	10.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Surprise of Haruhi Suzumiya	2018-03-02T08:00:00.000Z
PRD_2DQ3JH7VCXZ0	CNT_3EWRCMMZN8R0	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Indignation of Haruhi Suzumiya	[]	The Indignation of Haruhi Suzumiya	Two stories continue the adventure in Volume 8 of the Haruhi Suzumiya series.Editor-in-Chief, Straight Ahead!Since the beginning of the year, the SOS Brigade has been masking as the Literature Club to be recognized as an official high school organization. But when the new student council president threatens to disband the group, the members must write a collection of literature. Naturally, Haruhi assume the role of editor-in-chief and leads the team to publication with hilarious results.Wandering ShadowFrom writers to detectives, the SOS Brigade does it all. When fellow classmate Sanaka comes to the club seeking help, the team (well, Haruhi) is up to the task. A well-trodden popular park path has suddenly begun to terrify the neighborhood dogs, and Haruhi suspects that its being haunted by animal spirits. It looks like the SOS Brigade is about to perform its first first canine exorcism!	01KGA3607DRK2AFZG809JJX066	8.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Indignation of Haruhi Suzumiya	2018-03-02T08:00:00.000Z
PRD_3G5JW41X8WY0	CNT_1E6NC69807S0	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Wavering of Haruhi Suzumiya	[]	The Wavering of Haruhi Suzumiya	In Book 6 in the series, readers take a step into a time warp in five short stories. Head back to events from the previous books, and previously unseen scenes and perspectives to uncover mysteries that had been left unanswered. Live Alive Kyon peruses the stalls at the cultural festival and visits Mikuru's noodle stall. Everything seems normal for once, until a surprise band shows up to perform. The Adventures of Mikuru Asahina: Episode 00 The movie that the SOS Brigade created in The Sigh of Haruhi Suzumiya (Book 2) is shown, and the Bridage gets to see it in its final form. Love at First Sight Kyon meets with an old friend, who describes seeing a girl he's fallen in love with--and it turns out to be Yuki! Will this mere human have a chance with the world's most stoic robot? Where Did the Cat Go? This story takes readers back to Book 3 (The Rampage of Haruhi Suzumiya) in which the SOS Brigade finally begins the main event for the Snow Mountain retreat murder mystery. The Melancholy of Mikuru Asahina Mikuru asks Kyon to accompany her to buy tea leaves, but a secret motive may be involved.	01KGA35YW8R5JVYPYJ8A9CJA3P	6.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Wavering of Haruhi Suzumiya	2018-03-02T08:00:00.000Z
PRD_3MTDFQ37MVX0	CNT_31H2FHZGF6T0	The Haruhi Suzumiya Series CNT_2AMXFGW13Q4G	CNT_2AMXFGW13Q4G	2	2	1	The Disappearance of Haruhi Suzumiya	[]	The Disappearance of Haruhi Suzumiya	What if you woke up one morning, and everything changed? It's one week before Christmas Eve, and Haruhi and the S.O.S. Brigade (a club for her high school's strangest and most extraordinary students) are gearing up for holiday festivities. But just before the fun kicks off, Kyon, the only "normal" member, wakes up in a weird alternate dimension, one where Haruhi attends another school entirely, Nagato the time traveling robot is just an ordinary human, and Mikuru (the cute girl of Kyon's dreams) doesn't even recognize him-in other words, S.O.S. Brigade never existed. The only clue Kyon can find is a bookmark left by the robot version of Nagato, which leads him on a quest back in time, where he interacts with the storyline from "Bamboo Leaf Rhapsody", a short story from the previous Haruhi book, The Boredom of Haruhi Suzumiya. This fun and quirky holiday tale is reminiscent of A Christmas Carol and It'sa Wonderful Life.	01KGA35XXF80VT05QW3D6MP0W4	4.0	2018-03-02T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PTQTSR31PRG	The Disappearance of Haruhi Suzumiya	2018-03-02T08: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);