Difference between revisions of "User:Plok/ZOOM Platform article completion list"
From PCGamingWiki, the wiki about fixing PC games
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
<!--- STATUS BAR ---> | <!--- STATUS BAR ---> | ||
− | |||
<onlyinclude> | <onlyinclude> | ||
− | {{#vardefine:total|{{#cargo_query:tables=Availability|fields=TRIM(COUNT(*))|where=Availability. | + | {{#vardefine:total|{{#cargo_query:tables=Availability|fields=TRIM(COUNT(*))|where=Availability.Available_from HOLDS LIKE 'ZOOM Platform'|group by=Availability._pageNamespace|no html|format=text}}}}<!-- |
− | -->{{#vardefine:stubs|{{#cargo_query:tables=Availability,Tags|join on=Availability._pageName=Tags._pageName|fields=TRIM(COUNT(*))|where=Availability. | + | -->{{#vardefine:stubs|{{#cargo_query:tables=Availability,Tags|join on=Availability._pageName=Tags._pageName|fields=TRIM(COUNT(*))|where=Availability.Available_from HOLDS LIKE 'ZOOM Platform' AND Tags.Stub='true'|group by=Availability._pageNamespace|no html|format=text}}}}<!-- |
-->{{#vardefine:completed|{{#expr: ({{#var:total}} - {{#var:stubs}})}}}}<!-- | -->{{#vardefine:completed|{{#expr: ({{#var:total}} - {{#var:stubs}})}}}}<!-- | ||
-->{{#vardefine:percent|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100}}}}<!-- | -->{{#vardefine:percent|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100}}}}<!-- | ||
-->{{#vardefine:percentrounded|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100 round0}}}} | -->{{#vardefine:percentrounded|{{#expr: ({{#var:completed}} / {{#var:total}}) * 100 round0}}}} | ||
− | |||
<div class="progress-bar-container"> | <div class="progress-bar-container"> | ||
<div class="progress-bar"> | <div class="progress-bar"> | ||
Line 17: | Line 15: | ||
</onlyinclude> | </onlyinclude> | ||
+ | <!-- | ||
'''Total number of games (listed): '''{{#cargo_query: | '''Total number of games (listed): '''{{#cargo_query: | ||
− | tables=Infobox_game,Availability | + | tables=Infobox_game,Availability |
− | |join on=Infobox_game._pageName=Availability | + | |join on=Infobox_game._pageName=Availability._pageName |
− | |fields=COUNT(*) | + | |fields=TRIM(COUNT(*)) |
|where=Availability.Available_from HOLDS LIKE 'ZOOM Platform' | |where=Availability.Available_from HOLDS LIKE 'ZOOM Platform' | ||
|format=text | |format=text | ||
Line 26: | Line 25: | ||
'''Total number of games (delisted): '''{{#cargo_query: | '''Total number of games (delisted): '''{{#cargo_query: | ||
− | tables=Infobox_game,Availability | + | tables=Infobox_game,Availability |
− | |join on=Infobox_game._pageName=Availability | + | |join on=Infobox_game._pageName=Availability._pageName |
− | |fields=COUNT(*) | + | |fields=TRIM(COUNT(*)) |
|where=Availability.Available_from_historically HOLDS LIKE 'ZOOM Platform' AND Availability.Available_from HOLDS NOT LIKE 'ZOOM Platform' | |where=Availability.Available_from_historically HOLDS LIKE 'ZOOM Platform' AND Availability.Available_from HOLDS NOT LIKE 'ZOOM Platform' | ||
|format=text | |format=text | ||
− | }} | + | }} --> |
− | --> | ||
{{#cargo_query: | {{#cargo_query: |
Latest revision as of 13:09, 13 August 2023