EGroupware / egroupware

			// only check columns and non-aggregate functions

			if (strpos($col, '(') === false || !preg_match('/(COUNT|MIN|MAX|AVG|SUM|BIT_[A-Z]+|STD[A-Z_]*|VAR[A-Z_]*|ARRAY_AGG)\(/i', $col))

			{

				if (($pos = stripos($col, 'DISTINCT ')) !== false)

				{

					$col = substr($col, $pos+9);

				}

				$alias = $col;

				if (stripos($col, ' AS ')) list($col, $alias) = preg_split('/ +AS +/i', $col);

				// do NOT group by constant expressions

			$distinct_checked = false;

			foreach(is_array($only_keys) ? $only_keys : explode(',', $only_keys) as $col)

			{

				if (!$distinct_checked)

				{

					if (stripos($col, 'DISTINCT ') === 0) $col = substr($col, 9);

					$distinct_checked = true;

				}

				if (!$col || $col == '*' || $col == $this->table_name.'.*')	// all columns

				{

					$cols = array_merge($cols,$this->db_cols);