protected function criteriaToQuery(CriteriaInterface $criteria, &$queryParams) { $where = ''; $query = 'SELECT ' . implode(',', $criteria->getFields()) . ' FROM ' . $this->table; $filters = $criteria->getFilters(); foreach ($filters as $type => $filter) { foreach ($filter as $field => $values) { $where .= $this->conditionToWhere($field, $type, $values, $queryParams) . ' AND '; } } if (!empty($where)) { $where = substr($where, 0, -5); $query .= strlen($where) ? ' WHERE ' . $where : ''; } return $query; }