1. Change the charset of domain to latin1. (After all, why would the domain be in utf8 if the url is in latin1?) 2. ADD INDEX(domain, url) Note: MyISAM has a limite of 1000 bytes for indexes, hence the need to switch to latin1. This INDEX will allow the subquery to be...