Top 100 ZX Spectrum Games

General software. From trouble with the Banyan Tree to OCP Art Studio, post any general software chat here. Could include game challenges...
User avatar
Einar Saukas
Bugaboo
Posts: 3070
Joined: Wed Nov 15, 2017 2:48 pm

Re: Top 100 ZX Spectrum Games

Post by Einar Saukas »

akeley wrote: Sat Oct 10, 2020 2:48 pm I realise it'd be a mammoth task to add separate flags to all the entries.
Not really. All information is already organized in ZXDB. It's just a matter of deciding exactly what we want.

How about this?

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
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

No 73 today and it's US Gold's conversion of Gauntlet
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

Yesterday gave us no 72, the ultra fast shoot em up, Dark Star.

Today was another biggie, Jon Ritman and Ocean's Match Day
User avatar
RWAC
Manic Miner
Posts: 698
Joined: Sun Aug 18, 2019 9:59 pm

Re: Top 100 ZX Spectrum Games

Post by RWAC »

jdanddiet wrote: Mon Oct 12, 2020 6:57 pm Yesterday gave us no 72, the ultra fast shoot em up, Dark Star.

Today was another biggie, Jon Ritman and Ocean's Match Day
It's no Emlyn Hughes International Soccer is it?
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

Maybe not. I never played emlyn on the Speccy though so dont expect to see it on this list. I do admire it though, as played it a lot on a mate's amstrad 6128
User avatar
Morkin
Bugaboo
Posts: 3251
Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK

Re: Top 100 ZX Spectrum Games

Post by Morkin »

Not sure Match Day has aged that well really.

Match Day 2 is OK, but I found both of these games uber-clunky after playing Emlyn Hughes.
My Speccy site: thirdharmoniser.com
User avatar
Ivanzx
Manic Miner
Posts: 736
Joined: Tue Nov 14, 2017 9:51 am

Re: Top 100 ZX Spectrum Games

Post by Ivanzx »

Any Homebrew in the list? :)
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

Ivanzx wrote: Tue Oct 13, 2020 9:30 am Any Homebrew in the list? :)
No, I havent included homebrew in my list
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

70 and 69 today
Avalon and Universal hero
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

68 yesterday was starstrike 2
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

Friday update. Lots of big hitters next week!

100.Alchemist
99.Bumpy
98.Earthlight
97.Wizball
96.Marauder
95.Ghostbusters
94.Chronos
93.Secret Diary of Adrian Mole
92.Grumpy Gumphrey Supersleuth
91.Confuzion
90.Glass
89.Dan Dare
88.Gunrunner
87.Mikie
86.They Stole A Million
85.Nemesis The Warlock
84.Stonkers
83.Operation Wolf
82.Licence To Kill
81.Alien
80.International Cricket
79.Future Games
78.Target Renegade
77.Dandy
76.Zzoom
75.Avenger Way of the Tiger 2
74.Pippo
73.Gauntlet
72.Dark Star
71.Match Day
70.Avalon
69.Universal Hero
68.Starstrike II
67.Scuba Dive
User avatar
RWAC
Manic Miner
Posts: 698
Joined: Sun Aug 18, 2019 9:59 pm

Re: Top 100 ZX Spectrum Games

Post by RWAC »

Scuba Dive is a great game!
User avatar
cmal
Manic Miner
Posts: 619
Joined: Fri Jun 05, 2020 1:05 am
Location: California

Re: Top 100 ZX Spectrum Games

Post by cmal »

Scuba Dive is a classic! I don't know why that game doesn't appear more often in top 100s.
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

66 Myth history in the making
65 180
User avatar
Juan F. Ramirez
Bugaboo
Posts: 5102
Joined: Tue Nov 14, 2017 6:55 am
Location: Málaga, Spain

Re: Top 100 ZX Spectrum Games

Post by Juan F. Ramirez »

180, great darts game!
User avatar
Morkin
Bugaboo
Posts: 3251
Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK

Re: Top 100 ZX Spectrum Games

Post by Morkin »

jdanddiet wrote: Mon Oct 19, 2020 9:00 am 180
"There's only one word for that: magic darts!"
My Speccy site: thirdharmoniser.com
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

Morkin wrote: Mon Oct 19, 2020 9:36 am
jdanddiet wrote: Mon Oct 19, 2020 9:00 am 180
"There's only one word for that: magic darts!"
:lol:
User avatar
RWAC
Manic Miner
Posts: 698
Joined: Sun Aug 18, 2019 9:59 pm

Re: Top 100 ZX Spectrum Games

Post by RWAC »

jdanddiet wrote: Mon Oct 19, 2020 9:00 am 66 Myth history in the making
65 180
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game! :o
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

RWAC wrote: Mon Oct 19, 2020 10:22 am
jdanddiet wrote: Mon Oct 19, 2020 9:00 am 66 Myth history in the making
65 180
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game! :o
I look forward to seeing your list :mrgreen:
User avatar
stupidget
Dynamite Dan
Posts: 1611
Joined: Wed Jan 24, 2018 2:09 pm
Location: Sunny Wolverhampton

Re: Top 100 ZX Spectrum Games

Post by stupidget »

RWAC wrote: Mon Oct 19, 2020 10:22 am
jdanddiet wrote: Mon Oct 19, 2020 9:00 am 66 Myth history in the making
65 180
Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game! :o
I must admit that my mate and I had far more fun playing 180 than we did with Myth.
User avatar
RWAC
Manic Miner
Posts: 698
Joined: Sun Aug 18, 2019 9:59 pm

Re: Top 100 ZX Spectrum Games

Post by RWAC »

jdanddiet wrote: Mon Oct 19, 2020 10:50 am
RWAC wrote: Mon Oct 19, 2020 10:22 am Oh man this kills me!
Myth is easily a top 20 game, and you've put it below a bloody darts game! :o
I look forward to seeing your list :mrgreen:
When I post mine, you'll probably want to redo yours! :lol:
User avatar
RWAC
Manic Miner
Posts: 698
Joined: Sun Aug 18, 2019 9:59 pm

Re: Top 100 ZX Spectrum Games

Post by RWAC »

stupidget wrote: Mon Oct 19, 2020 10:50 am I must admit that my mate and I had far more fun playing 180 than we did with Myth.
C - Nonsense in BASIC
User avatar
vanpeebles
Microbot
Posts: 152
Joined: Wed Jan 08, 2020 9:23 am
Location: UK
Contact:

Re: Top 100 ZX Spectrum Games

Post by vanpeebles »

I was never a Myth fan anarl. Might have to try it again one day.
Sinclair QL Forum: https://www.qlforum.co.uk/
Tatung Einstein Forum: https://www.robheaton.co.uk/tatung/
My Youtube Gaming Channel Acorn 32-bit, X68000 & QL: https://www.youtube.com/user/peetvanpeebles
User avatar
jdanddiet
Manic Miner
Posts: 213
Joined: Tue Jun 23, 2020 1:11 pm

Re: Top 100 ZX Spectrum Games

Post by jdanddiet »

I admit nostalgia is playing a big part in my list. And while I appreciate Myth and enjoyed it a lot, I played 180 a lot with my Dad and that brings some very happy memories.
User avatar
Morkin
Bugaboo
Posts: 3251
Joined: Mon Nov 13, 2017 8:50 am
Location: Bristol, UK

Re: Top 100 ZX Spectrum Games

Post by Morkin »

Heh - I was going to comment on the low placing of a couple of games, but I figured if a game I rated top 10 appeared at 60-something in someone else's list, it still means they rate it highly (just not as high as some others).. :lol:
My Speccy site: thirdharmoniser.com
Post Reply