Please Log in to join the conversation.
SELECT ue.*, u.*, '' AS 'NA'
FROM `jos_users` u
INNER JOIN `jos_comprofiler` AS ue
ON ue.`id` = u.`id`
WHERE u.`block` = 0
AND ue.`approved` = 1
AND ue.`confirmed` = 1
AND ue.`banned` = 0
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.