Method getActiveParameterValues

public static function getActiveParameterValues($items, $ordering)
{
    $db = Factory::getDbo();
    $o = array();
    $wheres = array();
    $ordering = PhocacartOrdering::getOrderingText($ordering, 13);
    //pv
    if (!empty($items)) {
        foreach ($items as $k => $v) {
            $wheres[] = '( pp.alias = ' . $db->quote($k) . ' AND pv.id IN (' . $v . ') )';
        }
        if (!empty($wheres)) {
            // FULL GROUP BY GROUP_CONCAT(DISTINCT o.title) AS title
            $q = 'SELECT DISTINCT CONCAT(pv.id, \'-\', pv.alias) AS alias, pv.title, pp.alias  AS parameteralias, pp.title AS parametertitle FROM #__phocacart_parameter_values AS pv' . ' LEFT JOIN #__phocacart_parameters AS pp ON pp.id = pv.parameter_id' . (!empty($wheres) ? ' WHERE ' . implode(' OR ', $wheres) : '') . ' GROUP BY pp.alias, pv.alias, pv.title' . ' ORDER BY ' . $ordering;
            $db->setQuery($q);
            $o = $db->loadAssocList();
        }
    }
    return $o;
}