SELECT * FROM wp_posts wpp
JOIN wp_postmeta wpm ON wpp.id = wpm.post_id
WHERE wpp.post_date BETWEEN <начало периода> AND <конец периода>
AND wpm.meta_key= 'post_views_count'
ORDER BY wpm.meta_value ASC

Disallow: */vacancy/*