rameterName('attribute_name'); $orderStatsAlias = $this->wooFilterHelper->applyOrderStatusFilter($queryBuilder); $productAlias = $this->applyProductJoin($queryBuilder, $orderStatsAlias); $queryBuilder->innerJoin( $productAlias, $this->filterHelper->getPrefixedTable('postmeta'), 'postmeta', "$productAlias.product_id = postmeta.post_id AND postmeta.meta_key = :$keyParam AND postmeta.meta_value IN (:$valuesParam)" ); $queryBuilder->setParameter($keyParam, sprintf("attribute_%s", $attributeName)); $queryBuilder->setParameter($valuesParam, $attributeValues, ArrayParameterType::STRING); } }