database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_2JG1G3ZCJCXG"

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_05KP73YD9J00	CNT_1HVTCBTAQN30	K-ON! CNT_2JG1G3ZCJCXG	CNT_2JG1G3ZCJCXG	2	1	1	College	[]	K-ON! College	Yui, Mio, Ritsu, and Tsumugi embark on their college adventures! It will take some time for the girls to get used to life away from their families and adjust to the pace of college life, but there's one aspect of their new situation that there's no uncertainty about-joining the pop music club! But they aren't the only high school band making their debut on the college scene. Is Afterschool Tea Time ready to perform alongside the hard-rocking rhythms of The Girlz?!	01KG984Z4KZTZY3AE7XPERXTW6	6.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	K-ON! College	2016-08-18T15:00:00.000Z
PRD_0806JPVQNH70	CNT_3H5QFNGK2MC0	K-ON! CNT_2JG1G3ZCJCXG	CNT_2JG1G3ZCJCXG	2	1	1	Volume 3	[]	K-ON!, Vol. 3	As the dawn breaks on a new year, Azusa decides it's time for the girls of the Pop Music Club to tuck away their tea and cakes. Pick up their instruments! And bring the rock 'n' roll with another performance! But even though Afterschool Tea Time is starting to sound like a real band, Mio's stage fright is going to make any live show tricky. What better way to cure shyness than with a part-time job?! At a maid café?!	01KG984WKTRNPX0AKW0DG80EJJ	3.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	K-ON!, Vol. 3	2016-08-18T15:00:00.000Z
PRD_0CPHW9NSHG60	CNT_1GG4F76VHKD0	K-ON! CNT_2JG1G3ZCJCXG	CNT_2JG1G3ZCJCXG	2	1	1	Volume 1	[]	K-ON!, Vol. 1	When their high school's pop-music club is about to be disbanded due to lack of interest, four girls step up to fill the membership quota. Unfortunately, lead guitarist Yui Hirasawa has never played an instrument in her life. Ever. And although she likes the idea of being in a band, standing in front of the mirror posing with her guitar is a lot easier than actually playing it. It's gonna be a while before this motley crew is rocking out, but with their spunk and determination cranked to 11, anything is possible!	01KG6ZH3EXJEAD99BMKHYB5R5E	1.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	K-ON!, Vol. 1	2016-08-18T15:00:00.000Z
PRD_27AEESF8BKGG	CNT_0Y63W2Z6H5KG	K-ON! CNT_2JG1G3ZCJCXG	CNT_2JG1G3ZCJCXG	2	1	1	High School	[]	K-ON! High School	As the only member of the pop music club not to graduate, the responsibility of recruiting new members has fallen to Azusa. Ui and Jun have agreed to help out their friend, but they might be more interested in having actual afterschool teatime than making music. Even when Azusa secures the necessary four members to keep the club alive, the lack of musical experience (and musical instruments) is going to be a challenge! Will the high school pop music club survive to take the stage once more?!	01KG984ZRGBRPYV6TGX6J8RKQE	5.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	K-ON! High School	2016-08-18T15:00:00.000Z
PRD_2BRYRC8JQJQG	CNT_2HGGWCNEW4WG	K-ON! CNT_2JG1G3ZCJCXG	CNT_2JG1G3ZCJCXG	2	1	1	Volume 4	[]	K-ON!, Vol. 4	As the second school term begins, so do preparations for the upcoming school festival! The Pop Music Club starts working on some fresh lyrics as they tune up their act for their live show. But the third-year girls find themselves practicing for a performance of another kind when Ritsu and Mio are selected to play the lead roles in their class production of Romeo and Juliet! With the rest of the girls tied up in play rehearsal, Azusa spends her afternoons alone in the clubroom...Will the show be ready to go on?!	01KG984YMKEKJW3HVXPMHTX2GH	4.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	K-ON!, Vol. 4	2016-08-18T15:00:00.000Z
PRD_2E99BZAMKHPG	CNT_0GVDZYBQB3XG	K-ON! CNT_2JG1G3ZCJCXG	CNT_2JG1G3ZCJCXG	2	1	1	Volume 2	[]	K-ON!, Vol. 2	It's been almost a year since the girls of the pop-music club started jamming together, but the start of the new year is no time to look back on their journey - it's time to recruit new members! Despite their inexperience, the girls' passionate performance at the entrance ceremony impresses first-year Azusa, a budding guitar player who can't wait to join. But she didn't expect there to be so much tea drinking in the pop-music club. Or cosplaying...When do they get around to making music?!	01KG984VV0J07MPJYFMM6T9BX9	2.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	K-ON!, Vol. 2	2016-08-18T15: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);