database: products: 20 rows where series_id = "CNT

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

20 rows where series_id = "CNT_3AK2X3MJ7EWG"

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_0J740YGCKN90	CNT_2ZJPED45D0AG	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 8	[]	The Melancholy of Haruhi Suzumiya, Vol. 8	Something very, very strange is going on...because nothing strange is going on...Overnight, the SOS Brigade, the existence of supernatural beings, and Haruhi Suzumiya's obsession with finding them (not to mention Haruhi herself!) have disappeared. Has the goddess lost her touch? And why is Kyon, who so often longed for a normal life, so upset to find all of it suddenly gone?	01K5GB3CN2N4YMX62WG5A66E94	8.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P9DF0AHYE6G	The Melancholy of Haruhi Suzumiya, Vol. 8	2016-06-30T15:00:00.000Z
PRD_0PNMKHDPZM80	CNT_0YX39RTDRZBG	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 10	[]	The Melancholy of Haruhi Suzumiya, Vol. 10	Quite out of the blue, Kyon receives a phone call from his middle school classmate Nakagawa. Six months ago, he spotted Kyon walking with the most beautiful girl he'd ever seen and instantly fell in love! Now he wants Kyon's help conveying his feelings. But Nakagawa has no idea that the fair maiden who stole his heart is actually an otherworldly being...Nagato?! How will the stoic alien react to Nakagawa's affections?!	01K5GB3BKE0WSPM0S81E7ZJB47	10.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 10	2016-06-30T15:00:00.000Z
PRD_17FM7NEPMR0G	CNT_0ST2YPQBQ320	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 20	[]	The Melancholy of Haruhi Suzumiya, Vol. 20	When Kyon arrives at school, it seems like another average day--until he realizes Sasaki has wrapped North High in a closed space. Led to the SOS Brigade clubroom by Sasaki and Tachibana, Kyon knocks (just in case) and is surprised to find not a costumed Asahina, but instead a girl he's never seen before...and a very familiar face!	01KG95N1J1MMNJZ6CE6QDSJR3T	20.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 20	2016-06-30T15:00:00.000Z
PRD_199DW1759QTG	CNT_3WK2YTMRSHR0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 5	[]	The Melancholy of Haruhi Suzumiya, Vol. 5	Say Haruhiiiiiii! As if he doesn't have enough to deal with during the day, Kyon's dreams are becoming a regular haunt for his SOS friends! Once again, lucky(?) omens hawk, eggplant, and Mount Fuji (played respectively by Tsuruya, Nagato, and Koizumi) make an appearance, but their promises of fortune never seems to play out for Kyon. All he ever gets is more of Haruhi-chan's antics! You'll find plenty of gags and guffaws as Haruhi dives into the world of four-panel and short comics!!	01K5GB3F67Z2Q8ZDHQ3XEPD6FW	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 5	2016-06-30T15:00:00.000Z
PRD_1ARJHE53D8VG	CNT_1X8NZ8YGAJZ0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 2	[]	The Melancholy of Haruhi Suzumiya, Vol. 2	"Let's track down aliens, time travelers, and psychics and hang out with them!" Haruhi Suzumiya established the SOS Brigade for that sole purpose. But why's she been acting so strange of late? So...melancholy? Unable to locate any supernatural beings (even though they're right there in the club room the whole time), Haruhi's frustrations turn violent. What's Kyon gotten himself mixed up in this time?! Enjoy volume 2 of this somewhat abnormal high school story!	01K5GB3G4MX6K91BA7ZFP6Q2HJ	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 2	2016-06-30T15:00:00.000Z
PRD_1BSA971DA920	CNT_1DMF65BRK41G	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 18	[]	The Melancholy of Haruhi Suzumiya, Vol. 18	A new school year means fresh blood for the SOS Brigade! But not just anyone can join this elite group of alien-, time traveler-, and esper-hunters! As Haruhi puts the new recruits through their paces in one timeline, the veteran members visit the ailing Yuki in the other. Yuki reveals that her illness may be the work of other humanoid interfaces like herself, but when Kyon rushes to confront them, he runs into a familiar face he had hoped he would never see again...!	01KG97TZ33MWV2NYMP8M6XN89H	18.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 18	2016-06-30T15:00:00.000Z
PRD_1DZWFM1FNPSG	CNT_1ZXZY4914GS0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 7	[]	The Melancholy of Haruhi Suzumiya, Vol. 7	In a last-ditch attempt to recover their stolen equipment, the Computer Research Society challenges the SOS Brigade to a winner-takes-all multi-player space battle simulation! Failure seems inevitable, but losing is not an option! Can the unique members of the SOS Brigade pull together to destroy the expert Computer Research Society before Haruhi destroys the whole city?	01K5GB3E8RQ5RR3J8S8P04E6EX	7.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P9DF0AHYE6G	The Melancholy of Haruhi Suzumiya, Vol. 7	2016-06-30T15:00:00.000Z
PRD_1S3S7QW8TRD0	CNT_0WV9SP1M6BP0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 13	[]	The Melancholy of Haruhi Suzumiya, Vol. 13	After months of squatting in the Literature Club's clubroom, the SOS Brigade puts pen to paper and starts writing some literature of their own! The Brigade has just one week to create a literature newsletter if they want to keep the Lit Club's space from being reallocated by the student council. As each member prepares his or her contribution, Supreme Editor in Chief Haruhi keeps a watchful eye on her team, especially as Kyon's assigned romance story unfolds!	01KG982FR5TQN77YBXDWE0K4WD	13.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 13	2016-06-30T15:00:00.000Z
PRD_27G66V1JBDS0	CNT_0MQP4T6S2ZT0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 15	[]	The Melancholy of Haruhi Suzumiya, Vol. 15	As a member of the SOS Brigade, Kyon has had his fair share of close encounters (of the bizarre kind). But as Mikuru the Elder's scavenger hunt sends Kyon and "Michiru" into trouble, Kyon realizes that the scope of his friends' supernatural connections are far beyond what even he could ever have imagined-and far more dangerous...	01KG98215EQDEB9MPZ62PNAAB5	15.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 15	2016-06-30T15:00:00.000Z
PRD_298HK6FAJZ80	CNT_12W12C4CNTBG	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 19	[]	The Melancholy of Haruhi Suzumiya, Vol. 19	After Haruhi's rigorous selection process, a new member has been selected for the SOS Brigade! But Kyon feels uneasy around Yasumi Watahashi, not only because of the girl's odd behavior, but also because he knows the peculiar-and sometimes threatening-types that tend to congregate around Haruhi Suzumiya...	01KG97TD77CDJ4694V45911D4M	19.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 19	2016-06-30T15:00:00.000Z
PRD_2A248ER90YTG	CNT_1RHJCAS5Y0SG	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 11	[]	The Melancholy of Haruhi Suzumiya, Vol. 11	Trapped on the snowy mountain by both a storm and the supernatural forces that have cut off Yuki from the Data Overmind, Kyon is roused from sleep by Asahina slowly unbuttoning her nightshirt as she climbs into his bed! Kyon realizes it cannot possibly be the real Asahina (darn!), and though he doesn't mind the house's tricks (who would?), he and the Brigade have to crack the code and escape fast before Yuki's fever (and Haruhi's restlessness) gets out of control!	01KG982RWAFBJFSJNN2P2EZ9N3	11.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 11	2016-06-30T15:00:00.000Z
PRD_2GCCS72HHNRG	CNT_3Z8CSQZ9JFT0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 9	[]	The Melancholy of Haruhi Suzumiya, Vol. 9	Following the clues in the clubroom, Kyon travels back in time to a familiar place...the same time and place he came with Asahina last summer! Kyon again meets with the elder Asahina, but she has no idea what's caused the future to go awry - erm, to go normal. Stoic Nagato is not surprised to find future Kyon at her door (for the second time that night) and prepares a program that will repair the rift. But the decision to administer it or not lies with Kyon...	01K5GB3C47WJ3PBFMVG5QT7Y89	9.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 9	2016-06-30T15:00:00.000Z
PRD_302TEJRM3950	CNT_2T92FMD3S4EG	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 1	[]	The Melancholy of Haruhi Suzumiya, Vol. 1	Kyon is your ordinary high school freshman who has long given up on his childhood dreams of encountering the fantastic and supernatural...or so he thought. From the very first day of school, his classmate--the beautiful but eccentric Haruhi Suzumiya--makes it very clear that her only desire is to meet aliens, time travelers, and psychics! A chance conversation between the two inspires Haruhi to form the SOS Brigade, a school club created for the sole purpose of gathering together such supernatural beings. The initial members consist of the mute bookworm Yuki Nagato, the timid but voluptuous Miharu Asahina, and the polite and ever-smiling Itsuki Koizumi. By the end of this first volume, Kyon quickly finds out that these seemingly "helpless victims" of Haruhi's are actually members of secret organizations--both futuristic and alien--with the single aim of keeping watch over Haruhi Suzumiya as she is the pinnacle of some major calamity on the horizon...	01K5G9X1AP1ZBG5GA7VFRGCC20	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 1	2016-06-30T15:00:00.000Z
PRD_34KAR5TYF840	CNT_0XKZF63C43FG	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 4	[]	The Melancholy of Haruhi Suzumiya, Vol. 4	When the SOS Brigade receives an urgent message that the Computer Research Society's president has gone missing, Haruhi confidently promises to locate him, and the SOS Brigade is off! Of course, they have no idea where to start... Is the new SOS Brigade insignia that Haruhi designed to blame for all of this???	01K5GB3HE0S4GN4PCJ3QKNX3VQ	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 4	2016-06-30T15:00:00.000Z
PRD_353C8TCFKK70	CNT_1A0802ZD4PC0	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 17	[]	The Melancholy of Haruhi Suzumiya, Vol. 17	One weekend, when Kyon reaches the usual SOS Brigade rendezvous spot, he is met not by his fellow club members, but instead by Sasaki, an old friend from middle school. Haruhi isn't thrilled to find Kyon already waiting when she arrives (Who's going to buy drinks?!) and is even less thrilled by his attractive female friend!	01KG981MRCY8FSC9DDVTMKTD5Y	17.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 17	2016-06-30T15:00:00.000Z
PRD_39D3JC66940G	CNT_1HSMBHKT0Q3G	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 14	[]	The Melancholy of Haruhi Suzumiya, Vol. 14	Guided only by a series of notes that direct him to do the most inexplicable things-"Buy a small turtle and throw it into the lake"?-Kyon and the Mikuru from eight days in the future complete the assigned tasks, hoping that things will become clear as the SOS Brigade's adventures for that week continue. But Kyon and Mikuru's scavenger hunt soon turns to a manhunt when Mikuru is kidnapped by a group of rogue espers, time travelers, and aliens!	01KG982AETKPGTQRHANB6G7Y1Q	14.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PDPG7Q49R30	The Melancholy of Haruhi Suzumiya, Vol. 14	2016-06-30T15:00:00.000Z
PRD_3B05BRM0BQB0	CNT_2WYCEHSMK28G	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 3	[]	The Melancholy of Haruhi Suzumiya, Vol. 3	The SOS Brigade gets browbeaten into entering a baseball tournament to help their fearless leader stave off boredom. But despite the Brigade's clear lack of skill Haruhi has no intention of losing...and she's ready to pitch a fit if her team doesn't step up to the plate!	01K5GB3FQDNRDEX7DW7FFF1V1V	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P9DF0AHYE6G	The Melancholy of Haruhi Suzumiya, Vol. 3	2016-06-30T15:00:00.000Z
PRD_3FPNNBPAQPA0	CNT_0W8SE3FWY19G	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 6	[]	The Melancholy of Haruhi Suzumiya, Vol. 6	Swapping her Brigade Chief armband for a director's chair, Haruhi continues production on the SOS Brigade's school festival film project. As she watches her half-baked plot acted out in front of her, Haruhi longs even more for the supernatural reality depicted in her movie. And for Haruhi, bringing her script to life is wholly possible...and inevitably dangerous!	01K5GB3ET2Q2B76HNDGNVPJ0YE	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1P9DF0AHYE6G	The Melancholy of Haruhi Suzumiya, Vol. 6	2016-06-30T15:00:00.000Z
PRD_3HQQG7HZMVZG	CNT_3TH9EHVZ7Y4G	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 12	[]	The Melancholy of Haruhi Suzumiya, Vol. 12	Kyon knew it was only a matter of time before he would have to return to December 18th of the previous year, to the three days when the SOS Brigade and his supernatural friends suddenly disappeared. Back then, Kyon was cruelly stabbed by alien rogue Ryouko Asakura and nearly bled out on the school roof. How will he fare this time around?	01KG982KYBA4V9G2V42YR6W09C	12.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 12	2016-06-30T15:00:00.000Z
PRD_3ZFJ01PSFP20	CNT_380H1VYKZS10	The Melancholy of Haruhi Suzumiya CNT_3AK2X3MJ7EWG	CNT_3AK2X3MJ7EWG	2	1	1	Volume 16	[]	The Melancholy of Haruhi Suzumiya, Vol. 16	Guided only by a series of notes that direct him to do the most inexplicable things-"Buy a small turtle and throw it into the lake"?-Kyon and the Mikuru from eight days in the future complete the assigned tasks, hoping that things will become clear as the SOS Brigade's adventures for that week continue. But Kyon and Mikuru's scavenger hunt soon turns to a manhunt when Mikuru is kidnapped by a group of rogue espers, time travelers, and aliens!	01KG981RCX9BW58VVT8DMFRYN5	16.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Melancholy of Haruhi Suzumiya, Vol. 16	2016-06-30T15: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);