jcrawford

      $slct = $this->select();
      $slct->from( array('ip' => 'isp_partners') )
        ->join( array('ic' => 'isp_campaigns'), 'ip.isp_id = ic.isp_id' )
        ->join( array('ik' => 'isp_keywords'), 'ik.campaign_id = ic.campaign_id' );

      if ($request->getParam('campaign')) {
        $slct->where('ik.campaign_id = ?', $request->getParam('campaign'));
      }

      $slct->where( "(ik.keyword LIKE ?", "%" . $request->getQuery('sSearch') . "%" )
        ->orWhere( "ic.url LIKE ?", "%" . $request->getQuery('sSearch') . "%" )
        ->orWhere( "ic.enabled LIKE ?)", "%" . $request->getQuery('sSearch') . "%" )
        ->setIntegrityCheck(false)
        ->group('ik.keyword');

      $rowset = $slct->query()
        ->fetchAll();