SELECT m.userid AS id, m.name, m.email, m.job, m.alias, m.avatar, m.twitter, m.facebook
FROM `#__crc_members` AS m
INNER JOIN `#__users` AS u ON u.id = m.userid
WHERE u.block = 0 AND m.state = 1
GROUP BY u.id
ORDER BY RAND()
Trouvez le professionnel dont vous avez besoin pour concrétiser vos projets