CODE
SELECT vtp_members.id, vtp_members.name, vtp_members.email, count(vtp_tracking.id) hits_today
FROM vtp_members, vtp_tracking
WHERE vtp_tracking.credit_members_id=vtp_members.id
AND vtp_tracking.action_date=curdate()
GROUP BY vtp_members.id
ORDER BY hits_today DESC
FROM vtp_members, vtp_tracking
WHERE vtp_tracking.credit_members_id=vtp_members.id
AND vtp_tracking.action_date=curdate()
GROUP BY vtp_members.id
ORDER BY hits_today DESC