SELECT
    client.email AS 'Email',
    clientlead.clientLeadType AS 'Wonen-OK'
FROM
    client
JOIN clientlead ON
    client.clientId = clientlead.clientId
WHERE
    email LIKE 'asd%@qwerty.com'
ORDER BY
    clientId
;