Miscellany

create temp table pstats as (
select 
 d.serverid,
 d.time,
 d.score,
 d.totalscore as ptotalscore,
 d.map as pmap,
 s.ip,
 s.geo,
 s.city,
 s.region,
 s.latitude,
 s.game,
 s.type,
 s.map as smap,
 s.currentplayers,
 s.maxplayers,
 s.totaltime,
 s.totalplayers,
 s.name,
 s.totalscore as stotalscore
from 
 day200stats as d, 
 server7stats as s 
where 
 s.yday=242 and 
 d.playerid=3791 and 
 d.serverid=s.id 
);