SELECT distinct users.average_rating, users.cities_id, xref_users_competences.id as xrefid, users.acceptsallworkgroups, users.email, users.id as user, cities_id, users.city as name, users.versionid_image, competences.parent_id as compid, competences.name as compname, xref_users_competences.competences_id, users.firstname, users.lastname, users.createdon, users.acceptsallworkgroups, users.profilepicture, competences.id, competences.name AS competence_name, xref_users_competences.maxkm, xref_users_competences.id AS comp, xref_users_competences.deleted, xref_users_competences.comments, xref_users_competences.functions, xref_users_competences.active, xref_users_competences.searching_or_offering FROM users JOIN xref_users_competences ON xref_users_competences.users_id = users.id AND xref_users_competences.deleted = 0 AND xref_users_competences.active = 1 and xref_users_competences.maxkm = 1000 JOIN competences ON xref_users_competences.competences_id = competences.id AND competences.parent_id = 20 AND competences.parent_id = 20 WHERE users.acceptsallworkgroups = 1 ORDER BY average_rating DESC LIMIT 0,20