Mine

    $c = new Criteria();
    $c->addJoin(PropertyPeer::REFERENCE, ImagePeer::PROPERTY_REFERENCE, Criteria::LEFT_JOIN);
    $c->addSelectColumn(ImagePeer::THUMBNAIL_FILENAME); 
    $pager = new sfPropelPager('Property', sfConfig::get('app_pager_list_max')); 
    $pager->setCriteria($c); 
    $pager->setPage($this->getRequestParameter('page', 1)); 
    $pager->init(); 
    $this->property_pager = $pager;




error:
[wrapped: Could not execute query [Native Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN images ON (properties.REFERENCE=images.PROPERTY_REFERENCE) LIMIT 5' at line 1] [User Info: SELECT images.THUMBNAIL_FILENAME FROM LEFT JOIN images ON (properties.REFERENCE=images.PROPERTY_REFERENCE) LIMIT 5]]