Complete release list

General software. From trouble with the Banyan Tree to OCP Art Studio, post any general software chat here. Could include game challenges...
User avatar
hitm4n
Manic Miner
Posts: 620
Joined: Fri Nov 17, 2017 12:56 pm

Re: Complete release list

Post by hitm4n »

Theretrochief wrote: Wed Aug 21, 2019 3:47 pm Not familiar with Starquake or Equinox unfortunately
Starquake. One of THE best games created, not only on the speccy, but in the WORLD, possibly the universe!
(i.e. try it... :) )
I don't have anything cool to put here, so i'll just be off now to see a priest with yeast stuck between his teeth and his friend called Keith who's a hairpiece thief...
Theretrochief
Drutt
Posts: 15
Joined: Wed Aug 21, 2019 9:45 am

Re: Complete release list

Post by Theretrochief »

Are we all out of suggestions?
User avatar
PeterJ
Site Admin
Posts: 6878
Joined: Thu Nov 09, 2017 7:19 pm
Location: Surrey, UK

Re: Complete release list

Post by PeterJ »

Theretrochief wrote: Thu Aug 22, 2019 10:32 am
PeterJ wrote: Wed Aug 21, 2019 6:28 pm If you just want a spreadsheet I can do that for you from the database that @Einar Saukas created which powers this site and others.
Yes please, that would be most appreciated! :D
Apologies for the delay. Just sending it now. This is the code I used. Let me know if you need anything else. If you want the original release just filter release_seq for 0.

Code: Select all

select e.id, e.title, r.release_year, l.name, r.release_seq

from entries e, releases r, publishers p, labels l

where e.is_crap = 0
and e.id=r.entry_id
and p.entry_id = e.id
and p.release_seq = r.release_seq
and l.id = p.label_id
Post Reply