order by dates that match criteria
I have the following query that outputs users with the highest number of favorites that they received in the past week in descending order: 

    SELECT COUNT(faves.user_id) AS topFaves, faves.created_on, user_name 
    FROM users 
    INNER JOIN faves ON faves.user_id= users.id 
    WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= created_on 
    GROUP BY id ORDER BY topFaves DESC LIMIT 10

 

I would like to be able to extend this list to contain all users, not just from the past week, but still order them by the same criteria (the number of favorites they got in the past week). 
I tried to include a subquery in the select but didnt have any luck with it. 

Thanks in advance for any help

order by dates that match criteria
===

I have the following query that outputs users with the highest number of favorites that they received in the past week in descending order: 

    SELECT COUNT(faves.user_id) AS topFaves, faves.created_on, user_name 
    FROM users 
    INNER JOIN faves ON faves.user_id= users.id 
    WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= created_on 
    GROUP BY id ORDER BY topFaves DESC LIMIT 10

 

I would like to be able to extend this list to contain all users, not just from the past week, but still order them by the same criteria (the number of favorites they got in the past week). 
I tried to include a subquery in the select but didnt have any luck with it. 

Thanks in advance for any help
