Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Grupavimas

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