A whole slew of SQL follies... T2(posted 9538 days ago)When selecting (2 games have no score yet...)
running MySQL query: SELECT a.short_name, score, confirmed, a.prefix, version, date, inp, description, original, full_name, long_name, pos, percent FROM allscores a, tagdata t, gamedata g WHERE tournament = 2 AND pos <= 3 AND pos >= 1 AND a.prefix = t.prefix AND a.short_name = g.short_name ORDER BY g.short_name, score desc, full_name LIMIT 1000
query 'SELECT a.short_name, score, confirmed, a.prefix, v...' took 0.018s
When selecting gameboy's name
running MySQL query: SELECT a.short_name, score, confirmed, a.prefix, version, date, inp, description, original, full_name, long_name, pos, percent FROM allscores a, tagdata t, gamedata g WHERE full_name LIKE 'gameboy9' AND tournament = 2 AND pos <= 99 AND pos >= 1 AND a.prefix = t.prefix AND a.short_name = g.short_name ORDER BY g.short_name, score desc, full_name LIMIT 1000
query 'SELECT a.short_name, score, confirmed, a.prefix, v...' took 0.214s
running MySQL query: SELECT a.short_name, score, confirmed, a.prefix, version, date, inp, description, original, full_name, long_name, pos, percent FROM allscores a, tagdata t, gamedata g WHERE (a.short_name = 't2-ccastles' AND score > 171950 OR a.short_name = 't2-jrpacman' AND score > 44220 OR a.short_name = 't2-kungfum' AND score > 33260 OR a.short_name = 't2-lrescue' AND score > 7170 OR a.short_name = 't2- pooyan' AND score > 124100 OR a.short_name = 't2-rastan' AND score > 47600 OR a.short_name = 't2-scramble' AND score > 15450 OR a.short_name = 't2-ssprint' AND score > 13210) AND a.prefix = t.prefix AND a.short_name = g.short_name ORDER BY g.short_name, score desc, full_name LIMIT 992
query 'SELECT a.short_name, score, confirmed, a.prefix, v...' took 0.018s