It's the score value that counts.
Position is simply calculated from scores.
First we need a better definition of "exclusive".
I think to start with it could be fairly straightforward. If you look at the lemon64 site, you can search for availability on other platforms (Spectrum, Amstrad etc). However all you’d need to do is list the opposite of that, “not available on any other platform”.Einar Saukas wrote: ↑Sat Oct 10, 2020 1:58 pmFirst we need a better definition of "exclusive".
What about Spectrum games based on ZX81 games (like Maziacs based on Mazogs), should we consider them exclusive or not?
What about Spectrum games ported to Spectrum-like platforms like SAM Coupe, should we still consider them exclusive?
What about Spectrum games with remakes to other platforms (PC, mobile, etc), are they still exclusive?
Yes, "based on" may be still a different game + it's the Sinclair family.Einar Saukas wrote: ↑Sat Oct 10, 2020 1:58 pm What about Spectrum games based on ZX81 games (like Maziacs based on Mazogs), should we consider them exclusive or not?
Yes, SAM had a compatibility mode, so it's really still a Spectrum game.Einar Saukas wrote: ↑Sat Oct 10, 2020 1:58 pm What about Spectrum games ported to Spectrum-like platforms like SAM Coupe, should we still consider them exclusive?
Yes, remakes and ports from modern times are a different story from the historical point of view.Einar Saukas wrote: ↑Sat Oct 10, 2020 1:58 pm What about Spectrum games with remakes to other platforms (PC, mobile, etc), are they still exclusive?
Not really. All information is already organized in ZXDB. It's just a matter of deciding exactly what we want.
Code: Select all
select * from entries e left join scores s on e.id = s.entry_id
-- exclude titles also available on other platforms
where e.id not in (select entry_id from ports)
-- exclude official coin-op conversions
and e.id not in (select r.entry_id from relatedlicenses r inner join licenses c
on r.license_id = c.id where r.is_official=1 and c.licensetype_id in ('a','o'))
-- exclude titles ported from ZX81, etc
and e.id not in (select entry_id from relations where relationtype_id='p')
-- games only
and e.genretype_id < 34
-- order by Martijn's WoS score
order by s.score desc, votes desc, e.library_title