// Couldn't get short alias for LOWER(lme $children = Doctrine_Query::create()

->select( 'lnt.id, lnt.name, COUNT(lme.id) AS numElements' ) ->from( 'LogicalNavigationTree? lnt' ) ->leftJoin( 'lnt.LogicalManagedElement? lme WITH LOWER(lme.name) LIKE LOWER(?)' ) ->where( 'lnt.lft > ? AND lnt.rgt < ?' ) ->execute( array(

'%' . ( ( $search == ) ? : $search . '%' ), $recordlft?, $recordrgt?

), Doctrine::HYDRATE_ARRAY );