Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT COUNT(*)
FROM `table` as m
LEFT JOIN `#__users` as u
ON u.`username` = m.`memberid`
WHERE m.`memberid` = '[value]'
AND m.`firstname` = '[firstname]'
AND m.`lastname` = '[lastname]'
AND u.`id` IS NULL
Please Log in to join the conversation.
AND m.`firstname` = '[firstname]'
AND m.`lastname` = '[lastname]'
AND m.`firstname` = ''
AND m.`lastname` = ''
Please Log in to join the conversation.
Please Log in to join the conversation.