Anonymous edits have been disabled on the wiki. If you want to contribute please login or create an account.

Warning for game developers: PCGamingWiki staff members will only ever reach out to you using the official press@pcgamingwiki.com mail address.
Be aware of scammers claiming to be representatives or affiliates of PCGamingWiki who promise a PCGW page for a game key.

Difference between revisions of "User:Aemony/Sandbox"

From PCGamingWiki, the wiki about fixing PC games
m (d)
m (added columns)
 
(144 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
Updated table with tooltips for all rows, see [[PCGamingWiki:Editing_guide/Input_settings]] for comparison.{{#vardefine:steam appid|yes}}
+
'''Cargo data with some reference inserted?'''
  
−
{{User:Aemony/Sandbox/Input settings
+
{{#cargo_query:
−
|key remap                = true
+
tables=Middleware
−
|key remap notes          =  
+
|where=
−
|acceleration option      = false
+
Physics HOLDS LIKE '%UNIQ%' OR
−
|acceleration option notes =
+
Audio HOLDS LIKE '%UNIQ%' OR
−
|mouse sensitivity        = true
+
Interface HOLDS LIKE '%UNIQ%' OR
−
|mouse sensitivity notes  =
+
Input HOLDS LIKE '%UNIQ%' OR
−
|mouse menu                = true
+
Cutscenes HOLDS LIKE '%UNIQ%' OR
−
|mouse menu notes          =
+
Multiplayer HOLDS LIKE '%UNIQ%' OR
−
|invert mouse y-axis      = true
+
Anticheat HOLDS LIKE '%UNIQ%'
−
|invert mouse y-axis notes =
+
|fields=_pageName,Physics,Audio,Interface,Input,Cutscenes,Multiplayer,Anticheat
−
|touchscreen              = hackable
+
|format=table
−
|touchscreen notes        = Requires fan patch
+
|default=
−
|controller support        = true
 
−
|controller support notes  =
 
−
|full controller          = true
 
−
|full controller notes    =
 
−
|controller remap          = false
 
−
|controller remap notes    = Can only switch between pre-defined layouts.
 
−
|controller sensitivity    = true
 
−
|controller sensitivity notes=
 
−
|invert controller y-axis  = true
 
−
|invert controller y-axis notes=
 
−
|xinput controllers        = true
 
−
|xinput controllers notes  =
 
−
|xbox prompts              = true
 
−
|xbox prompts notes        =
 
−
|impulse triggers          = false
 
−
|impulse triggers notes    =
 
−
|dualshock 4              = true
 
−
|dualshock 4 notes        =
 
−
|dualshock prompts        = hackable
 
−
|dualshock prompts notes  = Use PlayStation Button Mod for DualShock buttons.
 
−
|light bar support        = hackable
 
−
|light bar support notes  = Requires replacement DLL
 
−
|dualshock 4 modes        = unknown
 
−
|dualshock 4 modes notes  =
 
−
|tracked motion controllers= unknown
 
−
|tracked motion controllers notes =
 
−
|tracked motion prompts    = unknown
 
−
|tracked motion prompts notes =
 
−
|other controllers        = true
 
−
|other controllers notes  =
 
−
|other button prompts      = generic
 
−
|other button prompts notes=
 
−
|controller hotplug        = false
 
−
|controller hotplug notes  = Controller is only detected at startup.
 
−
|haptic feedback          = true
 
−
|haptic feedback notes    = Enabled by default
 
−
|simultaneous input        = true
 
−
|simultaneous input notes  =
 
−
|steam input api          = false
 
−
|steam input api notes    =
 
−
|steam hook input          = true
 
−
|steam hook input notes    =
 
−
|steam input presets      = unknown
 
−
|steam input presets notes =
 
−
|steam controller prompts  = unknown
 
−
|steam controller prompts notes =
 
−
|steam cursor detection    = unknown
 
−
|steam cursor detection notes =  
 
 
}}
 
}}
  
 +
'''Cargo data with some newlines inserted?'''
 +
 +
{{#cargo_query:
 +
tables=Middleware
 +
|where=
 +
Physics HOLDS LIKE '%<br%' OR
 +
Audio HOLDS LIKE '%<br%' OR
 +
Interface HOLDS LIKE '%<br%' OR
 +
Input HOLDS LIKE '%<br%' OR
 +
Cutscenes HOLDS LIKE '%<br%' OR
 +
Multiplayer HOLDS LIKE '%<br%' OR
 +
Anticheat HOLDS LIKE '%<br%'
 +
|fields=_pageName,Physics,Audio,Interface,Input,Cutscenes,Multiplayer,Anticheat
 +
|format=table
 +
|default=
 +
}}
 +
 +
 +
 +
'''Example query'''
 +
 +
{{#cargo_query:
 +
tables=Infobox_game
 +
|where=Infobox_game._pageName="Make It Rain: The Love of Money"
 +
|fields=_pageName,Developers,Publishers,Engines,Released,
 +
|format=table
 +
|default=
 +
}}
 +
 +
<!--
 +
API.Windows_ARM_app='true'
 +
Infobox_game._pageName="NieR: Automata"
 +
Infobox_game._pageName="Make It Rain: The Love of Money"
 +
Infobox_game._pageName="9 Clues: The Secret of Serpent Creek"
 +
-->
 +
 +
'''Broken backend data:''' (nothing beyond infobox game seems to be populated)
 +
{{#cargo_query:
 +
tables=Infobox_game,API,L10n,Cloud,Availability
 +
|join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName
 +
|where=Infobox_game._pageName="Make It Rain: The Love of Money" OR Infobox_game._pageName="NieR: Automata" OR Infobox_game._pageName="User:Aemony/Sandbox/Bot2" OR Cloud._pageName="NieR: Automata2" OR Infobox_game._pageName="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld"
 +
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released,Infobox_game.Released_Windows,API.Windows_ARM_app,L10n.Language,Cloud.Steam=Cloud.Steam,Availability.Available_from
 +
|format=table
 +
}}
 +
 +
'''Test using <code>User:Aemony/Sandbox/Bot2</code> and {{T|Save game cloud syncing}}:'''
 +
{{#cargo_query:
 +
tables=Infobox_game
 +
|where=Infobox_game._pageName="User:Aemony/Sandbox/Bot2" OR Infobox_game._pageName="NieR: Automata" OR Infobox_game._pageName="NieR: Automata2" OR Infobox_game._pageName="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld"
 +
|fields=Infobox_game._pageName,Infobox_game.Released,Infobox_game.Released_Windows,Infobox_game.Series
 +
|format=table
 +
}}
 +
 +
{{#cargo_query:
 +
tables=Cloud
 +
|where=Cloud._pageName="User:Aemony/Sandbox/Bot2" OR Cloud._pageName="NieR: Automata" OR Cloud._pageName="NieR: Automata2" OR Cloud._pageName="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld"
 +
|fields=Cloud._pageName,Cloud.Steam=Cloud.Steam
 +
|format=table
 +
}}
 +
 +
 +
'''Proper backend data:'''
 +
{{#cargo_query:
 +
tables=Infobox_game,API,L10n,Cloud,Availability
 +
|join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName
 +
|where=Infobox_game._pageName="9 Clues: The Secret of Serpent Creek"
 +
|fields=Infobox_game._pageName,Infobox_game.Series,Infobox_game.Developers,Infobox_game.Publishers,Infobox_game.Engines,Infobox_game.Released,Infobox_game.Released_Windows,API.Windows_ARM_app,L10n.Language,Cloud.Steam=Cloud.Steam,Availability.Available_from
 +
|format=table
 +
}}
 +
 +
 +
 +
------
 +
 +
 +
 +
 +
 +
 +
 +
<!--
  
  
−
<pre><nowiki><abbr title="An option is available to reassign or remap keyboard keys to other commands/abilities.">Remapping</abbr>
 
−
<abbr title="An option is available to toggle the acceleration of in-game mouse movement (i.e. the cursor and/or camera moves further if the computer mouse is physically moved faster than if it is moved slower). Also loosely called mouse smoothing.">Mouse acceleration</abbr>
 
−
<abbr title="An option is available to adjust the speed of in-game mouse movement.">Mouse sensitivity</abbr>
 
−
<abbr title="The game support mouse input (either movement, scroll wheel, or full cursor) in the in-game menus.">Mouse input in menus</abbr>
 
−
<abbr title="An option is available to invert vertical (or Y-axis) mouse movement (i.e. moving the mouse up will make the in-game camera go down).">Mouse Y-axis inversion</abbr>
 
  
−
<abbr title="The game support touchscreen monitors.">Touchscreen optimized</abbr>
+
'''Basic example -- does not work with multiple defined dates: '''
  
−
<abbr title="The game support traditional game controllers, gamepads, and/or joysticks.">Controller support</abbr>
+
{{#cargo_query:
−
<abbr title="An extension of the previous field, the game support navigating all in-game menus with a controller without requiring extra keyboard or mouse input.">Full controller support</abbr>
+
tables=Infobox_game
−
<abbr title="An option is available to reassign or remap controller buttons to other commands/abilities.">Controller remapping</abbr>
+
|fields=Infobox_game._pageName,Infobox_game.Released_Windows=DateUnformatted,DATE_FORMAT(Infobox_game.Released_Windows,"%M %e, %Y")=DateFormatted
−
<abbr title="An option is available to adjust the speed of in-game joy/analog stick movement.">Controller sensitivity</abbr>
+
|limit=20
−
<abbr title="An option is available to invert vertical (or Y-axis) controller movement (i.e. moving the right analog stick up will make the in-game camera go down).">Controller Y-axis inversion</abbr>
+
}}
  
−
<abbr title="The game support XInput controllers, such as the Xbox 360 Controller, Xbox One Controller, or compatible models.">XInput-compatible controllers</abbr>
+
---
−
<abbr title="The game has Xbox-stylized button prompts available in-game.">Xbox button prompts</abbr>
 
−
<abbr title="The game makes use of the Impulse Trigger on the Xbox One Controller (aka haptic feedback in the left and right triggerrs).">Impulse Trigger vibration</abbr>
 
  
−
<abbr title="The game support Sony's official DualShock 4 controller models.">DualShock 4 controllers</abbr>
+
'''NumOfRows: '''{{#cargo_query:
−
<abbr title="The game has DualShock-stylized button prompts available in-game.">DualShock button prompts</abbr>
+
tables=Infobox_game,Infobox_game__Released
−
<abbr title="The game makes use of the light bar component of the DualShock 4 controller.">DualShock 4 light bar support</abbr>
+
|join on=Infobox_game._ID=Infobox_game__Released._rowID
−
<abbr title="The game support the following connection modes (comma-separated) for the DualShock 4 controller.">DualShock 4 connection modes</abbr>
+
|fields=COUNT(Infobox_game__Released._value)
 +
|where=Infobox_game._pageName="Half-Life"
 +
}}
  
−
<abbr title="The game support motion controllers.">Tracked motion controllers</abbr>
+
{{#cargo_query:
−
<abbr title="The game has motion controller-stylished button/gesture prompts available in-game.">Motion controller button/gesture prompts</abbr>
+
tables=Infobox_game,Infobox_game__Released
 +
|join on=Infobox_game._ID=Infobox_game__Released._rowID
 +
|fields=Infobox_game._pageName,DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")=DateFormatted
 +
|where=Infobox_game._pageName="Half-Life"
 +
}}
  
−
<abbr title="The game support other types of traditional controllers.">Generic/other controllers</abbr>
+
'''Delimited: '''{{#cargo_query:
−
<abbr title="The game has button prompts stylished for specific controller types (comma-separated) available in-game.">Other button prompts</abbr>
+
tables=Infobox_game,Infobox_game__Released
 +
|join on=Infobox_game._ID=Infobox_game__Released._rowID
 +
|fields=DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")
 +
|where=Infobox_game._pageName="Half-Life"
 +
|format=list
 +
|delimiter=&nbsp;and
 +
}}
  
−
<abbr title="The game support connecting a controller in-game and will detect it automatically on the fly without a game restart needed.">Controller hotplugging</abbr>
+
---
−
<abbr title="An option is available to toggle the use of haptic feedback (aka controller vibration, force feedback, rumble, or dualshock) with compatible controllers.">Haptic feedback</abbr>
 
−
<abbr title="The game support making use of controller inputs alongside keyboard/mouse input (e.g. can walk around with the analog stick on a controller while using the mouse to look around).">Simultaneous input</abbr>
 
  
−
<abbr title="The game support the Steam Input API natively, and can make full use of the related features (rebind actions, not keys/buttons, through Steam Input, etc).">Steam Input API support</abbr>
+
'''Full: '''
−
<abbr title="An extension of the previous field (if set to false), the game support Steam Input in legacy mode and can hook the input of the game and allow the use of legacy related features (rebind keys/buttons through Steam Input).">Hook input (legacy mode)</abbr>
 
−
<abbr title="The developer of the game supplies official controller configurations for various types of controllers through Steam Input.">Official controller preset(s)</abbr>
 
−
<abbr title="The game has Steam Controller-stylished button prompts available in-game.">Steam Controller button prompts</abbr>
 
−
<abbr title="Indicates whatever Steam properly detects when mouse cursor is visible in game, allowing for automatic switching between controller layouts.">Cursor detection</abbr>
 
−
</nowiki></pre>
 
  
 +
{{#cargo_query:
 +
tables=Infobox_game
 +
|fields=Infobox_game._pageName,Infobox_game.Released,Infobox_game.Released__full,CONCAT(Infobox_game.Released__full)=CONCAT__full,SUBSTRING(CONCAT(Infobox_game.Released__full),0,10)=SUBSTRING
 +
|where=Infobox_game._pageName="Doom (1993)"
 +
}}
  
 +
---
  
−
------------
+
'''Group By: '''
  
 +
{{#cargo_query:
 +
tables=Infobox_game,Infobox_game__Released
 +
|join on=Infobox_game._ID=Infobox_game__Released._rowID
 +
|fields=Infobox_game._pageName,DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")=DateFormatted
 +
|where=Infobox_game._pageName="Half-Life"
 +
|group by=Infobox_game._pageName,Infobox_game__Released._value
 +
}}
 +
 +
'''Delimited: '''{{#cargo_query:
 +
tables=Infobox_game,Infobox_game__Released
 +
|join on=Infobox_game._ID=Infobox_game__Released._rowID
 +
|fields=DATE_FORMAT(Infobox_game__Released._value,"%M %e, %Y")
 +
|where=Infobox_game._pageName="Half-Life"
 +
|group by=Infobox_game._pageName,Infobox_game__Released._value
 +
|format=list
 +
|delimiter=&nbsp;and
 +
}}
  
−
===Other stuff===
+
---
  
 +
'''Duplicate data in table ? Returns 2 rows -- should only be 1 !'''
  
−
{{ii}} Possibly warrants further investigation: List of games available from Epic Games Store using Denuvo Anti-Tamper.
+
{{#cargo_query:
−
{{mm}} '''Total number of games: '''{{#ask: [[Category:Games]] [[Uses DRM::Denuvo Anti-Tamper]] [[Available from::Epic Games Store]] |format=count }}
+
tables=Infobox_game
 +
|fields=Infobox_game._pageName,Infobox_game.Released=DateUnformatted,DATE_FORMAT(Infobox_game.Released__full,"%M %e, %Y")=DateFormatted,COUNT(*)=NumOfRows
 +
|where=Infobox_game._pageName="Quake"
 +
}}
  
−
<div style="overflow-x:auto">{{#ask: [[Category:Games]] [[Uses DRM::Denuvo Anti-Tamper]] [[Available from::Epic Games Store]]
+
-->
−
|?Part of series=Series
 
−
|?Developed by
 
−
|?Published by
 
−
|?Release date|+limit=1
 
−
|?Available on
 
−
|format=table
 
−
|limit=500
 
−
|template=Feature/row
 
−
|introtemplate=Feature/intro
 
−
|outrotemplate=Feature/outro
 
−
|sep=,&ensp;
 
−
|mainlabel=Game
 
−
}}</div>
 

Latest revision as of 18:56, 9 April 2024

Cargo data with some reference inserted?


Cargo data with some newlines inserted?



Example query

_pageName Developers Publishers Engines Released
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19


Broken backend data: (nothing beyond infobox game seems to be populated)

_pageName Series Developers Publishers Engines Released Released Windows Windows ARM app Language Cloud.Steam Available from
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true English true Microsoft Store • Steam
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true Simplified Chinese true Microsoft Store • Steam
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true French true Microsoft Store • Steam
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true German true Microsoft Store • Steam
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true Italian true Microsoft Store • Steam
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true Japanese true Microsoft Store • Steam
Make It Rain: The Love of Money Company:Game Troopers 2015-02-19 2015-02-19 true Spanish true Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown English true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Simplified Chinese true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown French true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown German true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Italian true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Japanese true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Polish true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Brazilian Portuguese true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Russian true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
NieR: Automata NieR Company:PlatinumGames • Company:Square Enix • Company:QLOC Company:Square Enix Engine:Platinum Engine 2017-03-17 2017-03-17 unknown Spanish true Retail • Publisher website • Green Man Gaming • Humble Store • Microsoft Store • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown English true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Simplified Chinese true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Traditional Chinese true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown French true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown German true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Italian true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Japanese true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Polish true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Russian true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Spanish true Retail • Official website • Humble Store • GOG.com • Steam
War for the Overworld Company:Subterranean Games Company:Subterranean Games • Company:Sold Out Engine:Unity 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02 unknown Latin American Spanish true Retail • Official website • Humble Store • GOG.com • Steam

Test using User:Aemony/Sandbox/Bot2 and {{Save game cloud syncing}}:

_pageName Released Released Windows Series
NieR: Automata 2017-03-17 2017-03-17 NieR
War for the Overworld 2015-04-02 • 2015-04-02 • 2015-04-02 2015-04-02
Error 1054: Unknown column 'Infobox_game._pageName' in 'where clause' (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

Function: CargoSQLQuery::run Query: SELECT `cargo__Cloud`.`_pageID` AS `cargo_backlink_page_id_Cloud`,`cargo__Cloud`.`_pageName` AS `_pageName`,`cargo__Cloud`.`Steam` AS `Cloud.Steam` FROM `cargo__Cloud` WHERE `cargo__Cloud`.`_pageName`="User:Aemony/Sandbox/Bot2" OR `cargo__Cloud`.`_pageName`="NieR: Automata" OR `cargo__Cloud`.`_pageName`="NieR: Automata2" OR `cargo__Cloud`.`_pageName`="Make It Rain: The Love of Money2" OR Infobox_game._pageName="War for the Overworld" ORDER BY `cargo__Cloud`.`_pageID`,`cargo__Cloud`.`_pageName`,`cargo__Cloud`.`Steam` LIMIT 100


Proper backend data:

_pageName Series Developers Publishers Engines Released Released Windows Windows ARM app Language Cloud.Steam Available from
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true English true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Simplified Chinese true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true French true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true German true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Japanese true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Korean true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Polish true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Brazilian Portuguese true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Russian true Microsoft Store • Steam
9 Clues: The Secret of Serpent Creek 9 Clues Company:Tap It Games Company:Artifex Mundi Engine:Spark Casual Engine 2013-07-18 • 2013-07-18 • 2013-07-18 2013-07-18 true Spanish true Microsoft Store • Steam