Link to source page not shown for items, feedapi_aggregator.module

The feedapi_aggregator.module looks like it should be showing a link to each items source when displaying the item in a list, or as a page but the source information is never loaded from the database and thus fails to be displayed. e.g.) mysite.com/aggregator or mysite.com/aggregator/sources/666

This code in theme_feedapi_aggregator_page_item() never gets called because the variable $item->ftitle is never set.

if ($item->ftitle && $item->feed_nid) {
  $source = l($item->ftitle, "aggregator/sources/$item->feed_nid", array('class' => 'feed-item-source')) .' -';
}

The culprit is the SQL query which loads the items. It should be joining the node.title of the items source but does not. The attached patch fixes this.

Steps to repeat the problem.

1. Install feedapi, and feedapi_aggregator, and set up so that it is aggregating at least one feed.
2. Visit mysite.com/aggregator after pulling content from your feed.
- The items pulled from the feed are listed however each item is missing the "Source Title" link that should be right before the items date.
3. Apply this patch and visit the page again.
- The source title should now be shown before the date for each item.