SELECT ps.* FROM cdb_playsgame ps WHERE ps.credits=(select MAX(credits)  FROM cdb_playsgame ps1  where ps.uid=ps1.uid AND ps.gametag=ps1.gametag) AND ps.gametag='yeti3'  GROUP BY ps.uid order by ps.credits desc LIMIT 100; 

SELECT ps.*  FROM cdb_playsgame ps,(select ps1.uid, ps1.gametag, MAX(credits) as credits FROM cdb_playsgame ps1 group by uid,gametag) t WHERE ps.credits=t.credits AND ps.uid=t.uid AND ps.gametag=t.gametag AND ps.gametag='yeti3'  GROUP BY ps.uid order by ps.credits desc LIMIT 100; 

 SELECT ps. * , mf. * , m.username FROM cdb_playsgame ps LEFT JOIN cdb_memberfields mf ON mf.uid = ps.uid LEFT JOIN cdb_members m ON m.uid = ps.uid WHERE ps.gametag = 'chuansj' AND FROM_UNIXTIME( ps.dateline, '%Y%m%d' ) = '20081008' AND ps.credits = ( SELECT MAX( ps1.credits ) FROM cdb_playsgame ps1 WHERE ps.uid = ps1.uid AND ps1.gametag = 'chuansj' AND FROM_UNIXTIME( ps1.dateline, '%Y%m%d' ) = '20081008' ) GROUP BY ps.uid ORDER BY credits DESC LIMIT 0 , 50  

AND ps.credits=(SELECT MAX(ps1.credits)   FROM {$tablepre}playsgame ps1 where ps.uid=ps1.uid AND ps1.gametag = '$game'   AND FROM_UNIXTIME(ps1.dateline, '%Y%m%d') = '$todaytime' ) 

FROM_UNIXTIME(ps1.dateline, '%Y%m%d') = '$todaytime' 

AND ps1.dateline >= UNIX_TIMESTAMP('$todaytime')  

 SELECT ps. * , mf. * , m.username FROM cdb_playsgame ps, cdb_memberfields mf, cdb_members m, (  SELECT ps1.uid, MAX( ps1.credits ) AS credits FROM cdb_playsgame ps1 WHERE ps1.gametag = 'chuansj' AND ps1.dateline >= UNIX_TIMESTAMP( '20081008' ) GROUP BY ps1.uid ) AS t WHERE mf.uid = ps.uid AND m.uid = ps.uid AND ps.gametag = 'chuansj' AND ps.credits = t.credits AND ps.uid = t.uid GROUP BY ps.uid ORDER BY credits DESC LIMIT 0 , 50  

SELECT PLAYERNO,NAME,NUMBER FROM (SELECT PLAYERNO,NAME,        (SELECT COUNT(*)        FROM PENALTIES        WHERE PENALTIES.PLAYERNO =           PLAYERS.PLAYERNO)        AS NUMBER     FROM PLYERS) AS PN WHERE NUMBER>=2