SELECT `name`, `block`, `id` FROM `#__users` WHERE block=0 ORDER BY name
Please Log in to join the conversation.
SELECT u.`id`, u.`name`
FROM `#__users` u
JOIN `#__comprofiler` ue
ON ue.`id` = u.`id`
WHERE u.`block` = 0
AND ue.`approved` = 1
AND ue.`confirmed` = 1
AND ue.`banned` = 0
ORDER BY u.`name` ASC
Please Log in to join the conversation.