Мой вариант слишком груб и непрактичен

SELECT DISTINCT uid as tempuserid,
(select a FROM answers WHERE q = '1' and uid = tempuserid) AS answer1,
(select a FROM answers WHERE q = '2a' and uid = tempuserid) AS answer2,
(select a FROM answers WHERE q = '2c' and uid = tempuserid) AS answer3,
(select a FROM answers WHERE q = '3a' and uid = tempuserid) AS answer4,
(select a FROM answers WHERE q = '3b' and uid = tempuserid) AS answer5,
(select a FROM answers WHERE q = '4_1' and uid = tempuserid) AS answer6,
(select a FROM answers WHERE q = '4_2' and uid = tempuserid) AS answer7,
(select a FROM answers WHERE q = '4_3' and uid = tempuserid) AS answer8,
(select a FROM answers WHERE q = '4_4' and uid = tempuserid) AS answer9,
(select a FROM answers WHERE q = '4_5' and uid = tempuserid) AS answer10
FROM `answers`