database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_0N4QPGVVV9XG"

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_0A1BC887VGPG	CNT_1C5JQRE7FAF0	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 2	[]	With the Sheikh in His Harem 2	Sanagi used to be a normal high-school teen, but now she's in the harem of Lui, powerful Sheikh and second prince of the kingdom of Armadia. His constant advances on her, day and night, leave her feeling hopelessly lost...and even worse, she's kidnapped by Adil, crown prince and Lui's political rival! Can royal love find a way for Sanagi to keep going...without getting smothered in love?	01KG9F8P4TVCQ89GR2EB73PG5J	2.0	2021-05-12T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 2	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-06-01T07:00:00.000Z
PRD_0P819625WYJ0	CNT_3TSVZB7HTRCG	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 4	[]	With the Sheikh in His Harem 4	Now that she's formally married to Prince Lui of Armadia, average high-schooler Sanagi is far from average any longer. But now Lui's harem is invaded by Aila, a powerful, well-connected girl seeking to be his concubine! What's more, they're now all traveling to the countryside—along with Prince Adil, Lui's top political rival! Can Sanagi and Lui's love survive this maelstrom of romance unscathed? The four-way web of royal love grows ever more intense in Volume 4!	01KG9GFNNEBS255S71H638FV54	4.0	2021-07-21T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 4	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-08-03T07:00:00.000Z
PRD_0TBYRAX7FQH0	CNT_3GZQM27HRAZG	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 7	[]	With the Sheikh in His Harem 7	Sanagi and Prince Lui of Armadia are once again a happily-wedded couple...but unbeknownst to them, the conspiracy enveloping the court is growing more and more intense. Adil, the crown prince, is targeted by an assassin—and before Sanagi knows it, she's fleeing with him into the desert! And as they take shelter in the freezing night, the wounded Adil makes his advance upon her! Will Lui's jealousy consume him? The love triangle is just as hot as the court intrigue in Volume 7!	01KG9H90NHK1YQ2W29GS8HWMYZ	7.0	2021-10-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 7	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-11-02T07:00:00.000Z
PRD_1F05ZYSVTH2G	CNT_09514QH9ZND0	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 8	[]	With the Sheikh in His Harem 8	To expose the evil group conspiring against the palace, Sanagi ventures into their base alone...only to find a surprising figure waiting for her! Now she's surrounded by enemies and in big trouble--but Lui makes one shocking move to save her... Lui's secret, and Adil's true intentions, are finally revealed! And what'll happen to Sanagi's love in the midst of this torrent?! Find out in the dramatic climax in this final volume of royal love!	01KG9HD995YBXA2607TMXDPJWN	8.0	2021-11-17T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 8	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-12-07T08:00:00.000Z
PRD_1MA90XNVHBQ0	CNT_3J2M1W0GRESG	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 6	[]	With the Sheikh in His Harem 6	Sanagi and Lui the sheikh have finally become a couple...but when Lui's stabbed while defending her, he winds up losing his memory! Despite the schemes of her rival Aila, Sanagi manages to reunite with him...but Lui's decided that Aila will be her bride. As preparations for the wedding continue apace, does the abandoned Sanagi have any way to stop the event?! Plus: The secret behind the power of the royal family is revealed... The core behind the story is revealed in this dramatic tale of royal honeymooners!	01KG9H1XB0ER7RV6DC34P1WVBM	6.0	2021-09-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 6	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-10-05T07:00:00.000Z
PRD_2D7TWC6SWD8G	CNT_3BBWQRJWQ1Q0	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 5	[]	With the Sheikh in His Harem 5	After high-schooler Sanagi marries desert prince Lui, the two of them are attacked far from the palace by an assailant! Lui sacrifices himself to save the day, but the fallout leads to serious changes in their romance! And, of course, their rivals—Lui's would-be paramour Aila and brother Adil—are ready to pounce upon this weakness. Life's harder in Armadia than ever before for Sanagi! What's going to happen in a harem packed with love and strife?!	01KG9GQHSTDMMD2XKX1V9TR4M6	5.0	2021-08-19T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 5	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-09-07T07:00:00.000Z
PRD_3BRC519RYXRG	CNT_33B1RDQ0Y7N0	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 1	[]	With the Sheikh in His Harem 1	Sanagi loves nothing more than money—not even love. After all, it's what keeps her small family going. But when a chance encounter with a stranger leads her to push away his offer of riches, she wonders if she's gone crazy...and starts to believe she really has when he reveals that he's a Sheikh, and proposes to her! She rejects him, but soon finds out that a marriage with him might be the only way to keep her family safe...!	01KG9E68G4TCYG0MXQFNEF7S7H	1.0	2021-04-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 1	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-05-04T07:00:00.000Z
PRD_3DE9QZPXK2NG	CNT_247A5DH6FW80	With the Sheikh in His Harem CNT_0N4QPGVVV9XG	CNT_0N4QPGVVV9XG	2	1	1	Volume 3	[]	With the Sheikh in His Harem 3	Former high-school student Sanagi is now in the harem of Rui, sheikh and second prince of Armadia. His passionate wooing of Sanagi ("Everything within me has a deep desire for you") slowly grabs her heart...but now she's in danger of being sent to the harem of his brother Adil, the crown prince and a man who only sees her as a toy! Is there any escape from this other sheikh's playland?!	01KG9FNYTG2BVYN8RW1X4G4A1J	3.0	2021-06-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	With the Sheikh in His Harem 3	With the Sheikh in His Harem Rin Miasa/Kodansha Ltd.	2021-07-06T07: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);