SELECT user.*, user.user_id AS userid,
(
SELECT GROUP_CONCAT(website.site_id) AS websiteIdList
FROM xcmw_website AS website
WHERE website.userid=user.user_id
AND 1=1
ORDER BY website.site_id DESC
) AS websiteIdList
, user.message_count AS posts, member.activity_level, member.activity_updated
FROM xf_user AS user
LEFT JOIN xcmw_member AS member ON member.userid=user.user_id
WHERE (user.username='frankcolt')
ORDER BY member.activity_level DESC
LIMIT 99999 OFFSET 0