Select *, count(*) as viewsCount From entries e Where e.PageType=2 Group By e.ID Order By viewsCount DESC Limit 10