database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_0ZZYGS27555G"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0VX27ZG26DC0	CNT_19TQWY6QE82G	Blue Giant Omnibus CNT_0ZZYGS27555G	CNT_0ZZYGS27555G	2	1	1	Vols. 5-6	[]	Blue Giant Omnibus Vols. 5-6	At long last, Dai finally forms his own band. After months of practicing alone in Tokyo, Dai meets a brilliant pianist named Yukinori. In some ways, the two of them couldn't be more different: Dai's all about passion an inspiration, while Yukinori values perfect technique. It'll take some adjusting for Dai to appreciate Yukinori's feelings about music...and to find a third man for their group. The award-winning story of a young man's journey into the soul of jazz continues!	Maiden Voyage	01KG9FHVEJWSPXTMMM7R3R77SD	5.0	2021-05-25T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1MP5F77DVBZG	Blue Giant Omnibus Vols. 5-6	2013 Shinichi ISHIZUKA	2021-07-27T07:00:00.000Z
PRD_16ZMF1Y4XYJ0	CNT_3R7A33HKN2H0	Blue Giant Omnibus CNT_0ZZYGS27555G	CNT_0ZZYGS27555G	2	1	1	Vols. 7-8	[]	Blue Giant Omnibus Vols. 7-8	Dai's band of teenage musicians finally has a name: "Jass," a throwback to the early days of jazz. They're pulling in crowds, too, winning their first-ever payday and the jealousy of an older band. But Yukinori isn't content just to play clubs. He's got his sights set on the biggest venue in all of Tokyo, hoping to put them on the map with a sensational performance from a group of young unknowns. Yukinori may be a technical genius, and Dai may have a sound no one can match, but with an amateur drummer and limited repertoire, can they really hope to hit the big time?	LIVE IN JAPAN	01KG9HEE6VD4EJAMMVFYP6TE8E	7.0	2021-11-26T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1MP5F77DVBZG	Blue Giant Omnibus Vols. 7-8	2013 Shinichi ISHIZUKA	2022-01-04T08:00:00.000Z
PRD_203X1HGG7MPG	CNT_3NSMCHDVKEF0	Blue Giant Omnibus CNT_0ZZYGS27555G	CNT_0ZZYGS27555G	2	1	1	Vols. 3-4	[]	Blue Giant Omnibus Vols. 3-4	Dai is determined to become the best jazz player in the world, but dreams don't come easy--and a whole lot get broken on the way. While his music teacher Yui drills him relentlessly on technique and theory, Dai prepares to take his stand. Everyone at the school festival goes wild for rock and pop, but Dai takes the stage with tenor sax in hand. Does his solo jazz have what it takes to win over a hostile crowd?	GIANT STEPS	01KG9E0YPZN77CNHQ7J5N1NYZR	3.0	2021-04-06T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1MP5F77DVBZG	Blue Giant Omnibus Vols. 3-4	2013 Shinichi ISHIZUKA	2021-04-20T07:00:00.000Z
PRD_25CVTK4J1SWG	CNT_0M6Y50MFYDMG	Blue Giant Omnibus CNT_0ZZYGS27555G	CNT_0ZZYGS27555G	2	1	1	Vols. 1-2	[]	Blue Giant Omnibus Vols. 1-2	Dai lived a normal high school life in Sendai: a city of hot summer days and rainy nights. Between basketball, part time jobs, and an uncertain future, something was missing. And that thing was music. With his days in senior year running out, Dai swears a heartfelt vow: "I'm gonna be the best jazz player in the world." But what do you need to be the best? Talent? Effort? A lucky break? Or maybe just a deep, pure love for music, and too much stubbornness to know when to quit.	Jazz hit him like a thunderbolt.	01KG9CG8ZNKDCSVJCD8ESVQ9XD	1.0	2020-12-15T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1MP5F77DVBZG	Blue Giant Omnibus Vols. 1-2	2013 Shinichi ISHIZUKA	2021-01-07T08:00:00.000Z
PRD_37G52PXTQM40	CNT_1MTFZZRN5TJG	Blue Giant Omnibus CNT_0ZZYGS27555G	CNT_0ZZYGS27555G	2	1	1	Vols. 9-10	[]	Blue Giant Omnibus Vols. 9-10	Dai, Tamada, and Yukinori have taken their jazz trio to the next level as the opening act for a famous, established group. In front of their biggest audience yet, they face down a tepid crowd and condescending band by unleashing everything they've got. But even that victory isn't enough for Yukinori. He's always had his sights on the big time: So Blue, Tokyo's hottest jazz club. His first attempt to get the band on that stage ended in humiliation, but fate has an unexpected opportunity in store, not to mention unexpected challenges...	KIND OF BLUE	01KGAEXH04799SEVHY451SXQV3	9.0	2022-03-10T08:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1MP5F77DVBZG	Blue Giant Omnibus Vols. 9-10	2013 Shinichi ISHIZUKA	2022-03-22T07: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);