Most Popular Mysql Row over last 7 days

In one table I have

ID, PAGE_ID, DATE

Each time a page is loaded, the DATE, PAGE_ID [from the page table below] are 开发者_开发知识库loaded into the table above.

I am trying to calculate and sort pages by popularity. The page table contains:

ID [PAGE_ID], DESCRIPTION, DATE

I have no idea where to start.

select L.PAGE_ID, P.DESCRIPTION, count(L.ID) from LOADED_PAGE L 
inner join PAGE P on P.ID = L.PAGE_ID
where L.DATE > :sevenDaysAgo 
group by L.PAGE_ID, P.DESCRIPTION
order by count(L.ID) desc

will give you the list of loaded pages, from the most popular to the least one.

select 
id_page,
count(*) as popularity
from table
where date >= curdate() - interval 7 day
group by id_page
order by popularity desc