Вот такой вывод у меня
mysql_query("SELECT DISTINCT `tem_id` as `topics`,
(select CONVERT(GROUP_CONCAT(`tag_id`) USING cp1251) from `forum_temtags` where `tem_id` = `topics`)as `tags`
FROM `forum_temtags` LIMIT 10;"); Вот такой вывод у меня
mysql_query("SELECT DISTINCT `tem_id` as `topics`,
(select CONVERT(GROUP_CONCAT(`tag_id`) USING cp1251) from `forum_temtags` where `tem_id` = `topics`)as `tags`
FROM `forum_temtags` LIMIT 10;");