Q&A for software developers, mathematicians and others interested in cryptography
Select distinct u1.id,u1.location,u2.location from users u1 left join users u2 ON u1.location=u2.location where u1.location like '%new%' and u1.id=u2.id order by u1.id,u1.location