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] => 216798
            [post_title] => GoBoat launches Canberra adventures on the lake with European pizazz
            [post_content] => A new Canberra attraction takes to the water in the next six weeks with potential appeal for e...
            [comment_count] => 2
            [pageviews] => 3180
            [image] => 
        )

    [1] => stdClass Object
        (
            [id] => 216634
            [post_title] => It's almost burger time at Mookie
            [post_content] => What if I told you there’s a place doing premium burgers that don't cost a bomb; that is per...
            [comment_count] => 0
            [pageviews] => 2870
            [image] => Mookie Burger
        )

    [2] => stdClass Object
        (
            [id] => 216959
            [post_title] => Mookie launch this Thursday - FREE burgers, concretes, fries
            [post_content] => What's more amazing than delicious Mookie burgers? FREE delicious Mookie burgers! Mookie is of...
            [comment_count] => 0
            [pageviews] => 2338
            [image] => 
        )

    [3] => stdClass Object
        (
            [id] => 217209
            [post_title] => Stunning and spacious rural home just 25 minutes’ drive from Canberra’s CBD
            [post_content] => A stunning large family home with breathtaking views over the Clare Valley has gone on the mar...
            [comment_count] => 0
            [pageviews] => 1514
            [image] => 
        )

    [4] => stdClass Object
        (
            [id] => 217065
            [post_title] => Canberra company ranked one of Australia's Best Places to Work expands local team
            [post_content] => Local professional services firm Cordelta, named in the top 10 best places to work in Australi...
            [comment_count] => 0
            [pageviews] => 1325
            [image] => Cordelta Team
        )

    [5] => stdClass Object
        (
            [id] => 217041
            [post_title] => $4 million grants program to help Canberra households store solar energy
            [post_content] => Canberra households looking to store solar energy to use during peak energy pricing times in t...
            [comment_count] => 4
            [pageviews] => 1030
            [image] => 
        )

)