Difference between revisions of "PCGamingWiki:GOG.com Enhancement Project/Completion"
From PCGamingWiki, the wiki about fixing PC games
(removed labels (not used in template display mode), added game data columns) |
(migrated to Cargo query) |
||
| Line 1: | Line 1: | ||
| − | '''Total number of games:''' {{# | + | '''Total number of games: '''{{#cargo_query: |
| − | + | tables=Infobox_game,Tags | |
| − | | | + | |join on=Infobox_game._pageName=Tags._pageName |
| − | | | + | |fields=COUNT(*) |
| − | | | + | |where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Tickcross_unknown > 0 |
| − | | | + | |format=text |
| − | + | }} | |
| − | + | ||
| − | + | {{#cargo_query: | |
| − | + | tables=Infobox_game,Tags | |
| − | | | + | |join on=Infobox_game._pageName=Tags._pageName |
| − | | | + | |where=Infobox_game.GOGcom_ID HOLDS LIKE '%' AND Tags.Tickcross_unknown > 0 |
| − | | | + | |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 |
| − | | | + | |limit=500 |
| − | | template=Completion/row | + | |intro={{Completion/intro}} |
| − | | | + | |template=Completion/row |
| − | + | |outro=</table> | |
| − | |||
| − | |||
}} | }} | ||
| − | |||
Revision as of 08:50, 16 October 2021
Total number of games:
Error 1140: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'pcgamingwiki_cargo.cargo__Tags._pageID'; this is incompatible with sql_mode=only_full_group_by (mysql01.mysql.pcgamingwiki-14662257-production.svc.cluster.local)
Function: CargoSQLQuery::run Query: SELECT `cargo__Tags`.`_pageID` AS `cargo_backlink_page_id_Tags`,`cargo__Infobox_game`.`_pageID` AS `cargo_backlink_page_id_Infobox_game`,COUNT(*) 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 ORDER BY `cargo__Tags`.`_pageID`,`cargo__Infobox_game`.`_pageID`,COUNT(*) LIMIT 100