rendered paste body<?php// Old version$this->pager = new sfDoctrinePager('OrderItem', 20);$this->addSortCriteria($this->pager->getQuery());$this->addFiltersCriteria( $this->pager->getQuery() ->from('OrderItem') ->leftJoin('Member') ->leftJoin('SubProgram') ->leftJoin('P2MReseller') ->where('reseller = ?', 2));// New version$currentPage = 20;$this->pager = new Doctrine_Pager( Doctrine_Query::create() ->from('OrderItem') ->leftJoin('Member') ->leftJoin('SubProgram') ->leftJoin('P2MReseller') ->where('reseller = ?', 2) $currentPage);?>