Cacher is the code snippet organizer for pro developers

function _getImage($id){  
    $db   =& JFactory::getDBO();    
    $sql  = "   SELECT
                        b.`file_url`
                FROM
                        ".$db->nameQuote('#__virtuemart_product_medias')." AS a
                INNER JOIN 
                        ".$db->nameQuote('#__virtuemart_medias')." AS b ON a.`virtuemart_media_id` = b.`virtuemart_media_id`  
                WHERE
                        a.".$db->nameQuote('virtuemart_product_id')." = ".$id."
                AND
                        b.".$db->nameQuote('file_mimetype')." = 'image/jpeg'
                AND
                        b.".$db->nameQuote('file_type')." = 'product'
                AND
                        b.".$db->nameQuote('file_is_forSale')." = '0'";

    $query = $db->setQuery($sql);
    $row  = $db->loadResultArray();
    if($db->getErrorNum()) {
        JError::raiseError( 500, $db->stderr());
    }
    if(empty($row)) $row[] = JURI::base().'images/defaultimage.jpg';
    return $row;
}