SELECT
DISTINCT VbpKroIUl6_posts.*, count(*) OVER() AS totalJob
FROM
VbpKroIUl6_posts
WHERE
VbpKroIUl6_posts.post_type = 'vacature' AND VbpKroIUl6_posts.post_status = 'publish' GROUP BY VbpKroIUl6_posts.ID ORDER BY VbpKroIUl6_posts.post_date DESC LIMIT 140,10