credo tu debba fare il join di due tabelle, una cosa tipo questa
codice:
SELECT t1.id 
    FROM tabella as t1
    JOIN (
        SELECT id, count(id) as conteggio
            FROM tabella
            WHERE dateinserted BETWEEN DATE_ADD(CURDATE(), INTERVAL -7 day) AND CURDATE() 
            GROUP BY id) as t2
    ORDER BY t2.conteggio DESC 
    LIMIT 10