database: products: 16 rows where series_id = "CNT

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

16 rows where series_id = "CNT_3GQCYSVVZEBG"

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_02V83V48J3SG	CNT_05DWZ6D41DJG	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 9	[]	Twin Spica Vol. 9	In the ninth volume of Twin Spica, Asumi and her classmates are getting closer and closer towards graduation, and changes in store for this group of friends. There will be good-byes to be said and that might end up causing some tension within this group. Some of that friction might be spurred on from outside of the Tokyo Space School as the media has caught on to the identities of at least one prime candidate.	01KH3H6YTZ1SCJ0N7RNXE717FA	9.0	2013-10-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 9	Kou Yaginuma/Media Factory	2013-10-29T07:00:00.000Z
PRD_0GNRHGM38NV0	CNT_1ZMSN8SXWFG0	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 2	[]	Twin Spica Vol. 2	Where were you when the first International Space Station was scrapped and dropped into Earth's atmosphere? It was Asumi's first day in space school, and she promised Lion she would not cry or be homesick as she will be leaving her quiet seaside town for the big city. Waiting for her in Tokyo will be a lot of work. She is going to have to go through the rigors of space exploration training at the Tokyo Space School. After hours, Asumi will focus her efforts on homework, when not earning her tuition at the neighborhood Denny's. It is not uncommon to run 20 laps around the campus each day. Follow that up with physics and advance mathematics courses in the classroom. Only to close the night by mapping out the constellations in the southern sky. This is just what she expected the TSS to be, and yet why is it so hard to envision going to space someday? With all of the work she and her classmates are accomplishing, why does space still feel so far away?	01KH3H608GFYF390E4FRW57N9D	2.0	2013-05-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 2	Kou Yaginuma/Media Factory	2013-05-14T07:00:00.000Z
PRD_10AP5TJ5T97G	CNT_0TNYVD7R344G	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 7	[]	Twin Spica Vol. 7	Asumi and her friends have been granted some well deserved time off. And as the gang begins to realize how close they have become over the past year, they decide together to head off to the home of two prime members of this now tight star-gazing circle- Yuigahama. Back in the home town of Asumi and Fuchuuya the gang slowly get to learn more about the Lion Disaster and the sad tale of the Kamokawa's. The girls gets to experience the star-filled room Asumi grew up in; where she got to intimately live among the constellations. They spend time with the Fuchuuya family fireworks store as they prepare to close out the summer with a bang. And somehow along the way these friends find a way to melt the ice that had formed around ice-queen Marika's heart, revealing a secret that no one in the galaxy was prepared for.	01KH3H6FRMZ7H6GZ3HNM5678J5	7.0	2013-09-24T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 7	Kou Yaginuma/Media Factory	2013-09-24T07:00:00.000Z
PRD_14V6QDC8686G	CNT_2T0BTRW0E35G	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 6	[]	Twin Spica Vol. 6	Asumi's latest and most challenging flight simulation trial continues. She along with her classmates have been put into small escape pods, the actual pods that the International Space Station currently uses, to simulate traveling through space and an atmosphere re-entry. The pods are then covered and transported into the Japanese wilderness where after some rough handling and a designated allotment of time the pods automatically open up leaving the students disorientated and desperate to find civilization.	01KH3H6D942P0W4E596SZ9N243	6.0	2013-08-27T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 6	Kou Yaginuma/Media Factory	2013-08-27T07:00:00.000Z
PRD_1B9H209J2Q5G	CNT_0XARTAJ8X26G	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 5	[]	Twin Spica Vol. 5	Time is flying by at the Tokyo Space School and Asumi is now heading into her second of three years at the elite aeronautics academy. However, while this new transition should bring with it excitement and new challenges, Asumi has her heart and mind somewhere else. She cannot forget her old classmate. The accident took many lives and hurt countless of others. Many people have moved away, move on or have tried to forget the tragedy. But for some young people there is no chance to forget or forgive.	01KH3H64HZ67H4YFWDB954XBDE	5.0	2013-06-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 5	Kou Yaginuma/Media Factory	2013-06-25T07:00:00.000Z
PRD_1FY0DKBMEP4G	CNT_2WMP5M8H817G	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 3	[]	Twin Spica Vol. 3	Asumi is going through her growing pains right now. She knew this new challenge would not be simple. Mentally and, even with her petite frame, physcially she was prepared for almost anything the Japanese Aerospace Exploration Agency (JAXA) could throw at her. Emotionally, however, she was light-years away from being able to even take more than a few attacks on her long suppressed past. So when Asumi is at her lowest, a longtime friend, of the invisible sort, pays a visit. As he is grappling with his own past, she realizes that there is no way she cannot move forward. Nothing here can keep her from taking off!	01KH3H630RP0CCDX9EQ0Y6ZE16	3.0	2013-05-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 3	Kou Yaginuma/Media Factory	2013-05-29T07:00:00.000Z
PRD_1KJ50VSBEEWG	CNT_261XSATE08ZG	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 16	[]	Twin Spica Vol. 16	In this final installment, graduation looms for what is left of the Tokyo Space School's first class. Finally, Japan's first student astronaut is selected! Will Asumi finally be able to drive the rocket of her childhood dreams?	01KH3H6R761BF2RP2BZ475G3ZT	16.0	2014-05-27T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 16	Kou Yaginuma/Media Factory	2014-05-27T07:00:00.000Z
PRD_1P0NJEVDAD3G	CNT_0SCARMGPF7RG	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 14	[]	Twin Spica Vol. 14	Tragedy strikes the TSS. It was not long since the first class of the astronaut course got to experience great pride when one of their best was selected to join NASA. With those feelings still fresh the academy is then shaken to its core and one member may not be able to return to her duties now that her guiding light has faded.	01KH3H6Q1Y6MMC0X7QCS09NM6Y	14.0	2014-03-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 14	Kou Yaginuma/Media Factory	2014-03-25T07:00:00.000Z
PRD_1S7Q8MPSJB1G	CNT_0R0MVHV795TG	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 12	[]	Twin Spica Vol. 12	Asumi and her classmates are getting closer and closer towards graduation, and changes in store for this group of friends. There will be good-byes to be said and that might end up causing some tension within this group. Some of that friction might be spurred on from outside of the Tokyo Space School as the media has caught on to the identities of at least one prime candidate.	01KH3H6KVJWY74G37EETDGTCEY	12.0	2014-02-18T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 12	Kou Yaginuma/Media Factory	2014-02-18T08:00:00.000Z
PRD_1TH4X1MQPC2G	CNT_2RP7R66YT6SG	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 10	[]	Twin Spica Vol. 10	In the tenth volume of Kou Yaginuma's Twin Spica an astronaut will be selected and the choice may not be so obvious. And while this future space traveler has shown plenty of potential and talent it is clear they couldn't have made it without some help. Though the mystery is whose help, and will this person last without that support.	01KH3H6N05FMP536CY0REK6MDR	10.0	2013-11-26T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 10	Kou Yaginuma/Media Factory	2013-11-26T08:00:00.000Z
PRD_1XM7T7G3YA0G	CNT_2VB1V3HFM4VG	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 8	[]	Twin Spica Vol. 8	The astronaut selection test is around the corner and one member of the TSS's first class is quietly preparing for this challenge. This student has plenty to prove, but to do so without the aide of family or friends might be even more difficult. The exam will send one of these friends to America. Will it be worth the heartache?	01KH3H6JQBXP62TGB3T61YY3XZ	8.0	2013-10-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 8	Kou Yaginuma/Media Factory	2013-10-22T07:00:00.000Z
PRD_2JCGZ65YANBG	CNT_0ZZ357YSQ00G	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 1	[]	Twin Spica Vol. 1	In a Tokyo in the not too distant future a young girl studies diligently with ambitions of soon attending space academy. If things work out just right, her future may very well be among the stars as well. And yet, every time she looks up to the stars there is a sense of melancholy in her heart. A sadness surrounds Asumi, as space exploration itself has profoundly impacted her life for as long as she can remember. But she is not alone...A young man wearing a lion's mask is always beside her. He speaks of the constellations and galaxies as if he they were like home. He knows what it is like to love the stars--slightly bitter and yet always so warm and inviting. Truth is he has gone through much of Asumi is just experiencing. And now in spirit he will forever be with Asumi guiding her on her path to space.	01KH3GASJW8VDNZH5YHVXFV8DS	1.0	2013-05-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 1	Kou Yaginuma/Media Factory	2013-05-14T07:00:00.000Z
PRD_39PSVARQ0QN0	CNT_1WZZNKDD3HP0	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 4	[]	Twin Spica Vol. 4	Asumi is now in her second term at the Tokyo Space School. After struggling to be accepted into this elite program and some hardships once she was admitted, she quickly found herself developing her skills and her character through the many trials the school administered. Despite her diminutive size, Asumi has a huge heart and equally powerful drive and she will not accept failure as an option. So when she is confronted by protesters demonstrating against Japan's space program, she is torn by the memories of her past, which include her deceased mother, and the dreams she is working so hard to attain.	01KH3H63R7CRJ2BVK0PZNKSQXB	4.0	2013-06-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 4	Kou Yaginuma/Media Factory	2013-06-25T07:00:00.000Z
PRD_3M9W4Q5J8DK0	CNT_1S118XBTNQ80	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 15	[]	Twin Spica Vol. 15	In this penultimate installment, graduation looms for what is left of the Tokyo Space School's first class. As the teens focus on their final days in school, many of them take the opportunity to finally share some long hidden feelings and settle a few differences.	01KH3H6PD5TE7JAXRW7NDV0KX6	15.0	2014-04-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 15	Kou Yaginuma/Media Factory	2014-04-22T07:00:00.000Z
PRD_3RYCPA7MMCJ0	CNT_3RBY8F030P90	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 11	[]	Twin Spica Vol. 11	With only months left in their training, Asumi and those left in the Tokyo Space School's first astronaut training class have a new and potentially defining task at hand. From the moment they enrolled, these teens were under the assumption that the future of space exploration would be at the hands of their generation. At least one of them would lead JAXA into the cosmos to revitalize a once dead program. But in the nearly three years they have spent training their bodies and minds, science appears to have caught up to them.	01KH3H6MG1K00X3A2VE0BDZQFB	11.0	2013-12-24T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 11	Kou Yaginuma/Media Factory	2013-12-24T08:00:00.000Z
PRD_3ZCZ1X1YGBH0	CNT_1VPBBTPBFNA0	Twin Spica CNT_3GQCYSVVZEBG	CNT_3GQCYSVVZEBG	2	1	1	Volume 13	[]	Twin Spica Vol. 13	An astronaut will be selected and the choice may not be so obvious. And while this future space traveler has shown plenty of potential and talent it is clear they couldn't have made it without some help. Though the mystery is whose help, and will this person last without that support.	01KH3H6KAVR0PF0ZSWQ2H67HKQ	13.0	2014-03-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Twin Spica Vol. 13	Kou Yaginuma/Media Factory	2014-03-25T07: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);