Ausgewählte Änderung
Über das Spiel · 29.10.2026, 07:15
Vorher<p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f44a4a8ee532320b1f91309e4c6bca6d.avif?t=1792924076" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f44a4a8ee532320b1f91309e4c6bca6d.webp?t=1792924076 width=1560 height=571 /></span><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/4780ff075b177d10fa77004c255c58b0.avif?t=1792924076" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/4780ff075b177d10fa77004c255c58b0.webp?t=1792924076 width=1560 height=401 /></span>Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.</p><p class="bb_paragraph" ></p><p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f7e7213d563cfd5058514fae224a77a3.avif?t=1792924076" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f7e7213d563cfd5058514fae224a77a3.webp?t=1792924076 width=1560 height=457 /></span>Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.</p><p class="bb_paragraph" ></p><p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/e483eeae3c28ddec622c6c49b6c8d118.avif?t=1792924076" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/e483eeae3c28ddec622c6c49b6c8d118.webp?t=1792924076 width=1560 height=368 /></span>Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.</p><p class="bb_paragraph" ></p><p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/75df26b2bf49db3684491b2d31b142e7.avif?t=1792924076" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/75df26b2bf49db3684491b2d31b142e7.webp?t=1792924076 width=1560 height=373 /></span>Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!</p><p class="bb_paragraph" ></p>
Aktuell<p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f44a4a8ee532320b1f91309e4c6bca6d.avif?t=1793213447" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f44a4a8ee532320b1f91309e4c6bca6d.webp?t=1793213447 width=1560 height=571 /></span><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/4780ff075b177d10fa77004c255c58b0.avif?t=1793213447" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/4780ff075b177d10fa77004c255c58b0.webp?t=1793213447 width=1560 height=401 /></span>Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.</p><p class="bb_paragraph" ></p><p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f7e7213d563cfd5058514fae224a77a3.avif?t=1793213447" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f7e7213d563cfd5058514fae224a77a3.webp?t=1793213447 width=1560 height=457 /></span>Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.</p><p class="bb_paragraph" ></p><p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/e483eeae3c28ddec622c6c49b6c8d118.avif?t=1793213447" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/e483eeae3c28ddec622c6c49b6c8d118.webp?t=1793213447 width=1560 height=368 /></span>Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.</p><p class="bb_paragraph" ></p><p class="bb_paragraph" style="text-align: center"><span class="bb_img_ctn"><img class="bb_img" src="https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/75df26b2bf49db3684491b2d31b142e7.avif?t=1793213447" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/75df26b2bf49db3684491b2d31b142e7.webp?t=1793213447 width=1560 height=373 /></span>Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!</p><p class="bb_paragraph" ></p>
Raw AppDetails anzeigen
{
"5072430": {
"success": true,
"data": {
"type": "game",
"name": "Ghost in the SQL Data",
"steam_appid": 5072430,
"required_age": 0,
"is_free": false,
"controller_support": "full",
"detailed_description": "<p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f44a4a8ee532320b1f91309e4c6bca6d.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f44a4a8ee532320b1f91309e4c6bca6d.webp?t=1793213447 width=1560 height=571 /></span><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/4780ff075b177d10fa77004c255c58b0.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/4780ff075b177d10fa77004c255c58b0.webp?t=1793213447 width=1560 height=401 /></span>Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.</p><p class=\"bb_paragraph\" ></p><p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f7e7213d563cfd5058514fae224a77a3.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f7e7213d563cfd5058514fae224a77a3.webp?t=1793213447 width=1560 height=457 /></span>Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.</p><p class=\"bb_paragraph\" ></p><p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/e483eeae3c28ddec622c6c49b6c8d118.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/e483eeae3c28ddec622c6c49b6c8d118.webp?t=1793213447 width=1560 height=368 /></span>Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.</p><p class=\"bb_paragraph\" ></p><p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/75df26b2bf49db3684491b2d31b142e7.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/75df26b2bf49db3684491b2d31b142e7.webp?t=1793213447 width=1560 height=373 /></span>Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!</p><p class=\"bb_paragraph\" ></p>",
"about_the_game": "<p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f44a4a8ee532320b1f91309e4c6bca6d.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f44a4a8ee532320b1f91309e4c6bca6d.webp?t=1793213447 width=1560 height=571 /></span><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/4780ff075b177d10fa77004c255c58b0.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/4780ff075b177d10fa77004c255c58b0.webp?t=1793213447 width=1560 height=401 /></span>Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.</p><p class=\"bb_paragraph\" ></p><p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/f7e7213d563cfd5058514fae224a77a3.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/f7e7213d563cfd5058514fae224a77a3.webp?t=1793213447 width=1560 height=457 /></span>Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.</p><p class=\"bb_paragraph\" ></p><p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/e483eeae3c28ddec622c6c49b6c8d118.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/e483eeae3c28ddec622c6c49b6c8d118.webp?t=1793213447 width=1560 height=368 /></span>Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.</p><p class=\"bb_paragraph\" ></p><p class=\"bb_paragraph\" style=\"text-align: center\"><span class=\"bb_img_ctn\"><img class=\"bb_img\" src=\"https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras/75df26b2bf49db3684491b2d31b142e7.avif?t=1793213447\" data-big-src=https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/extras_big/75df26b2bf49db3684491b2d31b142e7.webp?t=1793213447 width=1560 height=373 /></span>Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!</p><p class=\"bb_paragraph\" ></p>",
"short_description": "A call reported a school fire 14 minutes before the first witness saw it. Find out who made it, in SQL, by exploring a year of Paris emergency calls.",
"supported_languages": "English<strong>*</strong>, French<strong>*</strong>, Italian<strong>*</strong>, German<strong>*</strong>, Spanish - Spain<strong>*</strong>, Japanese<strong>*</strong>, Korean<strong>*</strong>, Russian<strong>*</strong>, Simplified Chinese<strong>*</strong>, Portuguese - Brazil<strong>*</strong><br><strong>*</strong>languages with full audio support",
"reviews": "“An unusual mystery game that developers will get hooked on.”<br>ITmedia @IT<br><br>“A mystery game where you uncover the truth of a case with SQL. It looks fun.”<br>Denfaminicogamer<br>",
"header_image": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/51f9c7715c2f874443595ae9e76269b02444c496/header.jpg?t=1793213447",
"capsule_image": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/68f0d273de2d8da9c13f6cf314089ec320eb377d/capsule_231x87.jpg?t=1793213447",
"capsule_imagev5": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/68f0d273de2d8da9c13f6cf314089ec320eb377d/capsule_184x69.jpg?t=1793213447",
"website": "https://isaacmenard.github.io/presskit/",
"pc_requirements": {
"minimum": "<strong>Minimum:</strong><br><ul class=\"bb_ul\"><li><strong>OS:</strong> Windows 10 (64-bit)<br></li><li><strong>Processor:</strong> Dual Core 2,0 GHz (Intel Core i3)<br></li><li><strong>Memory:</strong> 4 GB RAM<br></li><li><strong>Graphics:</strong> Intel HD Graphics 4000 (support WebGL / DirectX 11)<br></li><li><strong>Storage:</strong> 1 GB available space</li></ul>",
"recommended": "<strong>Recommended:</strong><br><ul class=\"bb_ul\"><li><strong>OS:</strong> Windows 10/11 (64-bit)<br></li><li><strong>Processor:</strong> Quad Core 2,5 GHz or more<br></li><li><strong>Memory:</strong> 8 GB RAM<br></li><li><strong>Graphics:</strong> GPU (Intel Iris Xe / AMD Vega 8)<br></li><li><strong>Storage:</strong> 1 GB available space</li></ul>"
},
"mac_requirements": {
"minimum": "<strong>Minimum:</strong><br><ul class=\"bb_ul\"><li><strong>OS:</strong> macOS 11<br></li><li><strong>Processor:</strong> Apple M1 or Intel Core i5<br></li><li><strong>Memory:</strong> 4 GB RAM</li></ul>",
"recommended": "<strong>Recommended:</strong><br><ul class=\"bb_ul\"><li><strong>OS:</strong> macOS 11+<br></li><li><strong>Processor:</strong> Apple M1 or Intel Core i5<br></li><li><strong>Memory:</strong> 8 GB RAM</li></ul>"
},
"linux_requirements": [],
"developers": [
"Isaac MENARD"
],
"publishers": [
"Isaac MENARD"
],
"package_groups": [],
"platforms": {
"windows": true,
"mac": true,
"linux": false
},
"categories": [
{
"id": 2,
"description": "Single-player"
},
{
"id": 22,
"description": "Steam Achievements"
},
{
"id": 28,
"description": "Full controller support"
},
{
"id": 30,
"description": "Steam Workshop"
},
{
"id": 64,
"description": "Adjustable Text Size"
},
{
"id": 67,
"description": "Camera Comfort"
},
{
"id": 66,
"description": "Color Alternatives"
},
{
"id": 68,
"description": "Custom Volume Controls"
},
{
"id": 80,
"description": "#category_playable_at_your_own_pace"
},
{
"id": 74,
"description": "Playable without Timed Input"
},
{
"id": 55,
"description": "DualShock Controller Support"
},
{
"id": 56,
"description": "DualShock Controller Support"
},
{
"id": 57,
"description": "DualSense Controller Support"
},
{
"id": 58,
"description": "DualSense Controller Support"
},
{
"id": 79,
"description": "Save Anytime"
},
{
"id": 65,
"description": "Subtitle Options"
},
{
"id": 23,
"description": "Steam Cloud"
},
{
"id": 15,
"description": "Stats"
},
{
"id": 17,
"description": "Includes level editor"
},
{
"id": 62,
"description": "Family Sharing"
}
],
"genres": [
{
"id": "28",
"description": "Simulation"
},
{
"id": "2",
"description": "Strategy"
}
],
"screenshots": [
{
"id": 0,
"path_thumbnail": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/9ccaf070edcc4054ccb4aaa163143d8ac9d499c8/ss_9ccaf070edcc4054ccb4aaa163143d8ac9d499c8.600x338.jpg?t=1793213447",
"path_full": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/9ccaf070edcc4054ccb4aaa163143d8ac9d499c8/ss_9ccaf070edcc4054ccb4aaa163143d8ac9d499c8.1920x1080.jpg?t=1793213447"
},
{
"id": 1,
"path_thumbnail": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/c0ce8635c38743a42ee91d4ea7bcd41e1bd2d3da/ss_c0ce8635c38743a42ee91d4ea7bcd41e1bd2d3da.600x338.jpg?t=1793213447",
"path_full": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/c0ce8635c38743a42ee91d4ea7bcd41e1bd2d3da/ss_c0ce8635c38743a42ee91d4ea7bcd41e1bd2d3da.1920x1080.jpg?t=1793213447"
},
{
"id": 2,
"path_thumbnail": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/afebdfb04219922b5b8c4d2afaa1b1852c82652e/ss_afebdfb04219922b5b8c4d2afaa1b1852c82652e.600x338.jpg?t=1793213447",
"path_full": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/afebdfb04219922b5b8c4d2afaa1b1852c82652e/ss_afebdfb04219922b5b8c4d2afaa1b1852c82652e.1920x1080.jpg?t=1793213447"
},
{
"id": 3,
"path_thumbnail": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/4d7b837d03a2d4caabf9010ad05ec55e92be7965/ss_4d7b837d03a2d4caabf9010ad05ec55e92be7965.600x338.jpg?t=1793213447",
"path_full": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/4d7b837d03a2d4caabf9010ad05ec55e92be7965/ss_4d7b837d03a2d4caabf9010ad05ec55e92be7965.1920x1080.jpg?t=1793213447"
},
{
"id": 4,
"path_thumbnail": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/79302acaf55953ee915f9d65b1ec1f707c7793e1/ss_79302acaf55953ee915f9d65b1ec1f707c7793e1.600x338.jpg?t=1793213447",
"path_full": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/79302acaf55953ee915f9d65b1ec1f707c7793e1/ss_79302acaf55953ee915f9d65b1ec1f707c7793e1.1920x1080.jpg?t=1793213447"
}
],
"movies": [
{
"id": 257405852,
"name": "main trailer",
"thumbnail": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/257405852/6e3b8344799a87f3415fa424f073beddea2527ef/movie_600x337.jpg?t=1793206259",
"dash_av1": "https://video.akamai.steamstatic.com/store_trailers/5072430/918368473/3f8f6df6392488dc7d60a6a8b509ebfd7cc52763/1793205979/dash_av1.mpd?t=1793206259",
"dash_h264": "https://video.akamai.steamstatic.com/store_trailers/5072430/918368473/3f8f6df6392488dc7d60a6a8b509ebfd7cc52763/1793205979/dash_h264.mpd?t=1793206259",
"hls_h264": "https://video.akamai.steamstatic.com/store_trailers/5072430/918368473/3f8f6df6392488dc7d60a6a8b509ebfd7cc52763/1793205979/hls_264_master.m3u8?t=1793206259",
"highlight": true
}
],
"release_date": {
"coming_soon": true,
"date": "29 Oct, 2026"
},
"support_info": {
"url": "",
"email": "menardisaac@gmail.com"
},
"background": "https://store.akamai.steamstatic.com/images/storepagebackground/app/5072430?t=1793213447",
"background_raw": "https://shared.akamai.steamstatic.com/store_item_assets/steam/apps/5072430/e8b9f4c76a2ccf89948c3ca09c227cf2884083a5/page_bg_raw.jpg?t=1793213447",
"content_descriptors": {
"ids": [],
"notes": null
},
"ratings": {
"dejus": {
"rating_generated": "1",
"rating": "l",
"required_age": "0",
"banned": "0",
"use_age_gate": "0",
"descriptors": ""
},
"steam_germany": {
"rating_generated": "1",
"rating": "0",
"required_age": "0",
"banned": "0",
"use_age_gate": "0",
"descriptors": ""
},
"igrs": {
"rating_generated": "1",
"rating": "3",
"required_age": "0",
"banned": "0",
"use_age_gate": "0",
"descriptors": ""
}
}
}
}
}