Parašė bdZ reborn· 2008 Rugp. 15 15:08:08
#11
elementaru...
SELECT count(d.download_id) as viso, u.* FROM ".$db_prefix."users u
LEFT JOIN ".$db_prefix."downloads d ON d.download_a=u.user_id
GROUP BY d.download_a
ORDER BY viso DESC
LIMIT 0, 10
download_a - tai id zmogaus kuris idejo faila
klausimas penktokui
isdestis 10 populiaru zmoniu, kurie idejo failus
Redagavo bdZ reborn· 2008 Rugp. 15 15:08:11