private function getLocationPager(sfWebRequest $request, sfDoctrineRecord $part, $partUrl)
{
return htPagerLayout::create(Doctrine::getTable('Location')->getVisibleLocationsQuery($this->getUser())->leftJoin('l.Address a')->leftJoin('a.' . $part->getTable()->getComponentName() . ' part')->leftJoin('l.CreatedBy p')->leftJoin('l.VoteLocation v')->leftJoin('l.CommentLocation c')->leftJoin('l.Profit pr')->leftJoin('pr.ProfitDetail pd')->leftJoin('pd.Fish')->andWhere('part.id = ?', $part->getId()), 'address/' . $partUrl . '?id=' . $part->getId() . '&page={%page_number}', $request->getParameter('page', 1));
}
