We have a table that is arranged as such: ID, Album\_ID and Time\_Voted. Each time a user votes, 
it creates a new record. We'd like to display the top five Album\_IDs, (which had the most records containing that Album\_ID at the end of every week). The only way I know how to do this is to SELECT all records from the past week, then run a "while" on the results,then iterate through an array and and add a +1 to the corresponding Album\_ID key each time it finds an instance of the same Album\_ID. This is quite inefficient, and I'm convinced there's a good way to do this via SQL query, but it's beyond my level of knowlege. 

So the question is, is there a way to, via query, get a count of each number of album\_IDs, and then arrange by that count? 

Here's the original SQL statement I was working with. The YEARWEEK stuff was just to get last week. 

```
SELECT * FROM wp_album_votes WHERE YEARWEEK( Time_Voted ) = YEARWEEK( CURRENT_DATE - INTERVAL 7 DAY ) ORDER BY Album_ID

```