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_0S4AVWH5QR7G"

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_0SWG3RZD38N0	CNT_1TDC15NSPTQ0	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 7	[]	My Idol Sits the Next Desk Over! 7	Chihiro is taking a break from her job, and it's hard to know what to say to her. And Sakiko has been awkward around her since she stepped back from her idol work. Then there's Maaya, who was so desperate for Chihiro not to call it quits, she came clean about her unscrupulous past as a fan. What path will these three take after high school graduation? The trio's unforgettable high school days finally come to a climax!	01KGB693Z956576SC24AQ3KZ3E	7.0	2023-04-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 7	Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2023-05-02T07:00:00.000Z
PRD_0ZYF6F0RKJHG	CNT_0DJNHKS7FZ40	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 5	[]	My Idol Sits the Next Desk Over! 5	Chihiro is appearing in a TV drama, so she's supposed to be practicing her acting. But is Maaya really going to kiss her?! Witnessing Maaya's affection for Chihiro, Sakiko feels a tangle of emotions. Meanwhile, Chihiro is shocked when she sees the script and her part! Sakiko and Maaya are glad their idol's career is taking off, but it's complicated...things aren't so simple in Volume 5!	01KGAJHBANJJDBWNNPRB44H5HQ	5.0	2022-08-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 5	My Idol Sits the Next Desk Over! Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2022-09-06T07:00:00.000Z
PRD_24QBFCH7R6CG	CNT_1EX88DMN3KJG	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 6	[]	My Idol Sits the Next Desk Over! 6	Sakiko has taken a crack at her first photo contest! To become the very best idol photographer, she's putting in some serious effort! Then, while Maaya has mixed feelings about it, she and Chihiro prepare a birthday surprise for Sakiko? Every day is more exciting when your idol is around! This is girlhood at its peak, and these three are in the thick of it in Volume 6!	01KGB4HK24CS0D4E3TK7GG1TRY	6.0	2023-02-14T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 6	Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2023-02-28T08:00:00.000Z
PRD_2622YZ57APKG	CNT_2ABJPEGB6TGG	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 1	[]	My Idol Sits the Next Desk Over! 1	Chiro-chan is a world-class idol...at least, to Sakiko Manaka, your run-of-the-mill hard-core idol fan. So when Chiro—real name Chihiro—ends up sitting next to her in school, Sakiko's world is turned upside-down, and all her brain cells vanish. After all, how can she concentrate when her absolute fav is just inches away?! But she needs to be on her A-game, because she may not be the only one who is totally gaga for Chihiro...	01KGADFRCHZ00EA424ST4VHXX7	1.0	2021-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 1	My Idol Sits the Next Desk Over! Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2022-01-11T08:00:00.000Z
PRD_2EBF8MQCC1EG	CNT_2Z48BDA3ZQZ0	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 3	[]	My Idol Sits the Next Desk Over! 3	Her smile, shining dazzlingly bright...Her voice, boldly resounding throughout the large venue...Her brave figure, dashing through the colorful light sticks—Sakiko's idol is just too precious! Her classmate Tanaka-kun threw all caution aside and confessed his crush to Chihiro (after Sakiko and Maaya drove him to do it). Convinced a plain guy like himself would be a nobody in her eyes, he charged ahead, prepared for certain rejection. But did Chihiro's cheeks really just turn red?! And will Sakiko sort out her inner turmoil about the idol she adores also being her friend?	01KGAEW35HF16NXG2GH890J5HS	3.0	2022-02-25T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 3	My Idol Sits the Next Desk Over! Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2022-03-15T07:00:00.000Z
PRD_2TEK8XP3MKVG	CNT_2E25SEVCB920	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 4	[]	My Idol Sits the Next Desk Over! 4	At last, Sakiko's summer vacation has arrived—her first since starting high school. This summer is positively packed with Spring Shine events, and she has a feeling it's going to be awesome! But at the summer rock fest where Spring Shine is performing, she runs into Kasumi, the classmate who made fun of Chihiro before! What will go down when the hater comes face-to-face with the fan?! With Spring Shine's solo concert, a summer festival, and Maaya's birthday all happening too, this summer is chock-full of fun events!	01KGAFJJ6BYNT72EPD5K3QY1KT	4.0	2022-03-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 4	My Idol Sits the Next Desk Over! Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2022-04-05T07:00:00.000Z
PRD_2YAVPQQPBFRG	CNT_0E2CHW4BA3VG	My Idol Sits the Next Desk Over! CNT_0S4AVWH5QR7G	CNT_0S4AVWH5QR7G	2	1	1	Volume 2	[]	My Idol Sits the Next Desk Over! 2	Sakiko ended up in the same class and in the seat right next to her beloved idol, Chihiro-chan. Chihiro-chan became her friend and that's how they spent the days together. Sakiko was still a bundle of butterflies, but little by little, she began to feel more comfortable around her. Then came Spring Sunshine's surprise concert. Chiro-chan the idol was different than the Chihiro-chan she saw in the classroom, and her powerful performance brought tears to Sakiko's eyes. She's supposed to be her friend, but she reveres her too much to treat her as just that! From the class sports tournament to an after-school picnic, the calendar is full of school events!	01KGAEJY2P8Z2R7906CEJ5BPAS	2.0	2022-01-21T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Idol Sits the Next Desk Over! 2	My Idol Sits the Next Desk Over! Tetsu Tsutsui, Koyubi Sugawara/Kodansha Ltd.	2022-02-01T08: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);