解析错误:语法错误，意外的“，-2”，(T_CONSTANT_ENCAPSED_STRING)，期望“，”或“;”

"select " . TABLE_PREFIX.DB_USERTABLE . "." . DB_USERTABLE_USERID .
" userid, " . TABLE_PREFIX.DB_USERTABLE . "." . DB_USERTABLE_NAME .
" username, " . TABLE_PREFIX.DB_USERTABLE . "." . DB_USERTABLE_NAME .
" link, " . DB_AVATARFIELD .
" avatar,substring_index(substring_index(wp_usermeta.meta_value ,'"',-2),'"',1) role from  " .
TABLE_PREFIX.DB_USERTABLE .
"left join wp_usermeta on " . TABLE_PREFIX.DB_USERTABLE .
"." . DB_USERTABLE_USERID .
"= wp_usermeta.user_id  left join cometchat_status on " .
TABLE_PREFIX.DB_USERTABLE . "." . DB_USERTABLE_USERID .
" = cometchat_status.userid " . DB_AVATARTABLE .
" where (select count(*) from wp_bp_friends where (initiator_user_id='" .
$userid .
"' and friend_user_id=wp_users.ID) or (initiator_user_id=wp_users.ID and friend_user_id='" .
$userid .
"'))=1 and wp_usermeta.meta_key = 'wp_capabilities' order by username asc"
"select " . TABLE_PREFIX.DB_USERTABLE . "." . D