Ignore records with no attached records

habtm_not_null.php

$options['joins'] = array(
    array('table' => 'images_news_articles',
        'alias' => 'ImagesNewsArticle',
        'type' => 'left outer',
        'conditions' => array(
            'NewsArticle.id = ImagesNewsArticle.news_article_id'
        )
    ),
    array('table' => 'images',
        'alias' => 'Image',
        'type' => 'left outer',
        'conditions' => array(
            'ImagesNewsArticle.image_id = Image.id'
        )
    )
);

$options['conditions'] = array(
    'Image.id IS NOT NULL'
);

$news_articles_with_images = $NewsArticle->find('all', $options);

In Rails:

class NewsArticle
  scope :unimaged, lambda { includes(:images).where("images.id is null") }
end

scope :imaged, lambda { includes(:images).where("images.id IS NOT NULL") }