Method getParameterValuesByIds

/*
 * We don't need to care about parameter_id here as parameter_value_id is unique indepentend to its parameter group
 */
public static function getParameterValuesByIds($cids)
{
    $db = Factory::getDBO();
    if ($cids != '') {
        //cids is string separated by comma
        $query = 'SELECT pvr.parameter_value_id FROM #__phocacart_parameter_values AS a' . ' LEFT JOIN #__phocacart_parameter_values_related AS pvr ON a.id = pvr.parameter_value_id' . ' AND pvr.item_id IN (' . $cids . ')' . ' ORDER BY a.id';
        $db->setQuery($query);
        $tags = $db->loadColumn();
        $tags = array_unique($tags);
        return $tags;
    }
    return array();
}