Method getActiveManufacturers

public static function getActiveManufacturers($items, $ordering, $manufacturerAlias = 'manufacturer')
{
    $db = Factory::getDbo();
    $o = array();
    $wheres = array();
    $ordering = PhocacartOrdering::getOrderingText($ordering, 4);
    //m
    if ($items != '') {
        $wheres[] = 'm.id IN (' . $items . ')';
        $q = 'SELECT DISTINCT m.title, CONCAT(m.id, \'-\', m.alias) AS alias, ' . $db->quote($manufacturerAlias) . ' AS parameteralias, ' . $db->quote(ucfirst($manufacturerAlias)) . ' AS parametertitle FROM #__phocacart_manufacturers AS m' . (!empty($wheres) ? ' WHERE ' . implode(' AND ', $wheres) : '') . ' GROUP BY m.alias, m.title' . ' ORDER BY ' . $ordering;
        $db->setQuery($q);
        $o = $db->loadAssocList();
    }
    return $o;
}