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.
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!
OK, will pull something together over the bank holiday.
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...
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!
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.
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