that's not the only silly mistake..
the table's name is community_fields_valueS!
BUT i fixed those 2 errors and i still dont get the user list 
EDIT: wait a min:
now thats the response of the freichat request ... what the hack
SELECT DISTINCT u.avatar,f.status_mesg,f.username,f.session_id,f.status,f.guest,u.alias AS profile_iden,f.in_room, v.value AS country
FROM frei_session AS f
LEFT JOIN z27s5_community_users AS u ON f.session_id=u.userid
LEFT JOIN z27s5_community_fields_values AS v ON v.user_id=f.session_id
WHERE time>1407006515
AND f.session_id!=827
AND f.status!=2
AND f.status!=0
AND v.field_id=11SELECT DISTINCT u.avatar,f.status_mesg,f.username,f.session_id,f.status,f.guest,u.alias AS profile_iden,f.in_room, v.value AS country
FROM frei_session AS f
LEFT JOIN z27s5_community_users AS u ON f.session_id=u.userid
LEFT JOIN z27s5_community_fields_values AS v ON v.user_id=f.session_id
WHERE time>1407006515
AND f.session_id!=827
AND f.status!=2
AND f.status!=0
AND v.field_id=11{"userdata":[],"room_array":[{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Fun Talk","2":"Fun Talk","room_id":"1","3":"1","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Think out loud","2":"Think out loud","room_id":"3","3":"3","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Talk to me ","2":"Talk to me ","room_id":"4","3":"4","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Talk innovative","2":"Talk innovative","room_id":"5","3":"5","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Crazy chat","2":"Crazy chat","room_id":"2","3":"2","online_count":"0","4":"0"}],"room_online_count":[{"id":"1","0":"1","online_count":"0","1":"0"},{"id":"3","0":"3","online_count":"0","1":"0"},{"id":"4","0":"4","online_count":"0","1":"0"},{"id":"5","0":"5","online_count":"0","1":"0"},{"id":"2","0":"2","online_count":"0","1":"0"}],"chatroom_users_array":[],"in_room":-1,"islog":"userloggedin","status":1,"count":0,"username":"alfredopacino","userid":"827","is_guest":"0","time":"14070065950.402204001407006595","messages":[],"chatroom_messages":[],"last_chatroom_usr_id":null,"chatroom_mesg_time":"14070065950.402490001407006595"}
that's not the only silly mistake..
the table's name is community_fields_value**S**!
BUT i fixed those 2 errors and i still dont get the user list (doh)
EDIT: wait a min:
now thats the response of the freichat request ... what the hack
````
SELECT DISTINCT u.avatar,f.status_mesg,f.username,f.session_id,f.status,f.guest,u.alias AS profile_iden,f.in_room, v.value AS country
FROM frei_session AS f
LEFT JOIN z27s5_community_users AS u ON f.session_id=u.userid
LEFT JOIN z27s5_community_fields_values AS v ON v.user_id=f.session_id
WHERE time>1407006515
AND f.session_id!=827
AND f.status!=2
AND f.status!=0
AND v.field_id=11SELECT DISTINCT u.avatar,f.status_mesg,f.username,f.session_id,f.status,f.guest,u.alias AS profile_iden,f.in_room, v.value AS country
FROM frei_session AS f
LEFT JOIN z27s5_community_users AS u ON f.session_id=u.userid
LEFT JOIN z27s5_community_fields_values AS v ON v.user_id=f.session_id
WHERE time>1407006515
AND f.session_id!=827
AND f.status!=2
AND f.status!=0
AND v.field_id=11{"userdata":[],"room_array":[{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Fun Talk","2":"Fun Talk","room_id":"1","3":"1","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Think out loud","2":"Think out loud","room_id":"3","3":"3","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Talk to me ","2":"Talk to me ","room_id":"4","3":"4","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Talk innovative","2":"Talk innovative","room_id":"5","3":"5","online_count":"0","4":"0"},{"room_type":"0","0":"0","room_author":"admin","1":"admin","room_name":"Crazy chat","2":"Crazy chat","room_id":"2","3":"2","online_count":"0","4":"0"}],"room_online_count":[{"id":"1","0":"1","online_count":"0","1":"0"},{"id":"3","0":"3","online_count":"0","1":"0"},{"id":"4","0":"4","online_count":"0","1":"0"},{"id":"5","0":"5","online_count":"0","1":"0"},{"id":"2","0":"2","online_count":"0","1":"0"}],"chatroom_users_array":[],"in_room":-1,"islog":"userloggedin","status":1,"count":0,"username":"alfredopacino","userid":"827","is_guest":"0","time":"14070065950.402204001407006595","messages":[],"chatroom_messages":[],"last_chatroom_usr_id":null,"chatroom_mesg_time":"14070065950.402490001407006595"}
````