database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_0XP9BSVKXD3G"

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_10S6S4DCSKH0	CNT_2BBC6HCVK7H0	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 6	[]	Emma, Vol. 6	Choosing love in spite of their difference in class, William and Emma have nothing but turbulent times ahead of them. But in order to pursue their joint future, William must face the Viscount and break his engagement... Surely nothing good can come from angering one of society's fiercest...?	01KGA5FEVQ40TNQTH39BHZMAZS	6.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 6	2018-11-27T08:00:00.000Z
PRD_1BW1PA8S1HQ0	CNT_2DZP6EQCD5K0	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 3	[]	Emma, Vol. 3	Not wishing to cause a scandal within the Joneses' household, Emma chooses to make a clean break from her old life and takes a train to the sea. As chance would have it, Emma finds herself sharing a car with another maid, one who serves at a large manor in the country. A big house bustling with servants seems an ideal place in which to move forward after losing her mistress and leaving her love back in London. Learning the precise dance of domestic service in her new environment is a welcome challenge, but how long can hard work divert Emma's mind from the longing of her heart?	01KGA5F6C156R87K66BWQYDJ1T	3.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 3	2018-11-27T08:00:00.000Z
PRD_1D33CG459ZN0	CNT_2CMG1A3X73X0	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 1	[]	Emma, Vol. 1	Calling upon his former governess, William Jones, gentleman, is startled when his knock is answered by an uncommonly beautiful servant, the soft-spoken Emma. Throughout his visit, William's eyes drift to the maid whenever she enters the room, and he contrives to meet Emma socially as she goes about her errands. But London society is a web of strict codes and divisions. For the son of a wealthy merchant, seeking out a working-class girl is simply not done! William's father plans for his son to marry into the peerage and elevate the Jones family to greater heights, but although William says and does what is expected of him, he longs only for Emma's company...	01KGA3S5X6WXZPMCCFP7J85110	1.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 1	2018-11-27T08:00:00.000Z
PRD_1EJG1XA3DGP0	CNT_0DA31RDMR4W0	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 10	[]	Emma, Vol. 10	At the end of the 19th century, the tale of one beautiful Victorian romance draws to a close. As their tale draws to an end, will the maid and the gentleman have become simply the Joneses? The moment of truth arrives in the final volume of Kaoru Mori's award-winning Emma.	01KGA5F3DA136NNVR1C9JX6FVD	10.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 10	2018-11-27T08:00:00.000Z
PRD_1ST7WYH0HNK0	CNT_28P27M0AS9Q0	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 8	[]	Emma, Vol. 8	Continue with Emma and William's story through the lives of those around them -- the young and newlywed Mrs. Stowner's visit to the Crystal Palace, the healing of Eleanor's broken heart, and more in this volume to transport you back to Emma's England!	01KGA5FPK18F732495T9GVPMSB	8.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 8	2018-11-27T08:00:00.000Z
PRD_316EJEZJ7J0G	CNT_3B02PT7ZSQ2G	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 5	[]	Emma, Vol. 5	Despite each resolving to put the other from their minds, Emma and William's unexpected meeting has rekindled the embers of their love for each other. Though with William engaged to the daughter of a viscount--an ideal match in society's view--the two will face unbending opposition and many difficult decisions if they wish to pursue a future together. Mrs. Trollop is sympathetic to their plight, but even though she is fond of Emma and wishes every happiness for her son, she knows firsthand how unforgiving the upper classes can be to those who do not adhere to their standards...	01KGA5FD6KTZV88KE7MSKSH299	5.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 5	2018-11-27T08:00:00.000Z
PRD_32HY0T2FVK1G	CNT_1BNNQ8HQAR1G	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 7	[]	Emma, Vol. 7	With the postmark of Emma's last letter--and his heart--guiding him, William makes a bold journey across the Atlantic to begin his search for Emma in the town of Burnley in the United States. Even if he finds her among the hundreds of new arrivals from England, the life ahead of them will not be an easy one. The broken engagement of the Viscount's daughter has set him--and, through him, all of London society--against the Joneses, and it will take time to rebuild those business and social relationships. Even more difficult will be convincing society that Emma is worthy to join their ranks despite her humble origins. With dogged persistence, patience, and a little help from Mrs. Mölders, Emma and William aim to carve out a place in this world where their love can thrive at last!	01KGA5FGJT4SEAK7XY4ZMBWT5B	7.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 7	2018-11-27T08:00:00.000Z
PRD_35MSX1SM3H7G	CNT_1AAZP5W84P3G	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 4	[]	Emma, Vol. 4	William struggles with Emma's departure still, despite his resolve to act as his family expects him. However, an unexpected moment at the opera opens his eyes to the lovestruck Eleanor... Has his heart turned or will a surprise guest at a family party bring back the roaring flames of love?	01KGA5F8CY1R8V9SX61X1HNK2B	4.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 4	2018-11-27T08:00:00.000Z
PRD_38588MVYFG6G	CNT_3DNCHQJGKNCG	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 2	[]	Emma, Vol. 2	Emma and William meet at the Crystal Palace to finally spend an afternoon together, testing their delicate feelings for one another, despite the fact that their different social statuses mean their love is forbidden. Will they be able to put their feelings aside for the sake of social acceptance? But more importantly, will William's father...?	01KGA5F4SA2E4ANB9VT0FWXAXM	2.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 2	2018-11-27T08:00:00.000Z
PRD_3VJZBM63KN3G	CNT_191BQK56GT7G	Emma CNT_0XP9BSVKXD3G	CNT_0XP9BSVKXD3G	2	1	1	Volume 9	[]	Emma, Vol. 9	This collection gathers the stories of those whose lives have touched Emma and William as the two take strides toward a future they can share together. From the daily trials of the Mölders family and staff to the beginning of William's unusual friendship with Hakim, these chapters serve to flesh out the world of Emma. When this volume draws to a close, will the maid and the gentleman have become simply the Joneses? The moment of truth arrives in the final volume of Kaoru Mori's award-winning Emma.	01KGA5FR4CJ59S727XWWPNDTWV	9.0	2018-11-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Emma, Vol. 9	2018-11-27T08: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);