database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_1QQPD3JGWPM0"

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_1TXJJQNX34FG	CNT_39NWR8R4G8SG	Girls Kingdom CNT_1QQPD3JGWPM0	CNT_1QQPD3JGWPM0	2	2	1	Volume 3	[]	Girls Kingdom: Volume 3	There's never a dull moment in Misaki's life as a maid at Amanotsuka Academy for Girls. Her first paycheck is a cause for celebration, but when she has to find the perfect thank-you present for Himeko, she just can't decide! Then a spooky mystery haunts the school, with students claiming to have seen a ghost in the woods. It's up to Misaki to brave the danger and find out if there really is a spirit among them! If all that wasn't hubbub enough, there's a new lady on campus, and she's an exchange student. In fact, she's the former mistress of Misaki's British classmate. The Sky Salon wants to recruit her, but it seems like she's in high demand—even from an unexpected party. Surprises and revelations are afoot!		01KG9DZQSJJZ8CJ22EA894BAQY	3.0	2021-03-03T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Girls Kingdom: Volume 3	Copyright (C) 2020 Nayo Illustrations by Shio Sakura	2021-06-21T07:00:00.000Z
PRD_2D5ZGSZ1WXX0	CNT_1PXA1XXVHQHG	Girls Kingdom CNT_1QQPD3JGWPM0	CNT_1QQPD3JGWPM0	2	2	1	Volume 4	[]	Girls Kingdom: Volume 4	It's a battle of the salons! At the school for mistresses and maids, three groups are vying for the new girl's attention. Will Sakura join the Sky Salon, the Paradise Palace, or the Gloriana Guesthouse? Kagura, head of the Sky Salon, is determined to beat the competition fair and square. It's a battle of wits, ambition, and—believe it or not—homemade confections. Plus, the mystery of who spread the word about Sakura's arrival is solved. During summer vacation, a new problem arises. Matsuri, a Seraph who's been working hard to pay off her family's debts, suddenly finds herself spurned by her cruel mistress. Misaki's determined to help, but what can she and Himeko do? This vacation's going to be anything but relaxing!	It's a battle of the salons as three of them compete to win over new arrival Sakura. Will she join the Sky Salon, the Paradise Palace, or the Gloriana Guesthouse—and will homemade sweets be the deciding factor?!	01KG9FKXT6PB0MTZCWVF1CNX4S	4.0	2021-06-07T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Girls Kingdom: Volume 4	Copyright (C) Nayo 2017 Illustrations (C) Shio Sakura 2017	2021-08-30T07:00:00.000Z
PRD_2E6WF5PR8A50	CNT_3TVJNTTFBZFG	Girls Kingdom CNT_1QQPD3JGWPM0	CNT_1QQPD3JGWPM0	2	2	1	Volume 1	[]	Girls Kingdom: Volume 1	All Misaki wanted was a free education. Instead, she accidentally lands an exclusive contract with the most prestigious girl in school... to serve as her personal maid! Misaki soon discovers that Amanotsuka Academy for Girls is no ordinary school—her classes are all about how to be a maid, too! Students who impress the school's elite young ladies with their domestic service skills might be lucky enough to become a "Seraph," guaranteeing them a job with an upper-class household after they graduate. But Misaki doesn't want to be a maid; she just wants to study hard, go to college, and work for a good company. So why did Himeko make her into her Seraph out of nowhere? What kind of rich girl hires a maid who wants nothing to do with the job?! If she wants to get through high school, Misaki has a lot to get used to!	All Misaki wanted was a free education. Instead, she accidentally lands an exclusive contract with the most prestigious girl in school... to serve as her personal maid! Misaki soon discovers that Amanotsuka Academy for Girls is no ordinary school—her classes are all about how to be a maid, too! Students who impress the school's elite young ladie...	01KG9CE1HBHH3F20J581QZDW03	1.0	2020-10-13T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Girls Kingdom: Volume 1	Copyright (C) 2020 Nayo Illustrations by Shio Sakura	2020-12-23T08:00:00.000Z
PRD_3YM796VQ636G	CNT_185C6PP2C7JG	Girls Kingdom CNT_1QQPD3JGWPM0	CNT_1QQPD3JGWPM0	2	2	1	Volume 2	[]	Girls Kingdom: Volume 2	A month after arriving at Amanotsuka Academy for Girls, Misaki is getting used to her new life as a maid, even if it's not what she was expecting. She's even gotten to meet a whole host of new faces, friendly and otherwise! However, there's trouble in store when a head maid is chosen for their class: a British exchange student named Sarah. When she judges Misaki and her friend Kirara on their domestic service skills and finds them lacking, things start to look bleak! That's not all—the staff of Erisu's École Kitchen, a restaurant on campus, have fallen out of their mistress' favor due to their dismal customer turnout. If business doesn't pick up, not only will they never be made into Seraphs, they'll lose their maid contracts altogether! Misaki wants to help, but what can she possibly do?	Misaki's life at a school for maids is filled with one challenge after another. After her skills are judged by her class' head maid, she then has to help out a struggling restaurant!	01KG9DK5H055FV26TWZRC6C8PF	2.0	2020-12-14T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Girls Kingdom: Volume 2	Copyright (C) 2020 Nayo Illustrations by Shio Sakura	2021-03-13T08: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);