Fix the pagination issue with up-and-coming themes (bug 944096)

Can we afford that `COUNT(*)` ?