database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_2X4NNESCBVY0"

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_1G802NZRDNE0	CNT_3NCP0RW327EG	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 9	[]	As Miss Beelzebub Likes, Vol. 9	Amnesia, a deserted jungle, a wet and wild dinner, and a chat in a secluded garden—love takes the residents of Pandemonium to unpredictable places. Whether it’s the childhood friendship (?) of Samyaza and Eurynome, the fluffy innocence of Mullin and Beelzebub, the fireworks between Astaroth and Sargatanas, or the miscommunications of Azazel and Belphegor, it’s all about smitten demons making memories!	01KGA8X59V43YY5YFF2X1KZZ8H	9.0	2020-03-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 9	2020-04-28T07:00:00.000Z
PRD_1Y8P08NNBYZ0	CNT_340XSVJ5KT7G	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 6	[]	As Miss Beelzebub Likes, Vol. 6	If there's one thing to know about the new face around, Shemyaza, it's that he worships muscles. No wonder Azazel is his idol! Will his arrival bring winds of a new romance? The fluffiness continues in Volume 6!	01KGA74B8V4AR9AF485C3W33RG	6.0	2019-06-18T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 6	2019-06-18T07:00:00.000Z
PRD_23AY8CQ793CG	CNT_13PDAZ5XK8PG	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 4	[]	As Miss Beelzebub Likes, Vol. 4	Dantalion and Molech are one odd couple. In fact, they're such opposites, Mullin can't figure out if they actually get along! However, the bonds of friendship are anything but predictable in the underworld. Now if only Belphegor can overcome her bowels of hell and find a way to close the distance with her beloved Azazel!	01KG9AV8VQ87P77FKCN02BGWZD	4.0	2018-12-11T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 4	2018-12-11T08:00:00.000Z
PRD_26WC2C3G2AJ0	CNT_0VG5RANE2YJG	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 10	[]	As Miss Beelzebub Likes, Vol. 10	Whether it’s a diary, a cell phone charm, or even a glove, it’s not unusual for objects to communicate one’s feelings. Belphegor, Sargatanas, Beelzebub, and the rest of the demons of Pandemonium inch ever closer to revealing what lies deep in their hearts—if their hearts don’t jump out of their chests first!	01KG9CX433CJ7PX85J90CSW6HC	10.0	2020-07-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 10	2020-08-18T07:00:00.000Z
PRD_28A5RFKS28H0	CNT_17CE2W2WPCH0	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 3	[]	As Miss Beelzebub Likes, Vol. 3	Mullin is an unwitting target of seduction, Beelzebub and Belphegor aren't sure how much skin to show at the beach, and Sargatanas is worried about her own stony exterior. In other words, Pandemonium is brimming with passion like always--even if some residents don't want to admit it! Could Sargatanas's disgust with her good-for-nothing boss, Astaroth, be a sign of something else...?	01KGA572PRX6X9JG3C9T7D176R	3.0	2018-09-18T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 3	2018-09-18T07:00:00.000Z
PRD_2F9MG8QW87K0	CNT_1H7S77724H3G	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 12	[]	As Miss Beelzebub Likes, Vol. 12	Beelzebub has long cherished her close relationship with Mullin, but she has never understood that mysterious feeling inside her- until now. Can the newly awakened leader of Pandemonium overcome her ignorance in the ways of love? Can Mullin conquer his fear of not being Refined enough for her? As Miss Beelzebub Likes comes to a dramatic (and fluffy) finale!	01KG9F614G2ZHX3197TNZE40MJ	12.0	2021-04-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 12	2021-06-01T07:00:00.000Z
PRD_2JRSXQFA21EG	CNT_02SZDSJDCXQ0	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 7	[]	As Miss Beelzebub Likes, Vol. 7	Love makes the underworld go round, but Mammon—head of Pandemonium’s Department of Trade—is a devilish little imp who only loves money. It seems she’ll do anything to boost her bottom line, but even she can’t resist the urge to play matchmaker for her adorably foolish colleagues! Of course, nothing is stopping her from trying to do both…	01KGA7GH9PSN9362K16ZF6NY4B	7.0	2019-09-24T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 7	2019-09-24T07:00:00.000Z
PRD_2QK4NTCTEEDG	CNT_1QPJR4R272VG	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 11	[]	As Miss Beelzebub Likes, Vol. 11	Sargatanas and Astaroth have always viewed their relationship as purely professional, even if they’ve hoped otherwise. Playboy Astaroth skips out of work to flirt with girls, and Sargatanas keeps the office running while (violently) reeling him back in. But have their true feelings finally become too much to ignore? The fluffy demonic hijinks of Pandemonium are taking a turn for the dramatic…!	01KG9DEKP9T70DQH3T3MBBXZNY	11.0	2020-11-11T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 11	2020-12-08T08:00:00.000Z
PRD_34Z39NA8WCGG	CNT_0M1802D6Z7QG	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 1	[]	As Miss Beelzebub Likes, Vol. 1	Beelzebub--the formidable right hand of Satan--commands fear and respect throughout Pandemonium. What her underlings don't realize, though, is that she's an airhead with a love for all that is fluffy and adorable! The only thing she might enjoy more is teasing her new attendant, Mullin, who is learning that serving Beelzebub is both heaven and hell...	01KGA3MFA83QDY58VTN0H09DQ1	1.0	2018-04-24T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 1	2018-04-24T07:00:00.000Z
PRD_369M6MVQBH10	CNT_3J7JCYJRH610	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 2	[]	As Miss Beelzebub Likes, Vol. 2	As the archdemon Beelzebub's attendant, Mullin is constantly reminded of just how quirky his boss can be. However, he's quickly learning that Beel is not the only eccentric running Pandemonium! Whether it's the frivolous playboy Astaroth, the perpetually sleepy Dantalion, or Eurynome and her...dangerous tastes, it's a wonder anything gets done at all!	01KGA4R8P0T8TCZZTMVCYDB7J6	2.0	2018-06-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 2	2018-06-26T07:00:00.000Z
PRD_3FC0Z0HQH27G	CNT_22M49A5TEYE0	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 5	[]	As Miss Beelzebub Likes, Vol. 5	Love is ever daunting for the awkward demon girls of Pandemonium, and the subtle twists and turns of daily life aren't making things any easier! Is Sargatanas strong enough to wear a skirt for an impromptu part-time job? Can Belphegor's bladder endure the mere mention of marriage? Will Beelzebub's life be forever changed by fried chicken?! No matter the challenges, these fallen angels refuse to stay down!	01KGA6KHYCKQT2Z1HMWREMRQE5	5.0	2019-03-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 5	2019-03-26T07:00:00.000Z
PRD_3P3XY6NS8G10	CNT_07AXY27Q21VG	As Miss Beelzebub Likes CNT_2X4NNESCBVY0	CNT_2X4NNESCBVY0	2	1	1	Volume 8	[]	As Miss Beelzebub Likes, Vol. 8	Whether it’s the arrival of a stray toy poodle or the prospect of a burly-bodied romance, demonic hearts are all aflutter in Pandemonium! Mullin and Beelzebub are no exception, especially when a day of work turns into a trip to the aquarium. Two people…out alone together…What was that called again…?	01KGA7RZ3YJHQCJC9M5HPMT0CJ	8.0	2019-12-06T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	As Miss Beelzebub Likes, Vol. 8	2019-12-17T08: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);