Help with SQL Query

Hi Guys,

I'm trying to create a query for list options, and the following works as I want:

SELECT num, CONCAT(club, ' ', day, ' :', level) eventname
FROM `<?php echo $TABLE_PREFIX ?>events`
ORDER BY eventname ASC

However, the fields club, day and level are all list options, so they display as values and I want to display as labels.  I thought the following would work, but it doesn't. 

SELECT num, CONCAT(club:label, ' ', day:label, ' :', level:label) eventname
FROM `<?php echo $TABLE_PREFIX ?>events`
ORDER BY eventname ASC

Any ideas?