mysql query help in selecting top votes
- by moustafa
i have table posts and posts_votes in posts_votes i have id and post_id and vote
now i want select from posts where have top votes count in last 1 day using this to set the time
from_unixtime(post_date) >= SUBDATE(NOW(),1)
thanks in advance