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_2JFBCYDT0VDG"

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_00S4NJZ5H8DG	CNT_1FTPEAPKHB6G	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 11	[]	Tegami Bachi, Vol. 11	Largo Lloyd, ousted director of the Beehive, saves the life of a Marauder—and, in return, demands to be taken to the leader of Reverse. Will the Letter Bees finally penetrate to the heart of the rebel organization? Meanwhile, with his hero Gauche returning home at last, things are looking up for Lag...until he discovers the shocking truth about Gauche!	01KGBHAAW20BSFKD0FNMBZ0T09	11.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 11	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_0J6BGJAB5DAG	CNT_3B6NC699EFSG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 3	[]	Tegami Bachi, Vol. 3	Lag almost breaks the record time on his Letter Bee test, securing a job as a Letter Bee! But his celebration ends with unwelcome news: the record holder, Gauche Suede, is no longer a Letter Bee! Shocked, Lag seeks out Gauche's little sister Sylvette to learn exactly what happened. But Sylvette has no answers, only memories and a broken heart. Gauche would never abandon his sister like that! Could it be he lost his heart...or his life?!	01KGBHAHQPKX801HWBDW0RFP4M	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 3	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_0PMT254D1C9G	CNT_1AH2FHZHXETG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 19	[]	Tegami Bachi, Vol. 19	Lag returns from his training to find Amberground in chaos. The government is crumbling, revolution is underway and the sun itself is going out. The Letter Bees' last chance is to penetrate Akatsuki, the mysterious capital of Amberground and the source of the sun's power. But who will be the one to enter Akatsuki and forge a new world—Chico, who's prepared to make any sacrifice for her people, or Lag, who holds out the impossible hope that every life can still be saved?	01KGBHAFGGCPKW5WG15FZKDEK3	19.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 19	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_0ST5ZB3S9AFG	CNT_1D6CFDA2QD4G	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 15	[]	Tegami Bachi, Vol. 15	Searching for the truth about Amberground, Lag heads home to the little town of Campbell. There, a woman named Sabrina Mary holds the secrets he seeks. But can he handle what he learns about his world, his government...and his own mother?	01KGBHAD4Y581V8C26KWRQW2S9	15.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 15	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_0W8MAZX3N9EG	CNT_3CGSEZ0B2C5G	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 13	[]	Tegami Bachi, Vol. 13	While Lag and his fellow Bees fight a desperate battle against the Gaichuu Cabernet, the dark secrets of Amberground come to light. What unspeakable things did Garrard, director of the Beehive, see in Amberground's capital? And why has former director Largo Lloyd joined the rebel organization Reverse? The answers lie in the top-secret district called Kagerou...	01KGBHAC0M17WMMVK902VKVRYP	13.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 13	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_165HQGXQK1P0	CNT_09J7XPDC03D0	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 9	[]	Tegami Bachi, Vol. 9	Lag's hero, Gauche Suede, has returned to the Beehive–but not in the way Lag had hoped.While Gauche lies injured and unconscious, two mysterious government operatives show up to take him away, arousing the suspicions of the Beehive staff. What is the Amberground government trying to hide from the Letter Bees?	01KGBHAPF4N7RR3XXRQA4HQTRW	9.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 9	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_198KCPS3VFM0	CNT_0871WKSWT1F0	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 6	[]	Tegami Bachi, Vol. 6	Lag finds his long-lost hero Gauche Suede! But Gauche's heart is so depleted that he has no memory of his former self, and now goes by Noir the Marauder. Lag's only hope to recover the real Gauche is a special letter bullet that will convey Lag's heart to his friend. Lag's not sure how to go about writing the perfect letter, but his Letter Bee duties offer some good lessons in connecting hearts.	01KGBHAK9DNG3AM58C59QKPSZK	6.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 6	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1AT013ZSZ0N0	CNT_28WMX03MF2E0	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 8	[]	Tegami Bachi, Vol. 8	Lag arrives at the town of Lament determined to save the heart of his fallen hero, Gauche Suede. Gauche's rebel organization, Reverse, may be hiding out in the town's convent. To get in, Lag will have to use his wits, and he has no idea what—or who—awaits him there. Will this be Lag's chance to fire his Letter Bullet and restore Gauche's memories...or the end of his career as a Letter Bee?	01KGBHAMZWEZM7SYGAW39V3BN6	8.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 8	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1DS3Y9V67EV0	CNT_2BHYWXE59080	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 4	[]	Tegami Bachi, Vol. 4	Lag, now a Letter Bee rookie, meets Dr. Thunderland, Jr., a peculiar man who collects and catalogs the various Amberground species. When the doctor takes a particular interest in Steak, Lag and Niche have to hustle to keep him off the doctor's dissection table! The ensuing chaos pays off for Lag when the doctor reveals that Gauche—Lag's missing hero—paid the doctor a visit before he disappeared.	01KGBHAJ9B961ZK2KENPPS5RSB	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 4	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1HD4JG8N76K0	CNT_1MY6KJ021800	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 2	[]	Tegami Bachi, Vol. 2	Lag is close to becoming a Letter Bee! On the way to his final interview at the National Postal Service, he found a dingo: Niche, a feral young girl with shocking strength and hair made of golden swords. Now, as they approach the bridge to the middle-caste district, they stop to rest in Kyrie, a desperado town. They meet Nelli, a friendly young man who shows them to an inn. Nelli's so helpful that they never notice him steal Lag's crossing pass!	01KGBHAXVM2FKVX0RKTDZG90C0	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 2	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1M3QW3AZ35J0	CNT_3M8KKXPAC710	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 18	[]	Tegami Bachi, Vol. 18	Lag is reunited with his former boss, Largo Lloyd, now one of the leaders of the insurrection against the Amberground government. With Largo's help, Lag uncovers long-hidden secrets about his strange birth, the cryptic memories collected from children born on the Day of the Flicker, and the nature of Amberground itself. Meanwhile, Lag's partner Chico faces her own dark past...	01KGBHAWK46TFK5J5KS7MSJ4YV	18.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 18	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1RG6FP41F4H0	CNT_1QK0KFCJV620	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 16	[]	Tegami Bachi, Vol. 16	After years of searching, Zazie is on the trail of the Gaichuu that devoured his parents' hearts. But the hunt will force him to learn more about himself—and his past—than he ever imagined. And Emil, the kindly blind girl who runs the nearby inn, has an terrible secret...	01KGBHAT1830YYJJ2BQPYGVCGW	16.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 16	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_22HW38C0K9Y0	CNT_0C5ZY1VF8VN0	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 12	[]	Tegami Bachi, Vol. 12	As the ferocious Gaichuu Cabernet closes in on the capital of Amberground, the Letter Bees form an army to stop it. Lag is paired off with a novice Bee who informs him that he's become a legend in the Beehive. But Lag's reputation as the "Child of Light" won't do him much good against the terrifying power of Cabernet...or the dark secret he's discovered about his hero, Gauche Suede.	01KGBHABDTPKKM9PQ9JC1MZPCE	12.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 12	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2GFJ9WN83DT0	CNT_0AWBWF4DMZ90	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 1	[]	Tegami Bachi, Vol. 1	Gauche Suede is on his last delivery before a big promotion. In the outskirts of Yodaka, the darkest area of Amberground, Gauche is surprised to find that the package is a young boy named Lag Seeing. Lag had been traumatized by his mother's abduction and is due to be delivered to his aunt. In this remote area rife with Gaichuu, Lag and Gauche face a dangerous journey that inspires Lag to become a Letter Bee.	01KGBGK927HF6HJNP8ZJJPPK8F	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 1	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2Y3DHNJYQAZ0	CNT_2CV2YP56XWM0	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 14	[]	Tegami Bachi, Vol. 14	As Bees and ex-Bees alike gather in Yuusari, the rampage of the unstoppable Gaichuu Cabernet continues—and heart attacks only seem to make it more powerful. As it absorbs the attacks, Cabernet keeps morphing into stranger and more sinister forms. Meanwhile, a tragic accident triggers a different kind of transformation in Niche...	01KGBHACJK48TJYFFX45NK6YTZ	14.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 14	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_34JR8SCMH05G	CNT_197YDZ8G6JYG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 10	[]	Tegami Bachi, Vol. 10	With Lag out sick, Aria Link, second in command at the Beehive, takes over the job of delivering his letters. But even with Niche at her side, Aria finds that Amberground has become a dangerous place. Can she defend herself armed with nothing but a violin? Meanwhile, Lag's illness takes a strange turn...	01KGBHANRHJ60W4NGA75MFKBMN	10.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 10	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3B38TCEYXF4G	CNT_38JBDAYRNHZG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 7	[]	Tegami Bachi, Vol. 7	Lag has discovered that his long-lost hero Gauche Suede lost all of his heart, became tangled up in an anti-government organization called "Reverse," and is now known as "Marauder Noir." Noir's trail leads Lag and Niche to the icy northern town Blue Notes Blues. It just so happens Niche was born here. Lag and Niche uncover her mysterious origins: a sacred underground lake...where her brethren still dwell.	01KGBHAKSCBE5YCZJNM96T727M	7.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 7	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3FHV5Z80SEBG	CNT_1BWRCMK10GRG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 5	[]	Tegami Bachi, Vol. 5	In the town of Honey Waters, Lag seeks out "the Man Who Could Not Become Spirit," who might have information on the missing Gauche Suede. Lag's disappointed to find out that he's a charlatan. However, the heart of this strange man in this strange little town yields a surprising clue. Lag might be closer than he ever imagined.	01KGBHAJS9PGATAT7KDYZVCG92	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 5	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3QTFBTVT552G	CNT_2MKX3MV67QHG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 20	[]	Tegami Bachi, Vol. 20	What is the truth behind Amberground? As Lag and his friends descend to the center of their twilight world, they learn more than they ever dreamed possible. With civilization collapsing and the end of the world at hand, the time has come for Lag to lead the people of Amberground to hope and light at last.	01KGBHAXA9S95PXFXBES28VABJ	20.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 20	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3T8ZNDNW141G	CNT_0QYA36HEJPJG	Tegami Bachi CNT_2JFBCYDT0VDG	CNT_2JFBCYDT0VDG	2	1	1	Volume 17	[]	Tegami Bachi, Vol. 17	Lag now knows what he has to do to save Amberground: unite the five children born on the mysterious Day of the Flicker. And his latest delivery may lead him to vital information. But meanwhile Lag has to cope with his brash new partner, Chico, who insists that nothing will stand in her way to becoming Head Bee!	01KGBHATNP43XGP7T5WVEGB2HV	17.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Tegami Bachi, Vol. 17	TEGAMIBACHI © 2006 by Hiroyuki Asada/SHUEISHA Inc.	2024-11-26T08: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);