Please Log in to join the conversation.
SELECT cb.`FIELD_NAME`
, (
SELECT GROUP_CONCAT( IF( fv.`fieldlabel` != '', fv.`fieldlabel`, fv.`fieldtitle` ) SEPARATOR ', ' )
FROM `#__comprofiler_field_values` AS fv
INNER JOIN `#__comprofiler_fields` AS f
ON f.`fieldid` = fv.`fieldid`
WHERE f.`name` = 'FIELD_NAME'
AND FIND_IN_SET( fv.`fieldtitle`, REPLACE( cb.`FIELD_NAME`, '|*|', ',' ) ) != 0
) AS 'FIELD_NAME_labels'
FROM `#__comprofiler` AS cb
Please Log in to join the conversation.
Please Log in to join the conversation.