database: products: 8 rows where geoblock_id = "GEO

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

8 rows where geoblock_id = "GEO_1PDPG7Q49R30"

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_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_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_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_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_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_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

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