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 "PCGamingWiki:GOG.com Enhancement Project/Completion"

From PCGamingWiki, the wiki about fixing PC games
(migrated to Cargo query)
m (|group by=Infobox_game._pageNamespace)
Line 4: Line 4:
 
|fields=COUNT(*)
 
|fields=COUNT(*)
 
|where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Tickcross_unknown > 0
 
|where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Tickcross_unknown > 0
 +
|group by=Infobox_game._pageNamespace
 
|format=text
 
|format=text
 
}}
 
}}
Line 11: Line 12:
 
|join on=Infobox_game._pageName=Tags._pageName
 
|join on=Infobox_game._pageName=Tags._pageName
 
|where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Tickcross_unknown > 0
 
|where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Tickcross_unknown > 0
 +
|group by=Infobox_game._pageNamespace
 
|fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub,Tags.Tickcross_unknown,Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots,Tags.Video_screenshots,Tags.Input_screenshots,Tags.Audio_screenshots,Tags.Network_screenshots,Tags.VR_screenshots
 
|fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub,Tags.Tickcross_unknown,Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots,Tags.Video_screenshots,Tags.Input_screenshots,Tags.Audio_screenshots,Tags.Network_screenshots,Tags.VR_screenshots
 
|format=template
 
|format=template

Revision as of 19:11, 15 June 2023

Total number of games: 4,616

Error 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'pcgamingwiki_cargo.cargo__Infobox_game._pageName' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)

Function: CargoSQLQuery::run Query: SELECT `cargo__Infobox_game`.`_pageName` AS `_pageName`,`cargo__Infobox_game`.`Cover` AS `Cover`,`cargo__Tags`.`Stub` AS `Stub`,`cargo__Tags`.`Tickcross_unknown` AS `Tickcross unknown`,`cargo__Tags`.`Config_data` AS `Config data`,`cargo__Tags`.`Save_data` AS `Save data`,`cargo__Tags`.`Settings_screenshots` AS `Settings screenshots`,`cargo__Tags`.`Video_screenshots` AS `Video screenshots`,`cargo__Tags`.`Input_screenshots` AS `Input screenshots`,`cargo__Tags`.`Audio_screenshots` AS `Audio screenshots`,`cargo__Tags`.`Network_screenshots` AS `Network screenshots`,`cargo__Tags`.`VR_screenshots` AS `VR screenshots` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Infobox_game`.`_ID` IN (SELECT `_rowID` FROM `cargo__Infobox_game__GOGcom_ID` WHERE `_value`LIKE '%') AND `cargo__Tags`.`Tickcross_unknown` > 0 GROUP BY `cargo__Infobox_game`.`_pageNamespace` ORDER BY `cargo__Infobox_game`.`_pageName`,`cargo__Infobox_game`.`Cover`,`cargo__Tags`.`Stub`,`cargo__Tags`.`Tickcross_unknown`,`cargo__Tags`.`Config_data` LIMIT 500