Difference between revisions of "RatingsTable"
From Sega Retro
(Created page with "{{TODO}} My SQL skills aren't good enough - the "group by" option is stopping duplicates from coming from the releases table, but also the duplicates from the ratings table (...") |
|||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
My SQL skills aren't good enough - the "group by" option is stopping duplicates from coming from the releases table, but also the duplicates from the ratings table (which we want, because games are sometimes reviewed twice). I don't know how to fix this -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 06:50, 15 May 2020 (EDT) | My SQL skills aren't good enough - the "group by" option is stopping duplicates from coming from the releases table, but also the duplicates from the ratings table (which we want, because games are sometimes reviewed twice). I don't know how to fix this -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 06:50, 15 May 2020 (EDT) | ||
| + | :Had an idea while lying in bed last night - seems to have worked -[[User:Black Squirrel|Black Squirrel]] ([[User talk:Black Squirrel|talk]]) 12:19, 18 May 2020 (EDT) | ||
Latest revision as of 11:19, 18 May 2020
My SQL skills aren't good enough - the "group by" option is stopping duplicates from coming from the releases table, but also the duplicates from the ratings table (which we want, because games are sometimes reviewed twice). I don't know how to fix this -Black Squirrel (talk) 06:50, 15 May 2020 (EDT)
- Had an idea while lying in bed last night - seems to have worked -Black Squirrel (talk) 12:19, 18 May 2020 (EDT)