Difference between revisions of "PCGamingWiki:GOG.com Enhancement Project/Completion"
(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:
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