database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_0NTYGDNN1BYG"

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_11ZXCV8Y9T80	CNT_1MEJ8N8DYDB0	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 2	[]	GA: Geijutsuka Art Design Class, Vol. 2	Now armed with basic color theory, Kisaragi and friends are ready to play and experiment with tones and new tools! But when the school art club, led by the upperclassman who inspired Kisa-chan to attend G.A., is in danger of being shut down, will the Color Rangers (minus the disguises) save the day!? Well, as long as Kisa-chan's clumsiness, cooking experiments, and badminton battles don't get in the way...	01KG984C4NA1VE76SFS6009H3C	2.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 2	2016-08-18T15:00:00.000Z
PRD_1X9218EMDV90	CNT_3N459BJ5KEA0	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 4	[]	GA: Geijutsuka Art Design Class, Vol. 4	It's time once again for art school, full of the spirit, love, and laughter! The GA girls return to class, shifting their focus to the history of Western fashion and textiles. But as with every serious art lesson in this department, crazy antics (not to mention a game of dress-up and a food fight) are never far off! And when the GA welcomes a new face, will they scare off the new girl and make her hightail it back to her homeland?!	01KG984K9GWCR0MNY11CKN50J8	4.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 4	2016-08-18T15:00:00.000Z
PRD_2BKZNY0KT6R0	CNT_0B49HBM2T8V0	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 7	[]	GA: Geijutsuka Art Design Class, Vol. 7	As the GA third-years prepare for graduation and the future, an era comes to an end. How will their impending departure affect the underclassmen? And when the time comes to say good-bye, what emotions will fill Kisaragi's heart? The girls of GA: Geijutsuka Art Design Class say farewell in this final volume full of laughter, heart, and lots and lots of art!	01KG9YQZQ8ERF1GX7VY4VPR01R	7.0	2017-01-19T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 7	2017-01-19T15:00:00.000Z
PRD_2FXXRHVAKQSG	CNT_0YXNRT8FP9TG	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 6	[]	GA: Geijutsuka Art Design Class, Vol. 6	As autumn descends on Kisaragi and her colorful GA friends, the gang goes on a trip...through time! Art history takes center stage as festival season approaches at school, providing the girls with numerous opportunities to display their talents (and madcap antics)! The year might be winding down, but the spirit of the GA class is only just kicking into high gear!	01KG98AP10MVJCN4W532W7PEQ9	6.0	2017-01-11T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 6	2017-01-11T15:00:00.000Z
PRD_33PAVJSSBVRG	CNT_0MSVSCD9SXVG	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 3	[]	GA: Geijutsuka Art Design Class, Vol. 3	It's time for fun and fonts with Kisaragi and the rest of the memorable GA cast as they dive into the world of commercial design! But in a whirlwind of typography, photography, pictograms, and illustration (among other things), will the girls ever get any of their work done?! And with the Art Club and their...erm, unique projects running wild, leaving hijinks in their wake and distracting the GA girls, will a secret revelation about Tomokane completely blindside the group?!	01KG984H5GBA7549PDJJ4CCS5R	3.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 3	2016-08-18T15:00:00.000Z
PRD_367555V3QTZG	CNT_2M48RY3J4X4G	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 1	[]	GA: Geijutsuka Art Design Class, Vol. 1	It's Kisaragi's first year in G.A.: the specialized art and design department at her high school. The timid Kisaragi has a lot to learn, but with the help of a very unique group of friends, even the most difficult lesson becomes loads of fun - if not downright silly! With the aid of full-color pages throughout, you too can learn the basics of color theory and become a great artist yourself! Satoko Kiyuduki, creator ofShoulder-a-Coffin Kuro, melds art class and manga in a whole new way!	01KG6ZH0NP9G4CNK6NBEMSGAB7	1.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 1	2016-08-18T15:00:00.000Z
PRD_3Z1T8ZZQFWSG	CNT_2NFES2Q1AYTG	GA: Geijutsuka Art Design Class CNT_0NTYGDNN1BYG	CNT_0NTYGDNN1BYG	2	1	1	Volume 5	[]	GA: Geijutsuka Art Design Class, Vol. 5	C'mon, GA students-sketchbooks at the ready! Kisaragi and friends are all set for some fun in the sun! "Inspired" by their summer housework assignments, the friends enjoy their vacation by going to a baseball game, the beach, and a summer festival. But as their time off draws to a close, will the gang be able to adjust once again to school life?!	01KG984MGVMXZM00WSTZMZ62Y3	5.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	GA: Geijutsuka Art Design Class, Vol. 5	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);