Difference between revisions of "User:Garrett/Sandbox3"
(→Cargo: GOG only) |
|||
Line 29: | Line 29: | ||
tables=Infobox_game,Tags | tables=Infobox_game,Tags | ||
|join on=Infobox_game._pageName=Tags._pageName | |join on=Infobox_game._pageName=Tags._pageName | ||
+ | |where=Infobox_game.GOGcom_page HOLDS LIKE '%' | ||
|fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub=Incomplete,Tags.Tickcross_unknown="unknown",Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots=Screenshots,Tags.Video_screenshots=Video screens,Tags.Input_screenshots=Input screens,Tags.Audio_screenshots=Audio screens,Tags.Network_screenshots=Network screens,Tags.VR_screenshots=VR screens | |fields=Tags._pageName,Infobox_game._pageName,Infobox_game.Cover,Tags.Stub=Incomplete,Tags.Tickcross_unknown="unknown",Tags.Config_data,Tags.Save_data,Tags.Settings_screenshots=Screenshots,Tags.Video_screenshots=Video screens,Tags.Input_screenshots=Input screens,Tags.Audio_screenshots=Audio screens,Tags.Network_screenshots=Network screens,Tags.VR_screenshots=VR screens | ||
|limit=5}} | |limit=5}} |
Revision as of 10:16, 2 September 2021
SMW
Total number of games: {{#ask: GOGcom page::+ Tickcross unknown::≥0 | format=count}} {{#ask: GOGcom page::+ Tickcross unknown::≥0 | ?Cover filename | ?Article state is stub | ?Tickcross unknown | ?Config data | ?Save data | ?Settings screenshots | ?Video screenshots | ?Input screenshots | ?Audio screenshots | ?Network screenshots | ?VR screenshots | format=template | introtemplate=Completion/intro | template=Completion/row | offset=0 | limit=5 | sort=Tickcross unknown,Article state is stub | order=desc,desc }} |}
Cargo
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`,`cargo__Infobox_game`.`_pageName` AS `_pageName`,`cargo__Infobox_game`.`Cover` AS `Cover`,`cargo__Tags`.`Stub` AS `Incomplete`,`cargo__Tags`.`Tickcross_unknown` AS `"unknown"`,`cargo__Tags`.`Config_data` AS `Config data`,`cargo__Tags`.`Save_data` AS `Save data`,`cargo__Tags`.`Settings_screenshots` AS `Screenshots`,`cargo__Tags`.`Video_screenshots` AS `Video screens`,`cargo__Tags`.`Input_screenshots` AS `Input screens`,`cargo__Tags`.`Audio_screenshots` AS `Audio screens`,`cargo__Tags`.`Network_screenshots` AS `Network screens`,`cargo__Tags`.`VR_screenshots` AS `VR screens` FROM `cargo__Infobox_game` LEFT OUTER JOIN `cargo__Tags` ON ((`cargo__Infobox_game`.`_pageName`=`cargo__Tags`.`_pageName`)) WHERE `cargo__Infobox_game`.`GOGcom_page` HOLDS LIKE '%' ORDER BY `cargo__Tags`.`_pageID`,`cargo__Infobox_game`.`_pageID`,`cargo__Infobox_game`.`_pageName`,`cargo__Infobox_game`.`Cover`,`cargo__Tags`.`Stub` LIMIT 100