Code: Select all
$query->where('('.$where.')' . ' AND a.published = 1 AND a.approved = 1 AND c.id IN(3,4,6,33) AND c.published = 1 AND c.approved = 1 AND c.access IN ('.$groups.')');
//$query->group('a.id');
$query->order($order);
Code: Select all
$query->where('('.$where.')' . ' AND a.published = 1 AND a.approved = 1 AND c.id IN(3,4,6,33) AND c.published = 1 AND c.approved = 1 AND c.access IN ('.$groups.')');
//$query->group('a.id');
$query->order($order);