User:Aemony/Sandbox
Example query
_pageName | Developers | Publishers | Engines | Released |
---|---|---|---|---|
Make It Rain: The Love of Money | Company:Game Troopers | 2015-02-19 |
DerpHerp3 Fjorp!
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 | Arabic | 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 | Czech | 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 | Czech | 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 |
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 |