use label in SQL query

Hi Guys,

I'm currently using the following to show a drop-list;

SELECT num, CONCAT(title, ' $', price,' each') product
FROM `<?php echo $TABLE_PREFIX ?>products`

and I also want to show the "location" field... ie.

SELECT num, CONCAT(title, location, ' $', price,' each') product
FROM `<?php echo $TABLE_PREFIX ?>products`

however, the location field is a list which uses the num as the value, to I need to show it's label, but I can't use

SELECT num, CONCAT(title, location:label, ' $', price,' each') product
FROM `<?php echo $TABLE_PREFIX ?>products`

Any thoughts?