$query = Doctrine_Query::create() ->from('User u') ->where('u.id = ?', $userId) ->andWhere('u.status = ?', 'active') ->orderBy('u.lastName ASC') ->limit(10); $users = $query->execute();In this example, we are creating a new Doctrine_Query object and specifying the table from which we want to retrieve records using the `from` method. We then add filters to the query using the `where` and `andWhere` methods, specifying the criteria that the records must meet. We also sort the results based on the `lastName` field in ascending order using the `orderBy` method, and limit the number of results using the `limit` method. Finally, we execute the query and retrieve the results using the `execute` method. Overall, Doctrine_Query is a versatile and powerful tool for querying databases in PHP, and is used by many popular PHP frameworks and libraries such as Symfony and Zend Framework.