/** * @return JQuery */ function _getListQuery() { // Create a new query object. $query = parent::_getListQuery(); // Filter by frontpage. if ($this->getState('filter.frontpage')) { $query->join('INNER', '#__content_frontpage AS fp ON fp.content_id = a.id'); } //echo nl2br(str_replace('#__','jos_',$query)); return $query; }
/** * override method */ function _getListQuery() { $query = parent::_getListQuery(); $aId = $this->getState('filter.a_id'); if (is_numeric($aId)) { $type = $this->getState('filter.a_id.include', true) ? '= ' : '<>'; $query->where('a.id ' . $type . (int) $aId); } else { if (is_array($aId)) { JArrayHelper::toInteger($aId); $aId = implode(',', $aId); $type = $this->getState('filter.a_id.include', true) ? 'IN' : 'NOT IN'; $query->where('a.id ' . $type . ' (' . $aId . ')'); } } return $query; }