Difference between revisions of "RatingsGraph"
From Sega Retro
| Line 7: | Line 7: | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=ratings,releases,magnames,videonames | + | tables=ratings,releases,magnames,videonames |
| − | |fields=ratings.score,ratings.code, | + | |fields=ratings.score,ratings.code,ratings.issue |
|where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}" | |where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}" | ||
| − | |join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code | + | |join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code |
|order by=ratings.code,magnames.country,ratings.version | |order by=ratings.code,magnames.country,ratings.version | ||
|group by=ratings.code,ratings.version,ratings.issue | |group by=ratings.code,ratings.version,ratings.issue | ||
| Line 24: | Line 24: | ||
{{#cargo_query: | {{#cargo_query: | ||
| − | tables=ratings,releases,magnames,videonames | + | tables=ratings,releases,magnames,videonames |
| − | |fields=ratings.score,ratings.code, | + | |fields=ratings.score,ratings.code,ratings.issue |
|where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}" | |where=ratings.name="{{#var:name}}" and ratings.format="{{#var:format}}" | ||
| − | |join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code | + | |join on=ratings.name=releases.name,ratings.code=magnames.code,ratings.code=videonames.code |
|order by=ratings.code,magnames.country,ratings.version | |order by=ratings.code,magnames.country,ratings.version | ||
|group by=ratings.code,ratings.version,ratings.issue | |group by=ratings.code,ratings.version,ratings.issue | ||
Revision as of 12:39, 1 March 2024
 |
This task is unfinished This is a wiki task that requires more thought or peer review. An important issue that needs to be solved, which will appear at the top of Sega Retro:Todo until this message is removed. |
Stupid ideas approaching
<div title="96: Computer & Video Games (1995-07-12)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 12px;">
<div title="80: Edge (1995-04-27)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 60px;">
<div title="75: Weekly Famitsu (1995-03-24)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 75px;">
<div title="85: MAN!AC (1995-05-10)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 45px;">
<div title="85: MAN!AC (1995-07-12)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 45px;">
<div title="100: Maximum (1995-09-01)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 0px;">
<div title="95: Mega (1995-04-30)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 15px;">
<div title="87: Mega Fun (1995-07-19)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 39px;">
<div title="92: Mean Machines Sega (1995-04-28)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 24px;">
<div title="96: Mean Machines Sega (1995-07-27)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 12px;">
<div title="75: Next Generation (1995-06-20)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 75px;">
<div title="85: Power Unlimited (1995-06-28)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 45px;">
<div title="87.133333333333: Saturn Fan (1995-05-08)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 38.600000000001px;">
<div title="82: Saturn+ (1995-12-14)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 54px;">
<div title="80: Secret Service (1996-05-01)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 60px;">
<div title="90: Sega Magazin (1995-07-12)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 30px;">
<div title="94: Sega Magazine (UK) (1995-07-13)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 18px;">
<div title="87: Sega Power (1995-04-20)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 39px;">
<div title="94: Sega Pro (1995-04-13)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 18px;">
<div title="92: Sega Pro (1995-08-10)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 24px;">
<div title="93.333333333333: Sega Saturn Magazine (Japan) (1995-03-08)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 20.000000000001px;">
<div title="85.886: Sega Saturn Magazine (Japan) (2000-03)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 42.342px;">
<div title="63: Total Saturn (1996-12-29)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 111px;">
<div title="84: Ultimate Future Games (1995-05-01)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 48px;">
<div title="84: Ultimate Future Games (1995-08-01)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 48px;">
<div title="90: Video Games (Germany) (1995-07-26)" style="background-color: #F00; position:relative; width: 5px; height:5px; margin-left:-5px; margin-top:-5px; left: Expression error: Unexpected < operator.px; top: 30px;">
| score | code | issue |
|---|---|---|
| 91.0 | alaabalc | 2 |
| 60.0 | cdconsoles | 7 |
| 93.0 | consolemania | 41 |
| 93.0 | consolesplus | 43 |
| 96.0 | cvg | 163 |
| 96.0 | cvg | 165 |
| 90.0 | digitiser | 1995-07-12 |
| 80.0 | edge | 21 |
| 75.0 | ee | 1995-08 |
| 77.5 | egm | 72 |
| 75.0 | famitsu | 329 |
| 88.0 | gamefan | 0307 |
| 90.0 | gameplayers | 0808 |
| 82.5 | gamepro | 73 |
| 93.0 | gamesworld | 12 |
| 94.0 | gamesworld | 15 |
| 86.111111111111 | gi | 27 |
| 80.0 | hitech | 3 |
| 50.0 | leveltr | 5 |
| 85.0 | maniac | 1995-06 |
| 85.0 | maniac | 1995-08 |
| 100.0 | maximum | 1 |
| 95.0 | mega | 32 |
| 95.0 | megaforce | 39 |
| 87.0 | megafun | 1995-08 |
| 75.0 | migr | 2 |
| 92.0 | mms | 32 |
| 96.0 | mms | 35 |
| 75.0 | nextgeneration | 7 |
| 95.0 | playerone | 55 |
| 68.75 | playersbr | 2 |
| 85.0 | pu | 23 |
| 87.133333333333 | saturnfan | 1995-06 |
| 82.0 | saturnplus | 1 |
| 80.0 | secretservice | 35 |
| 90.0 | segamagazin | 21 |
| 94.0 | segamaguk | 20 |
| 88.0 | seganewscz | 1 |
| 87.0 | segapower | 67 |
| 94.0 | segapro | 45 |
| 92.0 | segapro | 49 |
| 75.0 | sgk | 45 |
| 88.0 | smz | 54 |
| 93.333333333333 | ssmjp | 1995-04 |
| 85.886 | ssmjp | readers |
| 60.0 | stranaigr | 1 |
| 89.0 | superjuegos | 40 |
| 93.0 | todosega | 29 |
| 80.0 | topconsoles | 2 |
| 63.0 | ts | 4 |
| 84.0 | ufg | 7 |
| 84.0 | ufg | 10 |
| 88.0 | ultimageneracion | 3 |
| 90.0 | videogames | 1995-08 |
| 80.0 | videogamesus | 77 |