<?php

function getConcat($id) {
    $group = "GROUP_CONCAT(if(optionid = %d, value_name, NULL)) AS `%s`";

    $groups = array(
        1  => 'Color',
        2  => 'Size',
        18 => 'Length',
        20 => 'Ring Size',
        22 => 'Crystal Color',
        24 => 'Rack',
        25 => 'Gauge',
        26 => 'Pincher Size',
        33 => 'Pieces in Pack',
        34 => 'Size in Pack',
        35 => 'Height'
    );

    if ((!is_string($id) && !is_numeric($id)) || !isset($groups[$id])) {
        return '';
    }

    return sprintf($group, $id, $groups[$id]);
}

echo getConcat(22)."\n\n";
echo getConcat(50)."\n\n";
echo getConcat(35)."\n\n";
echo getConcat(18)."\n\n";
echo getConcat(1)."\n\n";

?>

GROUP_CONCAT(if(optionid = 22, value_name, NULL)) AS `Crystal Color`



GROUP_CONCAT(if(optionid = 35, value_name, NULL)) AS `Height`

GROUP_CONCAT(if(optionid = 18, value_name, NULL)) AS `Length`

GROUP_CONCAT(if(optionid = 1, value_name, NULL)) AS `Color`