mysql problem left join and from_unixtime

Posted by moustafa on Stack Overflow See other posts from Stack Overflow or by moustafa
Published on 2010-03-17T15:01:56Z Indexed on 2010/03/28 10:23 UTC
Read the original article Hit count: 255

Filed under:
|

i have this

SELECT COUNT(1) cnt, a.auther_id
                            FROM `posts` a 
                                LEFT JOIN users u ON a.auther_id = u.id
                                    GROUP BY a.auther_id
                                        ORDER BY cnt DESC
                                            LIMIT 20

its work fine bu now i want select from posts which added from 1 day tried to use

WHERE from_unixtime(post_time) >= SUBDATE(NOW(),1) 

but its didnot worked any one have idea

© Stack Overflow or respective owner

Related posts about multiple-tables

Related posts about mysql