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] => 195243
            [post_title] => Expensive wasteland in Woden
            [post_content] => About four years ago, a large car park between Melrose Drive and Corinna and Furzer Streets...
            [comment_count] => 1
            [pageviews] => 1890
            [image] => Alexander building
        )

    [1] => stdClass Object
        (
            [id] => 195592
            [post_title] => $14m City to Lake boardwalk, park begin to take shape
            [post_content] => The first two of 62 ten-tonne pre-cast concrete panels that will form a 150m boardwalk alon...
            [comment_count] => 8
            [pageviews] => 1852
            [image] => Concrete slab awaiting positioning. Photo: Charlotte Harper
        )

    [2] => stdClass Object
        (
            [id] => 195440
            [post_title] => Ask RiotACT: seeking person who left note on my car windscreen
            [post_content] => Hi Rioters. On Friday 16 February my Honda car was parked in the Australian National Uni...
            [comment_count] => 0
            [pageviews] => 1256
            [image] => ANU car park note
        )

    [3] => stdClass Object
        (
            [id] => 195512
            [post_title] => Man, 22, killed in Weetangera motorcycle accident
            [post_content] => A 22-year-old man died soon after a collision this afternoon between the motorcycle he was...
            [comment_count] => 0
            [pageviews] => 1199
            [image] => 
        )

    [4] => stdClass Object
        (
            [id] => 195496
            [post_title] => Does a metre matter on ACT roads?
            [post_content] => People who ride bicycles on ACT roads are concerned that police are not properly enforcing...
            [comment_count] => 11
            [pageviews] => 1197
            [image] => Cyclist photo
        )

    [5] => stdClass Object
        (
            [id] => 194756
            [post_title] => Footpath recycling dominates Dickson
            [post_content] => As a person who walks for exercise around the local area, I get to observe the changes thro...
            [comment_count] => 7
            [pageviews] => 1158
            [image] => Costigan_Dickson-0242
        )

)