Difference between revisions of "GetNumberOfRatings"

From Sega Retro

(Created page with "<includeonly>{{#cargo_query: tables=ratings |fields=count(ratings.score) |where=ratings.name="{{{1|}}}" and ratings.format="{{{2|}}}" |limit=1000 }}</includeonly><noinclude>Te...")
 
Line 2: Line 2:
 
tables=ratings
 
tables=ratings
 
|fields=count(ratings.score)
 
|fields=count(ratings.score)
|where=ratings.name="{{{1|}}}" and ratings.format="{{{2|}}}"
+
|where=ratings.name="{{#replace:{{{1|}}}|"|""}}" and ratings.format="{{{2|}}}"
 
|limit=1000
 
|limit=1000
 
}}</includeonly><noinclude>Template to get Sega Retro average score:
 
}}</includeonly><noinclude>Template to get Sega Retro average score:
Line 8: Line 8:
 
<pre>{{GetNumberOfRatings|688 Attack Sub|MD}}</pre>
 
<pre>{{GetNumberOfRatings|688 Attack Sub|MD}}</pre>
 
{{GetNumberOfRatings|688 Attack Sub|MD}}
 
{{GetNumberOfRatings|688 Attack Sub|MD}}
 +
 +
<pre>{{GetNumberOfRatings|James "Buster" Douglas Knockout Boxing (Mega Drive)|MD}}</pre>
 +
{{GetNumberOfRatings|James "Buster" Douglas Knockout Boxing (Mega Drive)|MD}}
  
 
[[Category:Sega Retro templates]]</noinclude>
 
[[Category:Sega Retro templates]]</noinclude>

Revision as of 06:39, 18 March 2021

Template to get Sega Retro average score:

{{GetNumberOfRatings|688 Attack Sub|MD}}

28

{{GetNumberOfRatings|James "Buster" Douglas Knockout Boxing (Mega Drive)|MD}}

0