Difference between revisions of "User:Aemony/Sandbox"
m (added series) |
m (OR Infobox_game._pageName="War for the Overworld") |
||
Line 22: | Line 22: | ||
tables=Infobox_game,API,L10n,Cloud,Availability | 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 | |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" | + | |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 | + | |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 | |format=table | ||
}} | }} | ||
Line 30: | Line 30: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Infobox_game | 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" | + | |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 | |fields=Infobox_game._pageName,Infobox_game.Released,Infobox_game.Released_Windows,Infobox_game.Series | ||
|format=table | |format=table | ||
Line 37: | Line 37: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Cloud | 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" | + | |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 | |fields=Cloud._pageName,Cloud.Steam=Cloud.Steam | ||
|format=table | |format=table | ||
Line 48: | Line 48: | ||
|join on=Infobox_game._pageName=API._pageName,Infobox_game._pageName=L10n._pageName,Infobox_game._pageName=Cloud._pageName,Infobox_game._pageName=Availability._pageName | |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" | |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 | + | |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 | |format=table | ||
}} | }} |
Revision as of 04:32, 30 September 2022
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 | 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 | 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 |