Q:

Fishpig get title, post content, post thumbnail and permalink

I am trying to get my code to return the last 3 posts from wordpress in Magento using the Fishpig extension.  This is the code I have so far, but it appears to returning posts more than once.  I also need it to just return posts, as it also returns pages at the moment. 
<? php $resource = Mage::getSingleton('core/resource');
   $readConnection = $resource->getConnection('core_read');
   $query = "SELECT p.id,p.post_title,p.post_name ,p.post_content,p.comment_count,pm.meta_value FROM wp_postmeta AS pm INNER JOIN wp_posts AS p ON pm.post_id=p.ID  ORDER BY p.post_date";
   $results = $readConnection->fetchAll($query);

   ? >
<? php 
   foreach($results as $row) { ? >
<? php if($row['post_title']!='Auto Draft'):  
   //Get url from pm.meta_value
   /********/
   $readConnection1 = $resource->getConnection('core_read');
   $query1 ="SELECT * FROM `wp_postmeta` WHERE `post_id` = '".$row['meta_value']."'  AND meta_key='_wp_attached_file'"; 
   $results1 = $readConnection->fetchAll($query1);
   $url='/news/wp-content/uploads/'.($results1[0]['meta_value']);
   ? >
<div class="blog-post-image">
   <img src="<?php echo $url; ? >">
</div>
<div class="blog-post-content">
   <? php  ? >
   <h3> <a href="<?php echo $this->getUrl('news/').$row['post_name'];? >"> <? php echo $row['post_title'];?></a></h3>
   <p class="blog-content">  <? php $content = $row['post_content'];  echo $string = substr($content,0,220); if(strlen($content)>220){echo "...";}      ? ></a></p>
   <a href="" class="blog-posts-cta">More Info</a>
</div>
<? php endif; ? >
<? php
   if($counter == 4)
   {
        break;
   }
   $counter++;   
   }

   ? >

A:

To display 3 posts and display the post title, URL, image and post content (or excerpt), you would need the following code:
<? php $posts = Mage::getResourceModel('wordpress/post_collection')
    ->addIsViewableFilter()
    ->addPostTypeFilter('post')
    ->setPageSize(3)
    ->load() ? >
<? php if (count($posts) > 0): ? >
    <ul>
        <? php foreach($posts as $post): ? >
            <li>
                <h2>
                    <a href="<?php echo $post->getPermalink() ? >"><? php echo $this->escapeHtml($post->getPostTitle()) ? ></a>
                </h2>
                <? php if ($image = $post->getFeaturedImage()): ? >
                    <a href="<?php echo $post->getPermalink() ? >" class="fimg"><img src="<?php echo $image->getAvailableImage() ? >" alt="" /></a>
                <? php endif; ? >
                <? php echo $post->getPostContent() ? >
                <? php
                /**
                 * You could also use:
                 * echo $post->getPostExcerpt(20)
                 * This would display the first 20 words of the post content
                 * or the manually entered excerpt
                 **/
                ? >
            </li>
        <? php endforeach; ? >
    </ul>
<? php endif; ? >

This has been writte quickly by hand and hasn't been tested but should work fine.