```sql select substring(email,locate("@",email)+1) as em,count(*) as ct from p2p_user_search where email REGEXP "^[a-z0-9\._-]+@[a-z0-9\.-]+\.[a-z]{2,4}$" group by em order by ct desc ```
