select p.id, p.post_title, p.post_content, p.comment_count, pp.pageviews from wp_posts p inner join wp_popularpostsdata pp on p.id = pp.postid where pp.day >= now() - interval 1 week and p.post_status = 'publish' and post_type = 'post' order by pp.pageviews desc limit 6
Array
(
    [0] => stdClass Object
        (
            [id] => 204253
            [post_title] => Canberra's Best - Potato Scallops*
            [post_content] => *Yeah, I know, they're also called potato cakes by some people. But in Canberra, most peopl...
            [comment_count] => 15
            [pageviews] => 3975
            [image] => 
        )

    [1] => stdClass Object
        (
            [id] => 204090
            [post_title] => No more Mother’s Day in ACT schools… really?
            [post_content] => It’s been a bit of a sad week for me. Last Sunday was Mother’s Day, which I always l...
            [comment_count] => 11
            [pageviews] => 2063
            [image] => Mothers Day
        )

    [2] => stdClass Object
        (
            [id] => 204578
            [post_title] => The Simpsons come to Canberra and there’s a white speed van waiting for them too
            [post_content] => If you love The Simpsons then you’ll enjoy seeing your favourite animations hitting the s...
            [comment_count] => 3
            [pageviews] => 1317
            [image] => The Med School
        )

    [3] => stdClass Object
        (
            [id] => 204241
            [post_title] => A cool $1.4 million buys you Bungendore’s finest plus a secret garden
            [post_content] => A Bungendore property built by a local flour-mill operator 132 years ago has gone on the ma...
            [comment_count] => 1
            [pageviews] => 1282
            [image] => 
        )

    [4] => stdClass Object
        (
            [id] => 204222
            [post_title] => How a night mayor can solve Tuggeranong’s nightmare
            [post_content] => When dusk settles over Tuggeranong town centre ‘Subvert City’ floods Hamish Sinclair’...
            [comment_count] => 3
            [pageviews] => 964
            [image] => 
        )

    [5] => stdClass Object
        (
            [id] => 204524
            [post_title] => See what Canberra used to look like with the click of a mouse
            [post_content] => Did you know there was once a cricket pitch where Lake Burley Griffin is today? Or that sever...
            [comment_count] => 2
            [pageviews] => 944
            [image] => 
        )

)