SELECT EmailUpdateClickThru.MLSNo,EmailUpdateClickThru.clickThruDate,EmailUpdateAccounts.clientCID,EmailUpdateAccounts.EmailAddress  FROM `EmailUpdateClickThru` inner join EmailUpdateAccounts on EmailUpdateAccounts.emailUpdateID = EmailUpdateClickThru.sid where EmailUpdateAccounts.clientCID =  and EmailUpdateAccounts.EmailAddress = '' and EmailUpdateClickThru.clickThruDate > '2012-04-22' order by EmailUpdateClickThru.EUCTID DESC