Bugün yükselen isimler
SELECT
k.id,
k.enable_foto,
k.twitter_posted,
k.gunyazi2,
k.meslek,
k.dotar,
k.olum,
k.domainname,
k.person,
k.kisiadi,
(t.daily - t.yesterday_hit) * 100 / GREATEST(t.yesterday_hit, 1) AS trend,
t.daily
FROM kisi_trends t
INNER JOIN kisilerv2_utf8 k ON t.kisi = k.kisiadi
WHERE
t.saat = '08'
AND k.daily > 20
ORDER BY trend DESC
LIMIT 0, 10